
Explore how Entity Framework maps domain objects to relational data with conceptual, storage, and mapping models, using DbContext and ObjectContext, and learn via a department and employee example.
Learn to perform create, read, update, and delete operations in Entity Framework using DbContext, DbSet, and EntityEntry, including object state management and relationships.
Encapsulate CRUD operations in a dedicated bo class for employees and leads. Use a context to retrieve, add, update, and delete records with department data and business logic.
Learn to execute stored procedures in Entity Framework, map them to the model, pass parameters, and return results for insert, update, or delete operations.
Explore Entity SQL and LINQ to Entities in Entity Framework, including selecting names, filtering, and joins. Learn performance techniques like lazy loading, eager loading, explicit loading, and no tracking.
Explore lazy loading, eager loading, and explicit loading in Entity Framework to efficiently fetch department and employee data using navigation properties, includes, and no-tracking queries.
Learn how inheritance works in Entity Framework through table-per-type and table-per-hierarchy patterns, using separate tables for non inherited properties and type specific data across employee, programmer, and trainer models.
This lecture explains database-first, model-first, and code-first techniques in entity framework, showing how to design relationships, inheritance, and keys and generate scripts to create the database from the model.
This course is designed to help you learn Entity Framework from the basics to advanced concepts, enabling you to work efficiently with databases in .NET applications. It is suitable for learners who want a clear, structured understanding of how Entity Framework simplifies data access and object-relational mapping in real-world projects.
The course begins with a clear introduction to Entity Framework, explaining its purpose, benefits, and how it fits into modern .NET application development. You will start with your first working Entity Framework example, helping you understand the fundamentals before moving into deeper concepts.
You will then learn how to perform CRUD (Create, Read, Update, Delete) operations using Entity Framework. This includes working with standard entity classes as well as POCO (Plain Old CLR Object) classes, giving you flexibility and control over your data models. The course also covers executing stored procedures, which is essential for working with existing or enterprise-level databases.
Next, the course focuses on querying databases using Entity Framework, including Entity SQL and different data loading strategies such as eager loading and lazy loading. These concepts help you optimize performance and control how related data is retrieved.
In the advanced section, you will explore additional Entity Framework features, including entity inheritance and modeling techniques used to design clean and maintainable data models. Practice tests are included to help you assess your understanding and reinforce key concepts.
By the end of this course, you will be confident in using Entity Framework to build reliable, data-driven .NET applications.