Entity Framework Course Details

Entity Framework (EF) is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write.

SYLLABUS:

 Introduction
 Creating the Web Application
 Creating the Database
 Creating the Entity Framework Data Model
 Exploring the Entity Framework Data Model
 The Entity Data Source Control
 Adding and Configuring the Entity Data Source Control
 Configuring Database Rules to Allow Deletion
 Using a GridView Control to Read and Update Entities
 Revising EntityDataSource Control Markup to Improve Performance
 Displaying Data from a Navigation Property
 Using a DetailsView Control to Insert Entities
 Displaying Data in a Drop-Down List
 Filtering, Ordering, and Grouping Data
 Using the EntityDataSource "Where" Property to Filter Data
 Using the EntityDataSource "OrderBy" Property to Order Data
 Using a Control Parameter to Set the "Where" Property
 Using the EntityDataSource "GroupBy" Property to Group Data
 Using the QueryExtender Control for Filtering and Ordering
 Using the "Like" Operator to Filter Data
 Working with Related Data
 Displaying and Updating Related Entities in a GridView Control
 Displaying Related Entities in a Separate Control
 Using the EntityDataSource "Selected" Event to Display Related Data
 Working with Related Data, Continued
 Adding an Entity with a Relationship to an Existing Entity
 Working with Many-to-Many Relationships
 Implementing Table-per-Hierarchy Inheritanc
 Table-per-Hierarchy versus Table-per-Type Inheritance
 Adding Instructor and Student Entities
 Mapping Instructor and Student Entities to the Person Table
 Using the Instructor and Student Entities
 Using Stored Procedures
 Creating Stored Procedures in the Database
 Adding the Stored Procedures to the Data Model
 Mapping the Stored Procedures
 Using Insert, Update, and Delete Stored Procedures
 Using Dynamic Data Functionality to Format and Validate Data
 Using DynamicField and DynamicControl Controls
 Adding Metadata to the Data Model
 The ObjectDataSource Control
 Business Logic and Repository Classes
 Updating the Database and the Data Model
 Adding a Relationship to the Database
 Adding a View to the Database
 Updating the Data Model
 Using a Repository Class and an ObjectDataSource Control
 Adding Insert and Delete Functionality
 The Attach Method
 The SaveChanges Method
 Retrieving Instructor Names to Select When Insertin
 Creating a Page for Inserting Departments
 Adding Update Functionality
 Adding a Business Logic Layer and Unit Tests
 Creating a Repository Interface
 Creating a Business-Logic Class
 Creating a Unit-Test Project and Repository Implementation
 Creating Unit Tests
 Adding Business Logic to Make a Test Pass
 Handling Object Data Source Exceptions
 Sorting and Filtering
 Adding the Ability to Sort Grid View Column
 Adding a Search Box
 Adding a Details Column for Each Grid Row
 Handling Concurrency
 Concurrency Conflicts
 Pessimistic Concurrency (Locking)
 Optimistic Concurrency
 Detecting Concurrency Conflicts
 Handling Optimistic Concurrency Without a Tracking PropertyEnabling Concurrency Tracking in the Data Model
 Handling Concurrency Exceptions in the DAL
 Handling Concurrency Exceptions in the Presentation Layer
 Testing Optimistic Concurrency in the Departments Page
 Handling Optimistic Concurrency Using a Tracking Property
 Adding Office Assignment Stored Procedures to the Data Model
 Adding Office Assignment Methods to the DAL
 Adding Office Assignment Methods to the BLL
 Creating an Office Assignments Web Page
 Testing Optimistic Concurrency in the Office Assignments Page
 Handling Concurrency with the Entity Data Source Control
 Maximizing Performance
 Efficiently Loading Related Data
 Managing View State
 Using The No Tracking Merge Option
 Pre-Compiling LINQ Queries
 Examining Queries Sent to the Database
 Pre-Generating Views
 What's New in the Entity Framework 4
 Foreign-Key Associations
 Executing User-Defined SQL Commands
 Model-First Development
 POCO Support
 Code-First Development

Last modified: Friday, 29 July 2016, 12:30 AM