ADO.NET Connections and Commands
Overview/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
Target Audience
C# programmers and candidates for the Microsoft MCSD and MCAD certification paths
Prerequisites
A good knowledge of C# language, SQL, relational databases, and Visual Studio .NET
Expected Duration
220 Minutes
Objectives:
ADO.NET Connections and Commands
select the ADO.NET features that facilitate the disconnected data-access model.
order the steps to update a database using a DataAdapter.
identify the steps to open a connection to a data source using the Connection object.
select the correct procedures to create a secure database connection.
select the attribute settings for the SQLConnnection.ConnectionString to enable a specific connection pooling.
select appropriate connection properties in a connection string, handle connection events, and manage connection pools.
identify how the Command object facilitates both the connected and disconnected data-access models.
identify the correct steps to create a Command object for a particular query.
select the correct steps to access a database when using a DataReader.
process database records using the DataReader object.
identify the steps to use the Command object to access and use a stored procedure.
Course Number: 129900_eng