cyberjoe
01-07-2007, 02:01 PM
What experience do you have with O/R mapper in .NET?
I need to choose one for use in my company
Which one is the best for you?
I have seen lots of positive feedback about this one:
LLBLGen Pro
What do you thing about this? Is it good or can I find better alternative?
Regards
cyberjoe
jjinno
01-11-2007, 10:18 AM
Really it all depends on what you are doing here.
Biggest thing to remember especially when working in Microsoft stuff like .NET is to Keep It Simple Stupid. In other words don't abstract more than you have to, but don't make more work for yourself either.
I mean if you have a DB that (for example) holds only a single element, or maybe two fields like user & MD5 pass, then I wouldn't bother with anything beyond my own call straight into the DB... no ORM needed.
On the contrary I know DBs can become complicated, and there is always a benefit to the OO-type access. Unfortunately, with anything other than coding your own ORM from scratch, you are probably gonna end up with some convoluted solution in the end. Your choice.
This is my opinion, but I don't remember working on a project with a DB where I didn't have a custom-made ORM for it... and I think that has worked to my advantage.