C# Data Access

Lecturer:

Pavel Štěpán (gar.), Helena Wallenfelsová

Tutor:

Pavel Štěpán (gar.), Helena Wallenfelsová

Supervisor:

Department of Software Engineering

Synopsis:

Students will get to know several technologies for data access (database access, XML, etc.), and particular objects e.g. Connection, Command, DataReader and DataAdapter in ADO.NET that are used for data access in programs. Then, the focus will be on the latest technologies such as Entity Framework for mapping of object and relation models, and .NET language integrated query LINQ for data querying and editing.

Requirements:

The fundamentals of the .NET platform, programming in C# language or another language for .Net platform, knowledge of Visual Studio or another environment for .NET platform program development and fundamentals of SQL (at least Select, Insert, Update and Delete commands).

Syllabus of lectures:

1.Introduction

- Basic principles of data access

- History of database interfaces in MS (DAO, ADO, RDO...)

- .NET Data Providers

2.Managing data in the direct mode (ADO.NET connected)

- Connection and Command objects

- DataReader object, Command object for data editing

- Stored procedures

- Transaction

3.Managing data in the indirect mode (ADO.NET disconnected)

- DataSet, DataTable, DataView

- DataAdapter, TableAdapter objects

- Relations and Constrains in DataSets

- Solution of conflicts for multiuser-access

- Data Binding, visual tools for DataBound applications

- BindingSource, BindingNavigator objects

- DataGridView object

4.Object-relational mapping (ORM) - Entity Framework

- principles of data mapping, relation and object structures

- EntityClient provider - high level provider for Entity Framework

- basic layers: ConceptualModel, Mapping and LogicalModel

- access with Entity SQL Queries and LINQ to Entities

- tools for Entity Framework

- access: data --> objects; objects-->data

- Entity Framework - an ideal access to data?

5.LINQ (Language INtegrated Query)

- basic principles, use of some SQL princiles

- integrated access to data (arrays/indexes, databases/SQL, XML/Xpath...)

- LINQ syntax, query statement

- integration to .NET platform languages

- LINQ for objects, XML, Entity...

- Paralel LINQ (PLINQ) - fundamentals

Syllabus of tutorials:

Study Objective:

Study materials:

Programmes developed in the course of the semester are considered to be the main study source. However you can use the following literature:

Agarwal, v. V., Huddleston, J. „Databáze v C# 2008“. Computer Press, 2009. ISBN: 978-80-251-2309-6

Pialorski, P., Russo, M. „Microsoft LINQ Kompletní průvodce programátora“. Computer Press. 2009, ISBN: 978-80-251-2735-3

Note:

Time-table for winter semester 2011/2012:

Time-table is not available yet

Time-table for summer semester 2011/2012:

Time-table is not available yet

The course is a part of the following study plans: