Consider replacing System.Data.SqlClient with the newer Microsoft.Data.SqlClient

[leedavi]

Maybe look at swapping

using System.Data.SqlClient;

for

using Microsoft.Data.SqlClient;

[david-poindexter]

@leedavi are you trying to report an issue or something? If so, can you please clarify? The title and description are unclear. Thanks.

[leedavi]

@david-poindexter Sorry, for some reason GitHUb emails always go into my clutter folder and I missed them.

There is no problem. I was just pointing out Microsoft.Data.SqlClient is the replacement of System.Data.SqlClient. I'm sure they'll be no problem for years. From what I recall, it's just a straight swap.

I also noticed your drop database were not using SINGLE_USER, might be an idea to do that.

$"ALTER DATABASE [{this.dbName}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;DROP DATABASE [{this.dbName}] END";

[david-poindexter]

Thank you for the clarification @leedavi. I will update the issue for clarity. If you want to create another issue for the drop database tip, feel free to do so.