If you have business logic in your database (and you do), you should be testing that. We'll explore how to do that with Microsoft SQL Server in this post.
If you're using Entity Framework Core, you should be tagging your queries to help with troubleshooting both in application logs and at the Database layer. We'll explore how to do that in this post.
dotnet entity framework core
Attending an in-person conference after a year and a half away was a different experience, but KCDC made it great
I'm not speaking at PASS Summit this year, but you should consider submitting a talk
speaking pass summit
In this post, I detail how to use Stored Procedures and Dapper to handle flexible search needs in .NET and SQL Server.
sql server dotnet dapper
Curious about how to log generated SQL in Entity Framework? Take a look at this post that outlines how to do just that in Entity Framework and EF Core
dotnet entity framework entity framework core