1 / 17

LINQ for SQL: The Power of Object-Relational Mapping

Explore LINQ and ORM concepts, SQL vs. LiNQ abstraction, querying objects, and benefits such as dynamic types and lamda expressions.

kylie-bauer
Télécharger la présentation

LINQ for SQL: The Power of Object-Relational Mapping

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 for SQL • SQL Saturday May 2009 • David Fekke

  2. Who am I? • David Fekke • davidfekke@gmail.com • Software Engineer at LPS • Reformed DBA/Sharepoint developer • JaxFusion.org

  3. LINQLanguage Integrated Query

  4. ORMorObject Relational Mapper

  5. .NET 3.5 Framework

  6. SQL vs. LiNQ

  7. Abstraction

  8. SQL Server 2005/8

  9. MySQL • PostgreSQL • Other RDBMS supported by Open Source

  10. Oracle ProviderThrough DevArt

  11. IQueriable Interface

  12. Query Objects • Query XML • Query Databases

  13. var myQuery = from p in db.people • where p.firstname == “David” • select p

  14. LINQ makes use .NET 3.5 language features

  15. C# 3.0VB .NET 9.0

  16. Lamda ExpressionsAnonymous TypesDynamic Types

  17. Pros and Cons • Visual Studio Generates Object code • No reason to create separate queries for each RDBMS • Auto parametrize variables • Use Stored Procedures • No hinting • careful about in memory querying • SQL Statements are auto-generated with the exception of Stored Procs

More Related