We may earn an affiliate commission when you visit our partners.
Julie Lerman

This course will teach you how to use Entity Framework Core 6 to perform data access in your .NET applications.

Read more

This course will teach you how to use Entity Framework Core 6 to perform data access in your .NET applications.

In this course, Entity Framework Core 6 Fundamentals, you’ll learn to work with data in your .NET applications. First, you’ll explore the benefits of using Microsoft’s ORM, EF Core 6, to relieve you of the commonplace tasks of retrieving and storing data in your software. Next, you’ll discover how to ensure that EF Core understands how the classes and relationships in your software map to a database schema . Finally, you’ll learn how to have EF Core retrieve and persist data in your software, leveraging the myriad capabilities that allow EF Core to comprehend your complex software models. When you’re finished with this course, you’ll have the skills and knowledge of Entity Framework Core needed to fluidly persist data from your software into your data stores.

Enroll now

What's inside

Syllabus

Course Overview
Creating Your First App Using EF Core
Using EF Core to Query a Database
Tracking and Saving Data with EF Core
Read more
Controlling Database Creation and Schema with Migrations
Defining One-to-Many Relationships
Logging EF Core Activity and SQL
Interacting with Related Data
Defining and Using Many-to-Many Relationships
Defining and Using One-to-One Relationships
Working with SQL, Views, and Stored Procedures
Using EF Core in ASP.NET Core Apps
Testing with EF Core
Adding Some More Practical Mappings to Your Application
Understanding EF Core’s Database Connectivity
Tapping into EF Core’s Pipeline

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Suitable for beginners to Entity Framework Core, kicking off with foundational concepts
Provides a strong foundation for working with data in .NET applications using EF Core 6
Taught by Julie Lerman, a Microsoft MVP and recognized expert in Entity Framework
Covers essential aspects of EF Core 6, including data retrieval, persistence, and relationship management
Suitable for software developers with a basic understanding of .NET and database concepts
Provides practical examples and exercises to reinforce learning

Save this course

Save EF Core 6 Fundamentals to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in EF Core 6 Fundamentals with these activities:
Review OOP concepts
Strengthen your foundation in OOP to better understand the design and implementation of EF Core.
Show steps
  • Read articles or tutorials about OOP.
  • Review your notes from previous OOP courses.
  • Complete some OOP practice problems.
  • Discuss OOP concepts with other students.
  • Build a small OOP project.
Follow the Entity Framework Core tutorials on Microsoft Docs
Get started with EF Core by following the official tutorials from Microsoft.
Browse courses on Entity Framework Core
Show steps
  • Visit the Entity Framework Core tutorials page on Microsoft Docs.
  • Choose a tutorial that interests you.
  • Follow the steps in the tutorial.
  • Complete the exercises at the end of the tutorial.
  • Ask questions in the comments section if you need help.
Join a study group or online forum for EF Core
Connect with other EF Core users to share knowledge, ask questions, and get help with your projects.
Browse courses on Entity Framework Core
Show steps
  • Search for EF Core study groups or online forums.
  • Join a study group or forum that interests you.
  • Introduce yourself and ask questions.
  • Answer questions from other members.
  • Share your knowledge and experience with others.
Five other activities
Expand to see all activities and additional details
Show all eight activities
Build a sample .NET application using EF Core
Apply your EF Core skills by building a real-world application.
Browse courses on Entity Framework Core
Show steps
  • Define the requirements for your application.
  • Design the database schema.
  • Create the .NET application.
  • Implement EF Core in your application.
  • Test and debug your application.
Review EF Core commands
Practice using EF Core commands to reinforce your understanding of the syntax and functionality.
Browse courses on Entity Framework Core
Show steps
  • Create a new console application in Visual Studio.
  • Install the Entity Framework Core NuGet package.
  • Define a model class for your data.
  • Create a DbContext class to manage your data.
  • Use EF Core commands to query, insert, update, and delete data.
Write a blog post about using EF Core in your .NET applications
Share your knowledge of EF Core with others by writing a blog post about how you've used it in your own projects.
Browse courses on Entity Framework Core
Show steps
  • Choose a topic that you're familiar with.
  • Write an outline for your post.
  • Write the content of your post.
  • Edit and proofread your post.
  • Publish your post.
Read the book 'Entity Framework Core in Action' by Jon Smith
Gain a deeper understanding of EF Core by reading one of the leading books on the topic.
Show steps
  • Purchase or borrow the book.
  • Read the book cover-to-cover.
  • Take notes and highlight important passages.
  • Complete the exercises at the end of each chapter.
  • Discuss the book with other readers.
Contribute to the Entity Framework Core open source project
Make a meaningful contribution to the EF Core community by contributing to the open source project.
Browse courses on Entity Framework Core
Show steps
  • Find an issue or feature request that you're interested in working on.
  • Fork the EF Core repository.
  • Make your changes.
  • Submit a pull request.
  • Work with the EF Core team to get your changes merged.

Career center

Learners who complete EF Core 6 Fundamentals will develop knowledge and skills that may be useful to these careers:
Database Architect
A Database Architect ensures that the information systems within an organization are scalable, secure, and meet the evolving demands of stakeholders. They analyze the current and projected data needs of an organization and collaborate with technical teams to design new systems that will meet those requirements. Many Database Architects work with Entity Framework Core to translate data models into physical database schemas. This process helps to ensure that an organization can easily store and access the data that drives its business.
Software Engineer
Software Engineers research, design, develop, and test software applications. They may work on new software or maintain existing systems. Software Engineers who work on data-driven applications commonly use Entity Framework Core to map object-oriented data models to a database schema. This makes it easier to retrieve and update data from a database, a common task for Software Engineers.
Data Scientist
A Data Scientist collects, analyzes, and interprets data to extract insights that can be used to improve decision-making. Data Scientists use a variety of tools to perform their work, including Entity Framework Core. This tool helps a Data Scientist to query data, create models, and build reports. By understanding how to use Entity Framework Core, a Data Scientist can work more efficiently with relational data.
Database Administrator
A Database Administrator manages and maintains an organization's databases. This includes tasks such as creating and modifying databases, setting up user permissions, and ensuring that the databases are running smoothly. A Database Administrator who works with Entity Framework Core will find that their knowledge of how EF Core interacts with a database can be a valuable asset.
Web Developer
A Web Developer designs, creates, and maintains websites and web applications. Web Developers who work on data-driven websites will often use Entity Framework Core to connect their web applications to a database. This allows them to easily retrieve and update data from the database without having to write a lot of complex code.
Business Analyst
A Business Analyst works with stakeholders to understand their business needs and develop solutions that meet those needs. Business Analysts who work on data-intensive projects will often use Entity Framework Core to map business requirements to a data model. This helps to ensure that the final solution meets the needs of the stakeholders.
Data Engineer
A Data Engineer designs and builds data pipelines and systems. This includes tasks such as extracting data from various sources, cleaning and transforming the data, and loading the data into a data warehouse or other storage system. A Data Engineer who works with Entity Framework Core will find that this tool can be useful for automating many of the tasks involved in data engineering.
Data Analyst
A Data Analyst analyzes and interprets data to extract insights that can be used to improve decision-making. Data Analysts often use Entity Framework Core to query data and create reports. By understanding how to use Entity Framework Core, a Data Analyst can work more efficiently with relational data.
Information Security Analyst
An Information Security Analyst assesses and mitigates risks to an organization's information systems. This includes tasks such as identifying and addressing vulnerabilities in software and networks, and developing and implementing security policies and procedures. An Information Security Analyst who specializes in database security will find that Entity Framework Core can be a useful tool for understanding how data is accessed and stored.
Software Architect
A Software Architect designs and develops the overall architecture of a software system. This includes tasks such as defining the system's components and their relationships, and designing the system's interfaces. A Software Architect who works on data-intensive systems will often use Entity Framework Core to design the system's data model. This helps to ensure that the system is scalable and can meet the performance requirements of the stakeholders.
Computer Scientist
A Computer Scientist researches and develops new computer technologies and applications. This includes developing new algorithms and data structures, and designing new programming languages. A Computer Scientist who specializes in database systems may use Entity Framework Core to develop new features and functionality for the framework.
Quality Assurance Analyst
A Quality Assurance Analyst tests software to identify and fix bugs. This includes writing test cases, executing the tests, and analyzing the results. A Quality Assurance Analyst who works on data-driven software will often use Entity Framework Core to test the software's database interactions.
Database Developer
A Database Developer designs and develops databases to meet the needs of an organization. This includes tasks such as creating and modifying database schemas, writing stored procedures and functions, and optimizing database performance. A Database Developer who works with Entity Framework Core will find that their knowledge of how EF Core interacts with a database can be a valuable asset.
Project Manager
A Project Manager plans, executes, and controls projects to ensure that they are completed on time, within budget, and to the required quality standards. A Project Manager who works on data-intensive projects will often use Entity Framework Core to help manage the project's data. This can include tasks such as creating data models, designing data migrations, and managing data security.
Technical Writer
A Technical Writer creates documentation for software and other technical products. This includes writing user manuals, help files, and release notes. A Technical Writer who works on data-intensive products will often use Entity Framework Core to understand the product's data model. This helps to ensure that the documentation is accurate and easy to understand.

Reading list

We've selected seven books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in EF Core 6 Fundamentals.
Entity Framework Core in Action, Second Edition written by 2 of the core contributors to Entity Framework Core. It practical guide to building efficient and scalable data access layers for .NET applications. The book valuable resource for both beginners and experienced developers looking to get the most out of Entity Framework Core.
Provides a comprehensive overview of domain-driven design (DDD), a software development approach that focuses on modeling the domain of the problem you are solving.
Provides a guide to Entity Framework Core 6 for beginners. It covers topics such as data modeling, performance tuning, and security.
Provides a clear and concise explanation of the concepts behind Entity Framework Core 6. It good choice for beginners who want to understand the basics of Entity Framework Core without getting bogged down in the details.
This classic book offers a deep dive into the Common Language Runtime (CLR), providing a solid understanding of the underlying mechanisms and principles that EF Core relies on.
Provides a comprehensive understanding of database internals, including concepts like data structures, storage engines, and transaction processing, enhancing the understanding of how EF Core interacts with databases.
Explores the principles and best practices of dependency injection in .NET, providing a solid foundation for understanding how EF Core manages dependencies.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to EF Core 6 Fundamentals.
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser