For last few years , I had the opportunity to try LINQ to SQL and Entity Framework and have been using Entity Framework successfully in couple of my projects.
It’s not only LINQ to SQL or Entity Framework but there are various others ORMs available for the developers .
- DevExpress’s XPO – eXpressPersistent Objects
- MindScape’s LightSpeed
- LLBLGen Pro
How do you choose the right ORM for developing ASP.NET Application ?You might be interested to read LIKE operator in LINQ
In my opinion , there is nothing like good or bad . Almost all the ORM’s available pretty much does the same . There are pros and cons with each one and selection merely depends on the team , expertise and the company .
Some of the things that can help you to select the ORM can be
- Kind of Support and the community help that you can receive for the ORM.
- Ease of use
- The type Application you are developing and how well the ORM is adapted for it.
- Licensing model.
What’s your take on the ORMs ? Which one would you choose and why ? . Share your views in the comments section.