The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET 4.5.1, Visual Studio 2013 and SQL Server 2012. Then the course focuses on the backbone of ADO.NET: DataSet and its related classes, such as DataAdapter, DataTable, DataRow, DataColumn, DataRelation, TableMappings and ColumnMappings. DataSet is able to handle multiple tables while remaining disconnected. It is eminently suited for building highly scalable applications for the Web. The close relationship between ADO.NET and XML is covered in detail. Transactions and concurrency are covered. Additional features of ADO.NET are covered, including asynchronous operations, multiple active result sets and bulk copy. The last chapter covers Language Integrated Query (LINQ) and Microsoft’s Entity Framework.
|C# .NET developers needing to communicate with datasources.
|A basic knowledge of SQL and of programming the .NET Framework using C#. The student should also understand the fundamentals of XML. A working knowledge of SQL Server is also desirable.