Objectives and outcomes
The aim of the course is to provide the knowledge about the characteristics of the Microsoft
ecosystem for data access ADO.NET (ActiveX Data Objects), LINQ and Entity Framework, as well as to
master techniques important for the design and implementation of .NET applications for data access.
Upon completion of the course, students have a basic and advanced knowledge and skills about a variety
of concepts, approaches and programming frameworks in the analysis and use of data systems provided
by Microsoft data technologies and techniques. Knowledge and skills are reflected in writing a program
code for working with data in business applications, as well as in using Visual Studio development
environment.
Lectures
Microsoft Data Access Technologies Architecture: ADO.NET, Entity Framework, LINQ (Language-
Integrated Query) and LINQ to SQL specific. Data providers, connections, commands, data adapters.
Working with transactions. The concept of unbound and disconnected data. The concept of relational data mapping into objects (ORM). Entity Framework Architecture. Entity Data Model. The LINQ family of data providers. Reading and writing XML data.
Practical classes
Connecting to data sources, including databases and other data formats: SQL Server, Access, Oracle, OLE
DB, ODBC, MySQL, XML. Working with ADO.NET classes: Dataset, Connection, Command, DataAdapter
and DataReader. Working with classes DataTable, DataView, DataColumn, DataRow, DataRelation.
Filtering, sorting and constraints. Using the Entity Framework to interact with relational data. Building an
Entity Framework model using graphical tools in a Visual Studio environment. Analysis of information
through different LINQ providers: LINQ 2 Objects, LINQ 2 SQL, LINQ 2 DataSets, LINQ 2 XML, LINQ 2
Entities. Connecting to data in Windows and Web applications and displaying data in user interface.