Course details
ADO.NET allows developers to create applications that are driven by data and services. This course identifies the various ways to manage ADO.NET connections and also details how to access data by using command objects and the DataReader object. Specific topics covered in the course include an introduction to ADO.NET, defining ADO.NET Connection objects, managing connections with Visual Basic 2010, and using ADO.NET command objects and DataReaders. This course is one of a series… + Read More
Course details
ADO.NET allows developers to create applications that are driven by data and services. This course identifies the various ways to manage ADO.NET connections and also details how to access data by using command objects and the DataReader object. Specific topics covered in the course include an introduction to ADO.NET, defining ADO.NET Connection objects, managing connections with Visual Basic 2010, and using ADO.NET command objects and DataReaders. 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 the features, capabilities, and benefits of ADO.NET
- identify the components and uses of the ADO.NET object model, the DataSet object, and data providers
- identify the uses and benefits of LINQ and the Entity Framework
- select the appropriate .NET data provider in a given scenario
- identify the steps for setting the ConnectionString property
- identify the features of the ConnectionString property's provider-specific attributes
- identify ways to open and close connections
- recognize ways for handling connection events
- recognize the code for handling typical exceptions
- select a data provider
- configure a connection
- encrypt data and add a user instance
- handle connection events
- recognize the steps for creating a command to retrieve a single value from a data source
- recognize the uses of DataReader properties and methods and the steps for retrieving a result set from a database
- name the different ways of processing rows of read-only data
- identify the code for using ExecuteXmlReader for returning an XML stream
- work with Command objects
- use a DataReader object
- retrieve a single value from a data source
- retrieve an XML data stream
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