|
ADO.NET Connections and Commands
(Duration: 3:40:00)
Price: $39.00
Course Code:
129900_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
- - select the ADO.NET features that facilitate the disconnected data-access model.
- • Architecture of ADO.NET
- - order the steps to update a database using a DataAdapter.
- • Defining an ADO.NET Connection object in C#
- - identify the steps to open a connection to a data source using the Connection object.
- • Working with ADO.NET connections in C#
- - select the correct procedures to create a secure database connection.
- • Pooling ADO.NET connections in C#
- - select the attribute settings for the SQLConnnection.ConnectionString to enable a specific connection pooling.
- • Creating ADO.NET connections in C#
- - select appropriate connection properties in a connection string, handle connection events, and manage connection pools.
- • Connected data access
- - identify how the Command object facilitates both the connected and disconnected data-access models.
- • Executing ADO.NET Command objects in C#
- - identify the correct steps to create a Command object for a particular query.
- • ADO.NET DataReaders using C#
- - select the correct steps to access a database when using a DataReader.
- • Using ADO.NET commands and DataReaders with C#
- - process database records using the DataReader object.
- • Managing stored-procedure parameters in C#
- - identify the steps to use the Command object to access and use a stored procedure.
|