Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]

How would you rate each of them in terms of:

  1. Performance
  2. Speed of development
  3. Neat, intuitive, maintainable code
  4. Flexibility
  5. Overall

I like my SQL and so have always been a die-hard fan of ADO.NET and stored procedures but I recently had a play with Linq to SQL and was blown away by how quickly I was writing out my DataAccess layer and have decided to spend some time really understanding either Linq to SQL or EF… or neither?

I just want to check, that there isn’t a great flaw in any of these technologies that would render my research time useless. E.g. performance is terrible, it’s cool for simple apps but can only take you so far.

Update:
Can you concentrate on EF VS L2S VS SPs rather than ORM VS SPs. I’m mainly interested by EF VS L2S. But am keen to have them compared against stored procs too since plain SQl is something I know a lot about.

5 Answers
5

Leave a Comment