ErikEJ/erikej.github.io

Issues

• Use SQL Server Compact with .NET 7/8 and Entity Framework (Classic) with Database First work flow

  #53 opened 6 months ago by utterances-bot
  2

• Better together with Entity Framework Core Power Tools - use a SQL Server Database Project (.dacpac) and EF Core

  #56 opened 2 months ago by utterances-bot
  0

• How to: Code analyze your SQL Server T-SQL scripts in Visual Studio

  #55 opened 2 months ago by utterances-bot
  2

• Using Microsoft.Data.SqlClient with Entity Framework 6

  #35 opened 3 years ago by ErikEJ
  37

• Avoiding SQL Server plan cache pollution due to unparameterized Contains queries generated by EF Core

  #37 opened 3 years ago by ErikEJ
  20

• Blog post ideas

  #17 opened 4 years ago by ErikEJ
  0

• Make your SQL Server Database project (.sqlproj) build with .NET Core - even on Linux or macOS!

  #44 opened 2 years ago by utterances-bot
  25

• Setting the command timeout with the latest .NET SqlClient

  #22 opened 4 years ago by ErikEJ
  8

• Use DateOnly and TimeOnly with EF Core 6, 7 & 8 and Azure SQL / SQL Server

  #52 opened 9 months ago by utterances-bot
  2

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

  #29 opened 4 years ago by ErikEJ
  25

• Renaming of procs and views?

  #51 opened a year ago by carib247
  2

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

  #12 opened 4 years ago by ErikEJ
  9

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

  #14 opened 4 years ago by ErikEJ
  20

• Add an admin CRUD web page to your ASP.NET Core web app in 5 minutes using EF Core Power Tools and CoreAdmin

  #39 opened 3 years ago by ErikEJ
  4

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

  #4 opened 4 years ago by ErikEJ
  1

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

  #28 opened 4 years ago by ErikEJ
  44

• Entity Framework Core Power Tools- a visual guide to recent updates

  #46 opened 2 years ago by utterances-bot
  5

• Avoiding SQL Server plan cache pollution due to unparameterized Contains queries generated by Entity Framework 6

  #38 opened 3 years ago by ErikEJ
  13

• Tips for .dacpac (SQL Server database project) deployment

  #11 opened 4 years ago by ErikEJ
  7

• Power Tools Hangs Visual Studio 2022 64-Bit v17.5.0

  #50 opened a year ago by stevenmcneese
  2

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

  #13 opened 4 years ago by ErikEJ
  0

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

  #10 opened 4 years ago by ErikEJ
  6

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

  #8 opened 4 years ago by ErikEJ
  46

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

  #9 opened 4 years ago by ErikEJ
  0

• New features in Microsoft.Data.SqlClient 2.0 preview 3

  #7 opened 4 years ago by ErikEJ
  0

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

  #5 opened 4 years ago by ErikEJ
  3

• Pluralization with EF Core and EF Core Power Tools

  #6 opened 4 years ago by ErikEJ
  2

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

  #3 opened 4 years ago by ErikEJ
  3

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

  #2 opened 4 years ago by ErikEJ
  21

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

  #16 opened 4 years ago by ErikEJ
  27

• Run migration scripts with sqlcmd and avoid issues with QUOTED_IDENTIFIER

  #15 opened 4 years ago by ErikEJ
  8

• Use dependency injection and .NET logging with Microsoft.Data.SqlClient

  #47 opened 2 years ago by utterances-bot
  1

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

  #41 opened 3 years ago by ErikEJ
  0

• EF Core Power Tools reverse engineering advanced options

  #42 opened 3 years ago by ErikEJ
  2

• Look ma, no passwords - using Entity Framework Core with Azure Managed Identity, App Service/Functions and Azure SQL DB

  #31 opened 3 years ago by ErikEJ
  28

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

  #27 opened 4 years ago by ErikEJ
  3

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

  #26 opened 4 years ago by ErikEJ
  0

• Entity Framework Core 5 free resources

  #24 opened 4 years ago by ErikEJ
  0

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

  #25 opened 4 years ago by ErikEJ
  0

• Get a SQL Server stored procedure return value with EF Core

  #23 opened 4 years ago by ErikEJ
  15

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

  #19 opened 4 years ago by ErikEJ
  7

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

  #21 opened 4 years ago by ErikEJ
  4

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

  #18 opened 4 years ago by ErikEJ
  0

• Using .NET 6 DateOnly (and TimeOnly) with SQL Server

  #49 opened 2 years ago by utterances-bot
  1

• string_split is not working in database first approach.

  #48 opened 2 years ago by vineshkamat
  3

• EF Core Power Tools reverse engineering advanced options

  #43 opened 3 years ago by ErikEJ
  0

• Advanced automated deployment of Azure SQL Database with Azure DevOps (part 3 of 4) - deleted

  #40 opened 3 years ago by ErikEJ
  0

• Unable to find "generate stored procedure mapping" as mentioned in the blog

  #30 opened 3 years ago by balajeek
  1

• Translation of table and colum names integrated with entity framework

  #32 opened 3 years ago by alexsosa2000
  2

• Multiple DbContextExtensions.cs created when running the tool on Multiple databases

  #20 opened 4 years ago by KayakFisher205
  1