Choose your language:

France
Germany
Hong Kong
India
Ireland
Japan
Malaysia
Netherlands
New Zealand
Singapore
Sweden
United Kingdom
United States

Data Access with Entity Framework

Course Code

IN1615

Duration

1 Day

Previous development experience
This one-day course for developers introduces object-relational mapping systems and how they ease database interactions in object-oriented applications. It covers Microsoft’s Entity Framework and both approaches to creating and using database models – database-first and code-first. It gives also gives the participant practical examples of managing changes to the database structure during the development cycle and tools to create and populate the database with sample data.
This course is designed for developers

In this course, participants will:

  • Learn about object-relational mapping systems and how they ease database interactions in object-oriented applications

Introduction
OOP and RDBMS Differences
Object-Relational Mapping
Goal: Program Against OOP Model
Creating a Model Using the Designer
Accessing Data Using a DbContext

Enhancing Designer Models
Querying Data Using LINQ
Using Navigation Properties
Extending Designer Entities
Adding Validation to Entities
Using Stored Procedures

Code-First Development
Domain-Centric Modeling
Creating Entity Classes
Custom DbContext Objects
Mapping Entities to Db Tables
Creating Navigation Properties
Mapping Relationships Between Entities

Practical Development Considerations
Automatically Creating the Database
Seeding the Database with Data
Handling Changes to the Model
Database Migrations
Send Us a Message
Choose one