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


Visual Basic .NET programmers and candidates for the Microsoft MCSD and MCAD certification paths

Prerequisites


Good knowledge of VB.NET, SQL, relational databases, and Visual Studio .NET

Expected Duration


260 Minutes

Objectives :

ADO.NET Connections and Commands

  • describe the features required of a distributed or disconnected data-access system tuned for web services and web applications.
  • describe the broad architecture of ADO.NET, set out its object model, and list its main objects.
  • choose between the different .NET data providers and create a connection string.
  • open and close connections to data sources, handle connection events, and deal with exceptions.
  • explain why connection pooling is necessary and describe how to pool connections.
  • select appropriate connection properties in a connection string, handle connection events, and manage connection pools.
  • describe how to create and use stored procedures and parameters in Visual Studio.NET and ADO.NET.
  • describe how to set input parameters and access return values and output parameters in stored procedures.
  • call stored procedures using command objects and define input and output parameters for them.
  • describe the reasons for direct database access and how this is performed in ADO.NET.
  • explain how to execute Command objects for returning no values, single values, or to run DDL and DML commands.
  • explain how to process rows of read-only data from a data source.
  • process rows of data from a DataReader and extract metadata about rows.


    • Course Number: 73686_eng