This module introduces the use of ADO.NET, programmed in C#, to be used for accessing SQL databases from within C# applications. Together with a sufficient background knowledge in SQL (or, specifically, Transact-SQL), this module will provide the participants with the necessary knowledge for developing database-driven applications in C# using the .NET framework.


History and components of ADO.NET

Different data providers

Connecting to SQL server

DataTable, DataColumn, DataRow, DataSet, DataView

Aggregating data and exporting to an XML format

Storing data in memory

Creating rows; examining, removing and changing data

Validating changes

Bringing related data together

Connecting to external data sources

Processing SQL queries, asynchronous processing

Using parameters in queries

Entity framework


5 days


All Emerge trainings can be conducted in different locations globally, in customer offices, shared facilities, Emerge-provided training centers, online or through other means, depending on the requirements of the training participants.

Inquire about or sign up to this training »