Ado.Net

Certification Training

We provide Online Instructor And Classroom Instructor led Live virtual classroom by certified trainers/ industry professionals

About Course

ADO.NET provides consistent access to data sources such as SQL Server and XML, and to data sources exposed through OLE DB and ODBC. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, handle, and update the data that they contain. ADO.NET separates data access from data manipulation into discrete components that can be used separately or in tandem. ADO.NET includes .NET Framework data providers for connecting to a database, executing commands, and retrieving results. Those results are either processed directly, placed in an ADO.NET DataSet object in order to be exposed to the user in an ad hoc manner, combined with data from multiple sources, or passed between tiers. The DataSet object can also be used independently of a .NET Framework data provider to manage data local to the application or sourced from XML.

Key Features

You will get 100% job Assurance and life time e-placement support

classed taken by globally certified trainers

You will get 3 year Dedicated placement support

Courses are globally recognized & accredited

Ado.Net Course Curriculum

INTRODUCTION TO ADO.NET

  • Microsoft Data Access Technologies
  • From ADO to ADO.NET
  • ADO.NET Architecture
  • Namespaces and Classes
  • Interfaces
  • DataSets and Disconnected Access
  • First ADO.NET Programs
  • Acme Computer Case Study

ADO.NET CONNECTIONS

  • .NET Data Providers
  • IDbConnection
  • Connection Classes
  • Connection Strings
  • Connection Pooling
  • Connection Events
  • Error Handling

ADO.NET CONNECTIONS

  • Database Programs with ASP.NET

ADO.NET COMMANDS

  • IDbCommand
  • Command Objects
  • Creating Commands
  • Executing Commands
  • Parameterized Queries
  • Command Types
  • Using Stored Procedures
  • Batch Queries

DATA READERS AND CONNECTED ACCESS

  • DataReaders
  • IDataReader
  • IDataRecord
  • Type-Safe Accessors

NULL COLUMNS

  • ExecuteReader Options
  • Multiple Result Sets
  • Obtaining Schema Information

DATA SETS AND DISCONNECTED ACCESS

  • DataSet
  • DataAdapter
  • Command Objects
  • DataTable
  • DataColumn
  • DataRow
  • Row States and Versionst
  • Accept or Reject Changes
  • DataTable Events
  • Updating a Database from a DataSet
  • Command Builders

MORE ABOUT DATASETS

  • Filtering DataTables
  • Multiple Table DataSets
  • Schema
  • Constraints
  • Relations
  • Navigating a DataSet
  • DataMapping
  • Creating a DataSet Programmatically
  • Ado Net

XML AND ADO.NET

  • Strong Coupling Between ADO.NET and XML
  • Rendering XML from a DataSet
  • Controlling XML Output
  • Reading XML into a DataSet
  • XML Schema and DataSets
  • Typed DataSets
  • Table Adapters
  • Synchronizing DataSets and XML
  • XML Serialization

DATA BINDING

  • Data Binding in Windows Forms
  • Simple Data Binding
  • Complex Data Binding
  • DataGrid Binding
  • DataView
  • Filtering and Sorting
  • Data Binding with .NET

CONCURRENCY AND TRANSACTIONS

  • DataSets and Concurrency
  • Optimistic Concurrency
  • Pessimistic Concurrency
  • Handling Concurrency Violations
  • ADO.NET Transactions
  • Database Transactions

NEW FEATURES IN ADO.NET

  • Using Server Explorer in Visual Studio
  • Asynchronous Database Operations
  • Multiple Active Result Sets
  • Bulk Copy in ADO.NET

LINQ TO ADO.NET

  • Language Integrated Query (LINQ)
  • Bridging Objects and Data
  • Using Object Relational Designer
  • Filtering, Ordering and Aggregation
  • Inserts, Deletes and Updates
  • LINQ to SQL
  • LINQ to Dataset

Sent Us a Message