Transcript Slide

www.SQLskills.com
http://www.SQLskills.com/blogs/bobb
Code Type
Model Loc
Language
Notes
Stored Procedures
SSDL
In Database
Executed with
ExecuteFunction or
context.ProcName
UDF
SSDL
In Database
Usable in ESQL only
Model-Defined Functions
CSDL
ESQL
Can return scalar, Entities,
or RowType
QueryView
MSL
ESQL
Written against store
model
Replaces entity mapping
to store
Native Queries
SSDL
SQL
Function with
CommandText element
DefiningQuery
SSDL
SQL
Looks like a view, create
CSDL and MSL manually
www.microsoft.com/teched
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn