Let us help you find the training program you are looking for.

If you can't find what you are looking for, contact us, we'll help you find it. We have over 800 training programs to choose from.

Advanced C#: Entity Framework in .Net Core

  • Course Code: Programming & Development - Advanced C#: Entity Framework in .Net Core
  • Course Dates: Contact us to schedule.
  • Course Category: Microsoft Technology Duration: 3 Days Audience: This course is designed as a follow on to the Developing Applications in C# course. Students familiar with basic C# syntax will benefit from this course

Audience:  

This course is designed as a follow on to the Developing Applications in C# course.  Students familiar with basic C# syntax will benefit from this course 

Level:  

300 

Length: 

3 days 

Overview 

Entity Framework is Microsoft’s robust object-relational mapper framework.  In this course, the student will learn to utilize EF to essentially eliminate SQL data queries from applications and replace them with a much more robust and maintainable code.  Students will learn about the various features and capabilities of EF with intense focus on the most commonly used features.  This course is rich in hands-on opportunities (50%). 

Outline 

  • Introductions 
  • Review of C# Basics 
  • Getting Started 
    • What is an ORM? 
    • EF Features 
    • Workflows: code first vs model first 
    • Visual Studio Tools and features 
  • Code First 
    • New database 
    • Existing database 
    • Annotations 
    • Fluent API 
    • Migrations 
  • Configuring Mappings 
    • Annotations 
    • Fluent API 
    • Model first (new database) 
    • Database first (existing database) 
    • Complex Types 
    • Relationships 
    • Inheritance 
    • Using stored procedures 
  •  
  • EF API 
  • DbContext 
  • Querying  
    • LINQ vs EFSQL vs API 
  • Lazy vs Eager loading 
  • Validation 
  • Proxies 
  • Entity state (attached, detached, etc) 
  • Transactions 
  • Connections 
  • Raw SQL 
View All Courses

    Course Inquiry

    Fill in the details below and we will get back to you as quickly as we can.

    Interested in any of these related courses?