.NET – DB, EF

.NET/C# - Database, Entity Framework

.NET8 – System.Linq.Dynamic.Core – using SQL LIKE

System.Linq.Dynamic.Core library does not support SQL LIKE and I added support for it.

EF 9 Has a Bug Related to GroupBy Usage: GroupBy Throwing an Exception

EF9 has a bug and gives an exception “The given key ‘EmptyProjectionMember’ was not present in the dictionary”

Entity Framework 8 – Partial Classes Tricks You Should Know About

This article demonstrates several techniques for using partial C# classes to address common issues in EF 8/ASP.NET8.

SqlServer – Query performance – Database maintenance can help

Some periodic SqlServer maintenance can improve query performance.

.NET8/EF8 – Exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ‘$

NET8/EF8 Breaking Change. Old servers/databases might not understand queries from EF8.

EF8 – Row SQL returning Non-entities

Overview of new changes to EF8 – support for Row SQL returning Non-entities.

SqlServer & EF7: Using datetime vs datetime2 date type

Showing problems with limited accuracy of SqlServer data type “datetime” in .NET7 EF7 environment

VS2022, ver. 17.6.2 – EntityFramework6 broken

In Visual Studio 2022, ver. 17.6.2, Entity Framework 6 (Classic) is broken, adding new DB tables does not work.

Entity Framework 7 – Code First – Using CLI

Tutorial on EF7 – Code First approach using Command Line (CLI)

Entity Framework 7 – Database First – Using EFCorePowerTools

Tutorial on EF7 – Database First approach using GUI tools EFCorePowerTools

Entity Framework 7 – Database First – Using CLI

Tutorial on EF7 – Database First approach using Command Line (CLI)

C# DataAdapter returning Exception “Failed to enable constraints.”

We explain how to debug the generic Exception “Failed to enable constraints.”