Everything SQL Server Compact

Advanced automated deployment of Azure SQL Database with Azure DevOps (part 2 of 4)

noreply@blogger.com (ErikEJ) — Mon, 18 Jan 2021 18:06:00 +0000

Blog post here: Advanced automated deployment of Azure SQL Database with Azure DevOps (part 2 of 4) | ErikEJ's blog

Advanced automated deployment of Azure SQL Database with Azure DevOps (part 1 of 4) - Add AAD administrator via ARM template

noreply@blogger.com (ErikEJ) — Thu, 14 Jan 2021 13:03:00 +0000

Blog post here: Advanced automated deployment of Azure SQL Database with Azure DevOps (part 1 of 4) | ErikEJ's blog

Entity Framework Core 5 free resources

noreply@blogger.com (ErikEJ) — Tue, 05 Jan 2021 14:14:00 +0000

Blog post here: Entity Framework Core 5 free resources | ErikEJ's blog

Get a SQL Server stored procedure return value with EF Core

noreply@blogger.com (ErikEJ) — Mon, 02 Nov 2020 14:36:00 +0000

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

noreply@blogger.com (ErikEJ) — Tue, 27 Oct 2020 13:54:00 +0000

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)

noreply@blogger.com (ErikEJ) — Thu, 15 Oct 2020 06:10:00 +0000

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

noreply@blogger.com (ErikEJ) — Wed, 23 Sep 2020 13:19:00 +0000

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

noreply@blogger.com (ErikEJ) — Mon, 07 Sep 2020 15:23:00 +0000

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

noreply@blogger.com (ErikEJ) — Thu, 03 Sep 2020 12:41:00 +0000

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

EF Core Power Tools reverse engineering advanced options

noreply@blogger.com (ErikEJ) — Mon, 24 Aug 2020 18:03:00 +0000

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)

noreply@blogger.com (ErikEJ) — Thu, 20 Aug 2020 16:25:00 +0000

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

noreply@blogger.com (ErikEJ) — Mon, 10 Aug 2020 16:24:00 +0000

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

noreply@blogger.com (ErikEJ) — Wed, 05 Aug 2020 15:31:00 +0000

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

noreply@blogger.com (ErikEJ) — Tue, 04 Aug 2020 14:55:00 +0000

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)

noreply@blogger.com (ErikEJ) — Mon, 22 Jun 2020 19:25:00 +0000

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

noreply@blogger.com (ErikEJ) — Mon, 15 Jun 2020 15:11:00 +0000

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

noreply@blogger.com (ErikEJ) — Mon, 08 Jun 2020 18:09:00 +0000

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

noreply@blogger.com (ErikEJ) — Tue, 26 May 2020 12:32:00 +0000

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)

noreply@blogger.com (ErikEJ) — Mon, 18 May 2020 18:18:00 +0000

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!

noreply@blogger.com (ErikEJ) — Mon, 11 May 2020 15:43:00 +0000

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

noreply@blogger.com (ErikEJ) — Mon, 04 May 2020 15:40:00 +0000

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

Pluralization with EF Core and EF Core Power Tools

noreply@blogger.com (ErikEJ) — Mon, 27 Apr 2020 15:02:00 +0000

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

noreply@blogger.com (ErikEJ) — Mon, 20 Apr 2020 15:32:00 +0000

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

noreply@blogger.com (ErikEJ) — Mon, 13 Apr 2020 09:22:00 +0000

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

noreply@blogger.com (ErikEJ) — Mon, 06 Apr 2020 15:25:00 +0000

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