Although this article targets EF Core 6 there will be some examples mentioned from EF Core 5 which do not work in EF Core 6 and have been rewritten to work with EF Core.
Also, there are several code samples taken from Microsoft and are marked so in their readme files.
Hopefully what is provided will assist all levels of developers.
Since November 2022 EF Core 7 has been released this will be the main version used.
Projects in this solution
| Project | Description | Notes |
|---|---|---|
| EntityCore5Extensions | Various helper methods | EF Core 5 |
| EntityFrameworkCoreHelpers | Various helper methods | EF Core 6 |
| ExtensionsLibrary | Helper language extensions | |
| ColumnOrderFromMicrosoftApp | This code is from Microsoft with minor changes by Karen Payne | |
| TaxpayersConcurrencyCheck | Handling Concurrency Conflicts | |
| LoggingOptionsApp | How to use EF Core 6 logging w/o dependency injection | |
| ModelCommentsApp | Shows how to get, and set, comments for models in a DbContext | |
| ModelCommentsApp1 | Shows how to create comments for each property in a model | Migrations |
| TaxpayersConcurrencyCheck | Examples to learn how to work with concurrency conflicts | |
| ParameterizingValuesApp | Understanding how EF Core parameterizes variables | |
| TaxpayerEvents | Working with events | |
| SortByColumnNameApp | Learn how to perform order by on navigation properties | |
| NorthWind2020ConsoleApp | An example of a self-referencing table for managers and workers | Originally .NET Core 5, EF Core 5 and was updated to .NET Core 6, EF Core 6. |
| ValueConversionsEncryptProperty | An example for encrypting string via EF Core HasConversion | Based off a Microsoft sample |
| NorthWindContactsApp | Example on using EF Core in a Windows Forms project | Based off a Microsoft sample |
| GetWeekendDatesCorrectlyApp | Client side evaluation working with dates EF Core 7 | |
- Microsoft Visual Studio 2022 or higher
- SSMS (SQL-Server Management Studio) is optional but will make life easier
See the following page to learn how to reverse engineer a new SQL-Server database using EF Power Tools, step by step.
See the following respoitory which I just started 11/2022
- Entity Framework Core docs
- Querying Data
- Saving Data
- Database Providers
- EF Core Value Conversions
- EF Core: Working with TimeOnly
- Using EF Core and Bogus
- Port from EF6 to EF Core