How to use SQL Server database in integration tests?

Question

I have an Asp.Net Core Web API project with integration tests. Integration tests use a SQLite database as described here - https://learn.microsoft.com/en-us/ef/core/testing/testing-without-the-database#sqlite-in-memory. But this strategy has limitations, some cases are not supported in SQLite, so I want to switch to SQL Server database. Could you suggest me ways how to do it?

Answer 1

There is an article directly "obove" yours

https://learn.microsoft.com/en-us/ef/core/testing/testing-with-the-database