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
Bringing related data together
Connecting to external data sources
Processing SQL queries, asynchronous processing
Using parameters in queries
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.