Description
An object/relational mapper (O/RM) called Entity Framework makes it easier to read and write data to and from databases.
Through a series of concise, understandable, and practical lessons, Mosh will teach you the Entity Framework's fundamental ideas in this course.
You're going to adore this course whether you're brand-new to Entity Framework or have been using it for some time but are looking for a thorough course with a clear structure to fill in the gaps.
What is Entity Framework?
An open source object-relational mapping framework for ADO.NET is called Entity Framework. It was initially distributed as a component of the.NET Framework.
Entity Framework is now supplied independently of the.NET Framework as of version 6.
Developers can deal with data in the form of domain-specific objects and properties, such as customers and customer addresses, using the Entity Framework without having to worry about the underlying database tables and columns.
Why should you learn Entity Framework?
| Simplified Data Access | Entity Framework provides an easy-to-use and consistent API for searching and modifying data by separating database interactions. |
| Object-Relational Mapping (ORM) | Entity Framework simplifies data modeling by connecting object-oriented code and relational databases. |
| Productivity and Efficiency | Entity Framework improves developer efficiency by speeding up and simplifying the process of working with databases. |
| LINQ Integration | To facilitate robust and idiomatic data querying in C#, Entity Framework connects without a hitch with LINQ (Language-Integrated Query). |
| Database Independence | Since Entity Framework is provider-agnostic, programmers are free to switch databases without having to rewrite their code. |
| Migrations | Entity Framework streamlines the process of managing database schemas, making it simple to implement and monitor changes in code. |
| Security and Performance | To better protect and speed up applications, Entity Framework uses parameterized queries and database optimization. |
| Testing and Mocking | Entity Framework encourages testing by providing tools for creating fake data contexts and supporting unit testing. |
| Community and Documentation | Both the Entity Framework community and documentation are robust, giving programmers access to helpful tools and information. |
| Widespread Adoption | Since Entity Framework is so common in the.NET community, its continued utility and marketability are secured. |
What will you require?
- A Good understanding of C# advanced constructs (lambdas and generics)
- Passion to learn Entity framework
Syllabus
Introduction
- Course overview
- About the author
- Questionnaire
Getting Started
- Section Intro
- Entity Framework Explanation
- What are the workflows?
- Database-First Workflow - An Example
- Code-First or Database-First?
- Summary of the section
Building a model using Database-First Workflow
- Section Intro
- Database Setup
- EDMX Designer - Small tour
- EDMX explanation
- Connection Strings
- How to deal with Database changes
- Stored procedures importing
- Function imports
- How to work with Enums?
- Exercises
- Summary of the section
Building a model using Code-First Workflow
- Section Intro
- Code first with New DB
- Code first with existing DB
- Migrations - How to enable them?
- Migrations - How to add a new class?
- Migrations - How to modify an existing class?
- Migrations - How to delete an existing class?
- Migrations - How to recover from a mistake?
- Migrations - How to downgrade a database?
- Database seeding
- Problems
- Summary of the section
Overriding Code-First Conventions
- Section Intro
- Conventions Overriding
- Data Annotations
- Data Annotations- An example
- Fluent API - basics
- Fluent API - Relationships
- Fluent API - An Example
- Fluent API - An Example (Advanced Configurations)
- Fluent API Configurations - How to Organize?
- Problems
- Summary of the section
Querying Data using LINQ
- Section Intro
- LINQ Introduction
- Syntax for LINQ
- Extension Methods for LINQ
- Additional LINQ Extension Methods
- What is Deferred Execution?
- Explanation of IQueryable
- Problems
- Summary of the section
Loading Related Objects
- Section Intro
- What is Lazy Loading?
- What is N+1 Problem?
- What is Eager Loading?
- What is Explicit Loading?
- Problems
- Summary of the Section
Updating Data
- Section Intro
- Changing Data - An overview
- Objects adding
- Objects Updating
- How to remove objects?
- Change Tracker - An Overview
- What is LINQPad?
- Problems
- Summary of the section
Using Entity Framework in Your Applications
- Section Intro
- What is Repository Pattern?
- How to implement Repository Pattern?
- How to Structure Applications?
- ASP.NET MVC - An Example
- An Example of WPF
- Summary of the section
Conclusion
- Finishing words
- Other courses like this
What you’ll learn?
- Difference between Database-first and code-first workflows
- How to build a domain model using code-first workflow
- Override code-first conventions
- Eager loading, lazy loading and explicit loading
- Troubleshooting an application
- Adding, updating and removing objects
- Best practices of applying Entity Framework
- How to build a domain model using database-first workflow
- Upgrade and downgrade using code-first migrations
- Repository pattern and its understanding
- LINQ query syntax and extension methods
Who can enroll this course?
- .NET developers who are eager about learn Entity
- People who are passionate on learning Entity Framework
Course Duration
- Course Duration
- 200+ Lectures and 40+ Hours of on Demand HD Videos
- Certificate of Completion
- 5214+ students enrolled
- Complete Practical Training
- Watch Videos on Android and iOS App, TV, Computer & Tablets