SQL

This is the first post in the Integration tests in ASP.NET Core series. Part 1: Limitations of the EF Core in-memory database providers (this post) Part 2: Using docker-compose for your ASP.NET + EF Core integration tests Part 3: ASP.NET Core integration tests with docker-compose on Azure Pipelines Part 4: ASP.NET Core integration tests with docker-compose on GitHub Actions In this post we’ll be looking at some of the limitations you may encounter while using the EF Core in-memory database providers for your ASP....

The database team at my current job had successfully integrated the databases into source control using Redgate SQL Source Control. Developers now have a local instance of the databases linked to Source Control and for them to add or change things it’s a breeze. The “adding databases into source control” statement is comprised of basically adding all the objects to source control. E.g. Tables, Views, Procedures and so on. Apart from adding database objects, there were also a couple of Tables identified as “Enum” tables....