Controllers and MVC models
Types of results
Object manipulation: session, request, response, cookies
Routing management in the application
Forms management

Workshop: MVC chaining with session manipulation

Setting up a cache
Traffic analysis
Resource management (Minify, Bundle) in a Razor view
Publishing the application

Workshop: Setting up a cache, multiple optimizations of the application

Architecture and technologies of access to data
Object relational mapping
Presentation of the framework, tools
Entity framework vs other ORMs (NHibernate)
Entity Data Model vs Code First
Context and connection chain

Workshop: Setting up the Entity Framework in a project in Visual Studio

Definition of the context class (DbContext), life cycle
Log management
Definition of model classes and addition in the context
Database initializers Available
conventions, additions, management of datetime2
Mapping of tables: Attributes and Fluent API
Management of primary keys: simple, compound
Concurrency management: Concurrency Check, Timestamp
Mapping of calculated columns
Relations: OneToMany / ManyToOne, OneToOne, ManyToMany Inheritance
mapping strategies: TPH, TPC, TPS
Generation of CRUD actions in a controller
Backup management in asynchronous mode

Workshop: Creation, modification of a complete data model

Migrations: definition, interests
Activation of migrations, initial migration
Adding a migration and modification of the code: SQL queries
Applying a migration: update or regression of version
Going into production at a specified migration

Workshop: Creation of database manipulation with migrations

Understand the execution of queries
Management of connections
Control of transactions
Passage of an existing connection
Methods available from the DbContext: Creation, update and deletion
Management of association loads: Lazy vs Eager
Generation of stored procedures for the entities of the model and use
Optimizing the context cache, mistakes to avoid

Workshop: Updating data and modifying the model

Overview of available data retrieval methods
Using LINQ to Entities, errors to avoid
Queries with Entity SQL
Stored procedures and handling multiple results
Queries and changes to data using ADO.Net commands
Using DataSets
Using LINQ to SQL
Managing performance

Workshop: Writing multiple queries and processing results – pagination management / creation of views

Build Optimized Solutions Using Object Services
Using Design-
Generated Entity Framework Views Performance Monitoring
Perform Asynchronous Data Changes
Offline Data Caching Using XML
Using Sync Framework

Workshop: Query optimizations, offline data monitoring and caching