LINQ for SQL

1
LINQ for SQL

• SQL Saturday May 2009
• David Fekke

2
Who am I?

• David Fekke
• davidfekke_at_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