I have an application that connect to an SQL Server database. The database is configured with a connectionString.
I have some unit tests, everything works fine. But it connect to my real database (by reading the connectionString) and my tests populate this database. I do not want that, I rather prefer to connect to an in-memory database, to have no impact on my database.
Does it exist a solution for that? How can I configured my connectionString for tests?
Regards.