LINQ to SQL. Any prospects?

Question

Hi2all!
Can you tell me, please, what prospects of LINQ to SQL technology? Can I use it in my real projects, and for what kind of project I can use it (big or only simple projects, small db - about 30 tables)? Or it better now to use EF?
So, can anybody explain me?

Thank you.

Answer 1

It's not under active development by MS, but if you're using SQL Server, and Linq to SQL does what you need, then there is no reason not to use it.

Answer 2

You can use Linq to Sql if you want, however, the data access technology going forward from Microsoft is the Entity Framework.

Entity Framework does have benefits over Linq to Sql many of which you can read about on blog posts online.

As for who uses Linq to Sql, last time I checked, stackoverflow uses it as their data access technology.