5

What is the differences between those 2 assuming I'm using SQL Server as my database? Are they the same?

Cœur
  • 37,241
  • 25
  • 195
  • 267
Funky81
  • 1,679
  • 4
  • 18
  • 24

3 Answers3

4

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

rbrayb
  • 46,440
  • 34
  • 114
  • 174
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.

Paul Kapustin
  • 3,297
  • 5
  • 35
  • 45
1

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

KristoferA
  • 12,287
  • 1
  • 40
  • 62