|
Provided by: 123-CBT Computer Based Training ADO NET Connections and Commands |
 |
Training
Provided by 123-CBT Computer Based Training
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design
|
|
||||||||
ADO NET Connections and Commands
Overview:
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected designPre-Requisites:
A good knowledge of C# language, SQL, relational databases, and Visual Studio .NETTarget Audience:
C# programmers and candidates for the Microsoft MCSD and MCAD certification pathsModality:
WEBLesson:
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.|
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
