Get a SQL Server stored procedure return value with EF Core

 Blog post here: https://erikej.github.io/efcore/2020/11/02/ef-core-sproc-return-value.html

Setting the command timeout with the latest .NET SqlClient

 Blog post here: https://erikej.github.io/sqlclient/2020/10/26/sqlclient-commandtimeout-preview.html

Entity Framework Core SQL Server reverse engineering a.k.a Database First gotchas (and workarounds)

 Blog post here: https://erikej.github.io/efcore/2020/10/12/ef-core-sqlserver-scaffolding-gotchas.html

Tips for making the most of EF Core with Azure SQL Database

 Blog post here: https://erikej.github.io/efcore/sqldb/2020/09/21/efcore-azure-sql-db.html 

EF Core Power Tools database reverse engineering: renaming of entities and properties

 Blog post here: https://erikej.github.io/efcore/2020/09/07/ef-core-power-tools-renaming-advanced.html

Creating, building and publishing Azure SQL Database projects on non-Windows platforms

 Blog post here: https://erikej.github.io/efcore/2020/08/31/ssdt-project-azure-datastudio.html

EF Core Power Tools reverse engineering advanced options

 Blog post here: https://erikej.github.io/efcore/2020/08/24/ef-core-power-tools-advanced-options.html

Using SQL Server Compact 4 with .NET Core 3.1 (on Windows only)

 Blog post here: https://erikej.github.io/sqlce/2020/08/17/netcore-sql-compact.html

Mapping and using SQL Server stored procedures with EF Core Power Tools

 Blog post here: https://erikej.github.io/efcore/2020/08/10/ef-core-power-tools-stored-procedures.html 

Run migration scripts with sqlcmd and avoid issues with QUOTED_IDENTIFIER

Blog post here https://erikej.github.io/efcore/2020/08/04/ef-core-script-migrations-sqlcmd.html 

How to call stored procedures with OUTPUT parameters with FromSqlRaw in EF Core

Blog post at https://erikej.github.io/efcore/2020/08/03/ef-core-call-stored-procedures-out-parameters.html

Breaking changes in Microsoft.Data.SqlClient 2.0 (and potential mitigations)

Blog post here: https://erikej.github.io/sqlclient/efcore/2020/06/22/sqlclient-2-breaking-changes.html

Walk-through: Using an Entity Framework 6 EDMX file with .NET Core

Blog post here: https://erikej.github.io/ef/dotnetcore/2020/06/15/ef6-use-edmx-dotnetcore.html

Tips for .dacpac (SQL Server database project) deployment

Blog post here: https://erikej.github.io/efcore/2020/06/08/ssdt-dacpac-deploy.html

Get a single, simple type value from a stored procedure with Entity Framework Core and raw SQL

Blog post here: https://erikej.github.io/efcore/2020/05/26/ef-core-fromsql-scalar.html

Simple logging with Entity Framework Core 5 and 'LogTo' (like Database.Log in EntityFramework 6)

Blog post here: https://erikej.github.io/efcore/2020/05/18/ef-core-simple-logging.html

Build (and publish) a .dacpac (SQL Server database project) with .NET Core - even on Linux or macOS!

blog post here: https://erikej.github.io/efcore/2020/05/11/ssdt-dacpac-netcore.html

New features in Microsoft.Data.SqlClient 2.0 preview 3

Blog post here: https://erikej.github.io/sqlclient/2020/05/04/mds-version2-preview3.html

Pluralization with EF Core and EF Core Power Tools

Blog post here: https://erikej.github.io/efcore/2020/04/26/ef-core-pluralization.html

How to pass a dynamic/variable list of values as SqlParameters with FromSqlRaw in EF Core

New blog post: How to pass a dynamic/variable list of values as SqlParameters with FromSqlRaw in EF Core

Generate Entity Framework Core classes from a SQL Server database project - .dacpac file

New blog post: Generate Entity Framework Core classes from a SQL Server database project - .dacpac file

Query non-table classes using ad-hoc (raw) SQL with EF Core 3.1

Blog post here: https://erikej.github.io/efcore/2020/04/06/query-non-table-classes-raw-sql.html

Avoiding SQL Server plan cache pollution with EF Core 3 and Enumerable.Contains()

Blog post here: https://erikej.github.io/efcore/sqlserver/2020/03/30/ef-core-cache-pollution.html

Update your Microsoft.Data.SqlClient dependency if you run EF Core 3.1 with Linux/Docker, to avoid deadlock (hang) issues

Blog post here: https://erikej.github.io/efcore/sqlclient/2020/03/22/update_mds.html