score:6
L2S will continue to be supported from what I understand, from what I recall from the last PDC, all focus is being put on L2E for .NET 4.0.
From my experimenting with the current state of L2E, its 'less than adequate'. Especially in the speed area. I did some simple performance testing, and my L2S queries were sometimes 2-4x faster than L2E, and that is even with precompiling the L2E views.
score: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
score:1
Can you use NHibernate instead? It's very mature and has huge support from the community.
score:6
LINQ to SQL is for apps which will only use SQL, ever.
Entity Framework is for apps which need to provide a pluggable backend (Oracle, MySQL, SQL, XML, etc) datasource.
My philosophy on rumors is to use what makes sense for the project at hand that you consider stable and worry about "support" when you get official statements from MS (or any other company) positively or negatively to that effect. As of right now both are supported.
Source: stackoverflow.com
Related Articles
- Linq to SQL vs Entity Framework, Microsoft support for
- SQL subquery result in LINQ and Entity Framework Code First
- LINQ to Entities Does not Support Invoke in Entity Framework
- how to select data by linq in many-to-many relationship in First code Entity framework 5
- LINQ - Entity framework code first - Grouped results to custom class
- Does Linq in Entity Framework code first use SQL or does it get the whole table first?
- Entity Framework Complex LINQ Support
- Entity Framework 4 and Linq to Entities specifications: How to code it?
- Getting InvalidCastException when trying to implement sorting in Entity Framework Code First using Linq
- c# WPF bind combobox to TPH in Entity Framework code first using LINQ
- Proper Linq Query for objects with many to many relation ship generated with code first entity framework
- Code First Entity Framework Linq Statement Returning Missing Records
- Entity Framework dynamic linq where from generic source with dynamic where clause
- Support for entity framework Linq statement (with a subquery)?
- Entity Framework Code Most First Efficient Linq Query
- Entity Framework Code First - The entity or complex type cannot be constructed in a LINQ to Entities query
- Entity framework linq query Include() multiple children entities
- How to avoid Query Plan re-compilation when using IEnumerable.Contains in Entity Framework LINQ queries?
- How can I do a Union all in Entity Framework LINQ To Entities?
- What are the Java equivalents to Linq and Entity Framework
- Should the order of LINQ query clauses affect Entity Framework performance?
- Distinct on Multiple Columns Entity Framework LINQ
- How to wrap Entity Framework to intercept the LINQ expression just before execution?
- Entity Framework Linq query: .Where chain vs &&
- The LINQ expression node type 'Invoke' is not supported in LINQ to Entities in entity framework
- Which LINQ statements force Entity Framework to return from the DB?
- Entity Framework with LINQ aggregate to concatenate string?
- Entity Framework 6 Code First Custom Functions
- Filtering include items in LINQ and Entity Framework
- Is an outer join possible with Linq to Entity Framework
- How would I pivot this object using linq?
- LINQ throwing invalid cast exception on a bigint
- .net expando object and LINQ. Possible or not?
- How to execute a linq query for each item in a list , use it in the where clause and return a collection from the result of each query?
- How to find (and remove) a nested object from a List
- Implement LINQ to SQL/Entity like behavior in custom object
- LINQ - Group List<T> to Year, Month, Day
- Split and select specific elements
- Linq Left Outer Join with Count
- LINQ generic function for find in a enumerable
- Distinct() doesn't work
- LINQ - How do I compare the first two items in a group then the next?
- Why an error occurs after I modified my model class?
- Slow performance in getting model from list model using enumerable linq
- Using LINQ to get a string from a tab delimited text file into an array in the way I want
- Linq with case condition within the same table and count from other table in where condition
- Linq - How to aggregate the results of another query
- What linq reference am I missing?
- How to avoid memory overflow when querying large datasets with Entity Framework and LINQ
- What's the relationship between streamjs and linqjs
