Managing ADO.NET 4 Connections and Commands with C#

Course details

ADO.NET connections and commands are crucial components of building data-driven applications. This course examines managing connections using connection pools and configuration files, as well as stored procedures, and using generic data-access code to establish a connection. Specific topics covered include optimizing ADO.NET connections and commands, ADO.NET transactions, and working with Multiple Active Result Sets (MARS) and asynchronous commands. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner credit towards the MCTS: .NET Framework 4, Data Access certification.

• identify ways to pool connections
• recognize the steps for retrieving a connection string from a configuration file
• identify the steps for monitoring connection resources
• recognize the code for using parameters with SQL statements
• recognize the steps for using the ExecuteNonQuery method
• identify the steps for creating a stored procedure with parameters
• recognize how to use the DBProviderFactory, DbConnection, DbCommand, and DbException objects
• identify the steps for using generic data access code to retrieve provider information
• retrieve a connection string from a configuration file, based on a provider name
• create a DBProviderFactory and DBConnection
• create a DBCommand object
• handle data source errors
• recognize how the .NET Framework APIs can be used to configure transactions
• identify the code for implementing implicit and explicit transactions and for managing concurrency
• recognize the ways for managing and implementing transactions using the System.Transactions namespace
• implement an asynchronous explicit transaction
• implement an implicit transaction
• implement concurrency
• recognize the steps and considerations for enabling and using MARS
• identify the code for using MARS to manipulate data
• identify the uses of asynchronous design patterns in a given scenario
• recognize how to poll an asynchronous operation, implement a callback, and monitor asynchronous operations
• recognize the code for manipulating large objects
• identify the code for moving large amounts of data
• identify the benefits and uses of the SqlBulkCopy class
• identify the code for populating a table-value