Which O/R mapping tool are you using with .NET

[Bobh]

Which O/R mapping tool are you using with .NET

[karimgarza]

My Team and I have created a mapping tool not as perfect as ORM.NET, but we can acomplish the same goals. Our tools create storeprocedures, forms, DataClasses, and Active Reports and is 100% Object Oriented. It took us about 1 month to build them but we are saving a lot of time, What it used to take us three hours now takes us less than one second.

[csharpener]

(IMHO) Orm.Net is pretty kewl but would be better if it could create objects based on views as well as tables.... (or does it?) still requires complex joins in code (using JoinPath or FetchPath) even though they are known at the time of layer generation... If I ever get time off work I'd like to extend the OrmLib in this direction...

[jssk]

Well, there was no need for object/relational mapping in a project with pretty simple database model I had worked on. Use DataReader or DataSet here and there, show values, update database, it worked fine.

Now, in another application with more than 200 tables and 400 relationships among them, I was not confident with the future maintenance especially for schema change if I used O/R mapping. I searched for object database, found only one with a good .NET interface, Matisse. Still in the middle of development, so far so good.

[XyBoy]

I'm currently looking at a free library to operate the object/relational mapping : OPF.Net. I'm not sure it is as efficient as ORM.Net, but it has already a lot of features and it is probably a good project to get involved in !

[VBAHole22]

Is there a free alternative out on the market for folks who refuse to pay for this kind of software?