Month: October 2021

In this previous post, I showed how to execute raw SQL query using EF but it requires the entity to be defined and to be accessible via DbSet. However, there might be times where you just want to execute a raw SQL query to return some arbitrary shape that is not necessarily part of your … [Read more…]

I came across a problem with EnsureCreated() method that broke all the SQL migrations on start up. I have some queries that I wanted to run before the migrations. I thought I should make sure the database exists before I run them. I saw the method DatabaseFacade. EnsureCreated() and decided to use it. This method … [Read more…]