Which is the another option rather than LINQ to SQL in ASP.NET MVC?

Question

HI, I am currently using the ASP.NET MVC pattern for my small application. I am using LINQ to SQL to manipulate with objects of model. I am using lambda and queries to manipulate. But as i found lot of limitations with LINQ to SQL concept I am planning to remove. so which is the best option rather than LINQ to SQL for manipulation with data in ASP.NET MVC 2?

Answer 1

Entity Framework or nHibernate if you want something similar to LINQ to SQL but with a fuller feature set.

You might also want to check out Subsonic if you're familiar with the ActiveRecord pattern.

Answer 2

One popular and widely used/supported option for an ORM is NHibernate.

Answer 3

• Microsoft ADO.NET Entity Framework

• Castle Project ActiveRecord