|
ADO.NET Connections and Commands
(Duration: 4:20:00)
Price: $37.00
Course Code:
73686_eng
Course Catalog(s):
Course Provider:
SkillSoft
12 months
Description:
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design
Sections:
- • 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.
|