As I am a beginner to ASP.NET MVC, I would like to know what are the best data access methods for ASP.NET MVC?
3 Answers
This is somehow subjective. There's no such thing as best data access method for ASP.NET MVC. This will depend on your application requirements and specific needs. There are many different ORM frameworks you can choose from such as NHibernate, Entity Framework, Linq to SQL, ... (If there was a best framework this list wouldn't be so big).

- 1,023,142
- 271
- 3,287
- 2,928
-
Thanks Darin for ur valuable answer .. one more thing i really want to know what data access method stackoverflow.com uses? – ACP Nov 18 '09 at 07:28
-
If I am not mistaken in the beginning it was Linq-to-SQL but maybe they upgraded to Entity Framework. – Darin Dimitrov Nov 18 '09 at 07:31
-
I know this is old but I'd thought I'd add that as of now Dapper Orm is in use by StackOverflow. – Terrance Feb 18 '13 at 14:05
As ASP.NET MVC is all about TDD and separation of concerns it is more natural to use any type of ORM for data access (NHibernate, Entity Framework, LINQ to SQL etc.). What type of ORM - depends on your project goals and experience.

- 1,547
- 16
- 31
If you're just learning MVC, and are ok with SQL server, then I would recommend using Linq to SQL for a start. Later you can then introduce more powerful ORM like NHibernate or EF. If you try to tackle MVC and something like NHibernate at once you will likely bite off more than you can chew.

- 31,444
- 34
- 152
- 221
-
ok sosh i ll give a try with linq to sql.... what data access method stackoverflow.com uses? – ACP Nov 18 '09 at 07:30
-
Actually Stackoverflow uses Linq to SQL (to the best of my knowledge). Personally I don't like the lock in to MSSQL, but it obviously can perform. – UpTheCreek Nov 18 '09 at 15:47