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… + Read More
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
Updated on 13 November, 2015 - Read LessAbout New Horizons Lebanon
As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. With over 300 centers in 60 countries, New Horizons is the world’s largest independent IT and Business training company. Over the past 35 years, New Horizons has delivered a full range of IT and business skills/Management training through innovative learning methods that have transformed businesses and helped over 35 million students reach their goals. New Horizons Lebanon branch was established in 1996.
See all New Horizons Lebanon courses