Table of Contents
The Story behind the Succinctly Series of Books ................................................................. 6
About the Author ..................................................................................................................... 8
Introduction .............................................................................................................................. 9
Tools ..................................................................................................................................... 9
Chapter 1 SQL Server Management Studio..........................................................................10
Chapter 2 ADO.NET ...............................................................................................................18
Establishing a connection .....................................................................................................18
The connection string.......................................................................................................18
Creating a connection ......................................................................................................19
Configuring your connection string ...................................................................................20
Building a connection string .............................................................................................21
Querying your database .......................................................................................................21
Reading data ...................................................................................................................22
Parameterization ..............................................................................................................26
Create, update, delete .....................................................................................................29
Stored procedures ...........................................................................................................32
Data sets .........................................................................................................................33
ADO.NET abstractions .........................................................................................................36
Chapter 3 Entity Framework Database First ........................................................................38
Database First ......................................................................................................................38
IQueryable ............................................................................................................................41
Expression trees ...................................................................................................................45
CRUD ...................................................................................................................................47
Chapter 4 Entity Framework Code First ...............................................................................50
评论0