Linq to SQL
Possible Duplicates:
Is LINQ to SQL DOA?
I am starting a new ASP.Net project that contains all data in a SQL database. I would normally use Linq to SQL to do all my queries, updates, and inserts. but as I recently found out Microsoft will no longer develop / maintain Linq for SQL. What would you use as an alternative?
Does anyone know why they are dropping this as I came to as Linq to SQL and do you know they will replace it?
Any information would be great.
a source to share
Linq to SQL is neither dead nor replaced by EF , they didn't kill it, feel free to compare and contrast
- Linq to SQL
- Entity Framework (aka Linq to Entities)
- nHibernate or any other ORM
Pick one that works for you and sticks to it and doesn't die.
FWIW, Microsoft has more developers working with Linq to SQL than currently working on MVC.net
I prefer Linq to SQL because I don't need to support non MSSQL db and it's much easier than EF. It doesn't support everything you need, but in my opinion (and I can get the flame for that) Linq to SQL is MVC.net since EF is for web forms.
EF obviously has its advantages over Linq to SQL, but there are a few things that linq for sql just doesn't support (db cross joins, non-mssql databases, view-based type creation, etc.). Each tool has its place.
Some worthy comparisons on two
a source to share
Microsoft is now pushing Entity Framework instead of Linq to SQL:
MSDN Information for Entity Platform: http://msdn.microsoft.com/en-us/library/aa697427(VS.80).aspx
Update: For a more complete list of Entity framework resources: http://blogs.msdn.com/wriju/archive/2009/03/10/ado-net-entity-framework-resources.aspx
And of course O'Reilly's obligatory book on the topic: http://fyi.oreilly.com/2009/02/introducting-the-adonet-entity.html
a source to share
if you use ANY technology, prepare yourself to end up giving up on the good and not being the newest technology!
unless you choose Linq, whatever you use will end up being "old" and people will ask if it's worth learning or using as there are better things.
if you write software, prepare to keep learning new technologies and techniques, or switch careers.
a source to share