Entity Framework Core – From SQL to C# code

by Kenji Elzerman
Enitity Framework Core E-book - Kens Learning Curve

Entity Framework Core

First edition
July 2024, 3-4 hours read
Digital book only (EPUB)
Available languages: English

This book is for those who want to learn how to use Entity Framework from zero or those who want to learn a little bit extra about this subject. Don’t expect 100% coverage on the whole Entity Framework Core subject, because that’s impossible. I will give you enough information to work with in a way you can implement Entity Framework in your own application(s).

Most books I have read are so focused on theory and working with the perfect scenario. In my opinion, this isn’t right. There isn’t a perfect scenario in a perfect environment.

That is why I place my focus more on the practical side of things. I want to show you how it is done, rather than just tell you. This way I will tell you less unused theory, but more practical examples.

To help you with the practical side, I have included examples and a project which you can download from my GitHub. With this project, you can type along as we are building more aspects of Entity Framework Core in a console application and API.

You do need to know the basics of C#! Know what variables are, how to create classes and methods, how dependency injection works, how to make decisions, how unit testing works, etc.

eBook

€ 19,99

Subjects

  • Introduction to SQL and databases
  • The SQL Server Object Explorer
  • Queries
  • Joins
  • Aliases
  • Transactions
  • If-Else
  • Stored procedures
  • Context
  • Migrations
  • Refactoring the code
  • Data annotations
  • Act on state
  • Creating migrations
  • Reverting migrations
  • Seeding
  • The theory
  • One-to-one relationship
  • One-to-many relationship
  • A simple stored procedure
  • Stored procedure with parameters
  • Why use dependency injection?
  • Storing the connection string
  • Adding DataContext to services
  • Using the injection
  • Migrations
  • The simplest way
  • Microsoft logging
  • ToQueryString
  • Query interceptors
  • Security
  • Tracking entities
  • Attaching entities
  • No Tracking
  • Identity resolution
  • Stored procedures
  • Setting up entities
  • Shadow properties
  • Setting up the test project
  • In-memory database
  • To SaveChanges or not to SaveChanges
  • Encrypting data

Samples

About

Kens Learning Curve is all about learning C# and all that comes along with it. From short, practical tutorials to learning from A to Z.

 

All subjects are tried and used by myself and I don’t use ChatGPT to write the texts.

Contact

Use the contact form to contact me or send me an e-mail.

The contact form can be found here.

Email: info@kenslearningcurve.com

@2023 – All Right Reserved. Designed and Developed by Kens Learning Curve

Kens Learning Curve