Linq to SQL and Entity Framework Diffrences ?

Question

Anyone know what is the diffrences between those 2 asumming I'm using SQL Server as my database ? Are they the same ?

Answer 1

Long answer: google. Short answer: using entity framework, you will be able to create something based on classes (partial, that you can "extend") resembling domain objects (not true DDD though, that's why NHibernate still exists and linq to nhibernate is being developed), using sql you will be just thinking database and tables.

Answer 2

This post points to some info. in particular 3 main differences:

• The ability to query relational stores other than Microsoft SQL Server

• A full textual query language not limited to LINQ's language support

• Advanced mapping facilities, such as mapping a single class to multiple tables

Answer 3

See this semi-related question:

http://stackoverflow.com/questions/276433/do-you-think-its-advantageous-to-switch-to-entity-framework

Answer 4

The Dec 2008 issue of Visual Studio Magazine cover story by Roger Jennings is a good read on the topic, with some L2S vs EF side-by-side comparisons:

http://visualstudiomagazine.com/features/article.aspx?editorialsid=2583