The aim of the course is to provide the knowledge about the characteristics of the Microsoft
\necosystem for data access ADO.NET (ActiveX Data Objects), LINQ and Entity Framework, as well as to
\nmaster techniques important for the design and implementation of .NET applications for data access.
\nUpon completion of the course, students have a basic and advanced knowledge and skills about a variety
\nof concepts, approaches and programming frameworks in the analysis and use of data systems provided
\nby Microsoft data technologies and techniques. Knowledge and skills are reflected in writing a program
\ncode for working with data in business applications, as well as in using Visual Studio development
\nenvironment.<\/p>\n
Microsoft Data Access Technologies Architecture: ADO.NET, Entity Framework, LINQ (Language-
\nIntegrated Query) and LINQ to SQL specific. Data providers, connections, commands, data adapters.
\nWorking 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.<\/p>\n
Connecting to data sources, including databases and other data formats: SQL Server, Access, Oracle, OLE
\nDB, ODBC, MySQL, XML. Working with ADO.NET classes: Dataset, Connection, Command, DataAdapter
\nand DataReader. Working with classes DataTable, DataView, DataColumn, DataRow, DataRelation.
\nFiltering, sorting and constraints. Using the Entity Framework to interact with relational data. Building an
\nEntity Framework model using graphical tools in a Visual Studio environment. Analysis of information
\nthrough different LINQ providers: LINQ 2 Objects, LINQ 2 SQL, LINQ 2 DataSets, LINQ 2 XML, LINQ 2
\nEntities. Connecting to data in Windows and Web applications and displaying data in user interface.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 … Read more<\/a><\/p>\n Read more<\/a>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[199],"tags":[],"class_list":["post-13870","post","type-post","status-publish","format-standard","hentry","category-subjects"],"acf":[],"yoast_head":"\n