Every registration supports local education. TrainUp Gives Back

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

When you register for training with TrainUp.com, you are also supporting local education. Find out how.
  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
  • calendar Image 6-12 Months
    To Complete


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.

Learning Objectives
  • 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-valued parameter
  • Work with MARS, asynchronous commands, and special data types
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.