Course code: GOC3312« Back

Data Access in ASP.NET

How to understand the possibilities of access to data such as ADO.NET, LINQ, Entity Frame, Dynamic Data and how to develop the applications using this technlologies quickly and minimize a number of mistake you can make. The demos look promising, but how will this new technologies work in a real life? And will it be possible to integrate them into contemporary applications? In the course you will familiarize yourselves with the web use of Entity Framework and look particularly at the practical use of Dynamic Data for dynamic generation of user interface on the metadata basis. We will particularly focus on deployment of Dynamic Data into current applications and on making various adjustments to delivered templates so that you produce a required image.

GOPAS Official Curriculum
No terms found, contact our client service.

AffiliateDurationCatalogue priceHandbook priceITB
Praha3 13 800 CZK included in course price 30
Brno3 13 800 CZK included in course price 30
Bratislava3 480,00 EUR included in course price 30

Who is the course for

The course is designed for developers of web application on ASP.NET platform

Required skills

Experience with .NET Framework platform
Experience with object orientated programming in C# or VB.NET language
Experience with development of web applications on ASP.NET platform encompassing the course GOC331
Experience with development using ADO.NET encompassing the course GOC311 is also recommended

Teaching methods

Instructor-led classroom training with a lot of hands-on labs.

Teaching materials

Hands-on lab hand out, printed materials

Course outline


Access to a database from ASPNET

Direct access using ADO.NET
O/R mappery


Low-level access to a database - possibilities and problems
Connection, Command, DataTable, DataAdapter…
Database agnostic application using ADO.NET

Advanced function of language C

Light introduction to funcional programming
Extension Methods
Partial Methods
Automatic Properties
Implicitly Typed Variables
Object Initializers
Anonymous Types
Lambda Expressions

LINQ Language Integrated Query

Chaining of methods vs.pseudo-SQL syntax
Questioning into object structures using LINQ, accessible operators


Creation of data model
Performing of basic operations
Calling the saved procedures and functions
Extensibility LINQ-to-SQL

ADONET Entity Framework

Basic ideas
Model First, DB First, Code First
Comparison of access

Entity Framework Model First and DB first

Creation of model from a database
Adjustements using SQL Server Data Tools
Extensibility of EDMX-based model
Database agnostic application using EDMX

Entity Framework Code First

Creation of data model using Code First
Initial database filling
Database agnostic application using Code First

ASPNET Dynamic Data

Model-aware UI

Automatic generation of UI and validation of the access according to data model

Anotation of a data model

Own templates for Dynamic DAta

Data are not the databases
Tasting of Windows Azure
Table Storage, Blob Storage, Queue Storage


Tištěné prezentace probírané látky

included in course price
The prices are without VAT.