1 / 12

LINQ to SQL LINQ to Entities

LINQ to SQL LINQ to Entities. Howard Richards howard@conficient.com. ORM Shootout. LINQ to SQL LINQ to Entities. LINQ to SQL. ORM Shootout. What is LINQ to SQL?. Data provider for LINQ History: First LINQ provider - “kick the tyres” Part of .NET 3.5 released 2008 Microsoft’s first ORM?

oni
Download Presentation

LINQ to SQL LINQ to Entities

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LINQ to SQLLINQ to Entities Howard Richardshoward@conficient.com ORM Shootout

  2. LINQ to SQLLINQ to Entities LINQ to SQL ORM Shootout

  3. What is LINQ to SQL? • Data provider for LINQ • History: • First LINQ provider - “kick the tyres” • Part of .NET 3.5 released 2008 • Microsoft’s first ORM? • Future • “de-emphasised” not “dead” • Improvements and fixes in .NET 4.0 • But.. EFv4 is the future

  4. Why Should I use L2S? • Simple and easy to use • Very fast (low overhead) • Tools like LinqDataSource • Shared LINQ approach • Maturing • Free!

  5. Why Shouldn’t I use L2S? • MS SQL Server only • Microsoft not developing further • Limitations in mapping • Not as powerful as Entity Framework • Toolset issues – see Huagati • Not open source • Limitations e.g. Batching, bulk updates

  6. L2S and L2E compared

  7. How does it rate as an ORM?

  8. How Does It Work? • DataContext • Partial classes • POCO • LINQ to query • LinqDataSource – ASP.NET • Demo ?

  9. Performance Source: ormbattle.net

  10. Performance Source: ormbattle.net

  11. Performance Source: ormbattle.net

  12. Performance Source: ormbattle.net

More Related