LINQ to SQL - not just SQL Server?
|
In the LINQ Forums, someone asked about the differences between LINQ to SQL and Entity Framework. I waited a few days for an official response (i.e. from Microsoft). Not seeing one, I wrote a reply myself explaining the differences from the perspective of what I have been working on. One of the points I brought up was that LINQ to SQL is only for SQL Server where LINQ to Entities will have many providers to inegrate with. Matt Warren (from Microsoft) wrote a follow up in the thread saying that LINQ to SQL actually stands for LINQ to 'databases that use SQL' or in other words LINQ for the relational data model. This is something I haven't ever realized. I am still trolling around for examples or explanation of other relational databases whose providers we will be able to connect to with LINQ to SQL, but until then, it's an important point to keep in mind. |
Comments (3)
It's interesting that you brought this topic up while I was writing a long post on the subject. My conclusion: IBM will deliver a LINQ to SQL provider for DB2 and maybe VistaDB will get one near Orcas RTM, but I think it's no better than 50/50 that SQL Server Compact Edition will get one because it already has a LINQ to Entities provider in the oven.
See http://oakleafblog.blogspot.com/2007/04/future-linq-to-sql-support-for-multiple.html .
Cheers,
--rj
Posted by Roger Jennings | April 19, 2007 7:10 PM
Well SQL Server Compact is going to get its LINQ to SQL provider, that too in Orcas Beta 2 itself.
Posted by Pragya | July 3, 2007 12:41 AM
Here I found this http://www.linqhelp.com/linq-resources/linq-c-learning-guide/. A beginner guide for the uses of linQ
Posted by Nestor G | July 31, 2008 11:40 AM