Path Courses
Introduction to Entity Framework: Getting StartedADO.NET Entity Framework is an Object/Relational Mapping (ORM) framework that enables developers to work with relational databases in an object-oriented fashion. This course is about ORM tools, Entity Framework architecture and EF data modelling approaches. Further, learn db first approach to query your SQL database using Entity framework.
What you will learn:
- Introduction to Entity Framework
- Introduction to ORM Tools
- Introduction to Entity Framework
- Entity Framework Architecture
- Data Modeling Approaches
- Getting Started With EF
Entity Framework Database First ApproachEntity Framework Database First Approach enables you to create the model from an existing database (like SQL Server, Oracle, MySQL etc.). In this way, this approach reduces the amount of code that you need to write since it automatically generates code. This course is all about Entity Framework DB First approach concepts including EDMX files, model browser, DbContext and DbSet, updating model based upon DB changes, CRUD operations with ASP.NET MVC and calling stored procedures and functions.
What you will learn:
- Database First Approach
- DbContext in EF 6
- EF CRUD Operations Using ASP.NET MVC
- Mapping Stored Procedures and Functions
- Calling Stored Procedures and Functions
- Performing CUD Operations
Entity Framework Code First Approach
Entity Framework Code First approach enables you to define database schema with the help of C# or VB.NET classes. This provides full control over the mapped schema and allows developers to work in an object-oriented fashion.
This course covers EF code first concepts including EF conventions, data annotation attributes, creating a database using code first migrations, CRUD operations using ASP.NET MVC, Fluent API, calling stored procedure and functions, handling output parameters and multi resultsets in the stored procedure.
What you will learn:
- EF Code First Modeling
- EF Conventions
- Database Annotation
- EF Fluent API
- CRUD Operations Using ASP.NET MVC
- Calling Stored Procedure and Functions
- Handling Input and Output Parameters
- Handling Multiple Result sets
EF Code First Migrations and Relationships
Entity Framework Code First Migrations is introduced in EF 4.3. Migrations allow you to update your database schema without losing data or other database objects.
This course will help you to get hands-on experience with EF migrations, script migrations, reverse engineering and defining database relationships using entity framework code first approach. Further, learn to implement inheritance in EF.
What you will learn:
- Code First Migrations
- Script Migrations
- Migrations with Existing Database
- Reverse Engineering
- Database Initializers
- Database Relationships - one-to-one, one-to-many, many-to-many
- EF Inheritance
Entity Framework Advanced ConceptsEntity Framework is a great ORM framework to query and manage SQL database. This course will teach you, how to use EF6 advanced features into your applications to improve the performance and get a better result. Learn EF advanced features like No-Tracking Queries, the Entity States and Entity Lifecycle, Transactions in EF, Async Query and Save and Concurrency Conflicts.
What you will learn:
- Queries
- Entity and States
- Data Loading
- Transactions and Async Query
- Working with Entity States
- Eager Loading vs Explicit Loading
- Handling Concurrency Conflicts
- Working with Transactions in EF