Murach's ADO.NET 3.5, LINQ,
and the Entity Framework with VB 2008
How to work with connections, commands,
and data readers
This chapter shows you how to use connections, commands, and data readers for building 3-layer applications, the way the professionals do. At the end of this chapter, you'll be building simple 3-layer applications of your own.
|
|
|
|
How to create and work with connections |
200 |
|
How to create a connection string
using the SqlConnectionStringBuilder class |
202 |
|
How to create a connection in
a Using block |
202 |
|
How to create and work with commands |
204 |
|
|
How to create and work with a
data reader |
206 |
|
How to improve the efficiency
of column lookups |
208 |
|
|
The user interface |
210 |
|
The class design |
210 |
|
The code for the Invoice class |
212 |
|
The code for the InvoiceDB class |
214 |
|
The code for the PayablesDB class |
214 |
|
The code for the Invoices by Due
Date form |
216 |
|
|
How to execute a query that returns
a scalar value |
218 |
|
How to execute an action query |
218 |
|
|
|
|
|
|
