| |
|
| |
ADO.NET Connections and Commands Training Class |
|
| |
|
|
| |
|
|
| |
ADO.NET Connections and Commands Training Seminar
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Price |
|
| |
$74.95
|
|
| |
|
|
| |
Agenda |
|
| |
Distributed data-access requirements
- describe the features required of a distributed or disconnected data-access system tuned for web services and web applications.
Architecture of ADO.NET
- describe the broad architecture of ADO.NET, set out its object model, and list its main objects.
Defining an ADO.NET Connection object in VB.NET
- choose between the different .NET data providers and create a connection string.
Working with ADO.NET connections in VB.NET
- open and close connections to data sources, handle connection events, and deal with exceptions.
Pooling ADO.NET connections in VB.NET
- explain why connection pooling is necessary and describe how to pool connections.
Creating ADO.NET connections in VB.NET
- select appropriate connection properties in a connection string, handle connection events, and manage connection pools.
Creating stored procedures in Visual Studio .NET
- describe how to create and use stored procedures and parameters in Visual Studio.NET and ADO.NET.
Managing stored-procedure parameters in VB.NET
- describe how to set input parameters and access return values and output parameters in stored procedures.
Coding for stored procedures in VB.NET
- call stored procedures using command objects and define input and output parameters for them.
Connected data access
- describe the reasons for direct database access and how this is performed in ADO.NET.
Executing ADO.NET Command objects in VB.NET
- explain how to execute Command objects for returning no values, single values, or to run DDL and DML commands.
ADO.NET DataReaders using VB.NET
- explain how to process rows of read-only data from a data source.
Using ADO.NET Commands and DataReaders with VB.NET
- process rows of data from a DataReader and extract metadata about rows.
|
|
|
|
| |
|
|
| |
Audience |
|
| |
Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths
|
|
|
| |
|
|
| |
Pre-Requisites |
|
| |
Good knowledge of VB.NET, SQL, relational databases, and Visual Studio .NET
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|