fix: Dispose connection in tests

linkdotnet · Sep 28, 2024 · 7cb2a2b · 7cb2a2b
1 parent 86bf9f8
commit 7cb2a2b
Showing 1 changed file with 5 additions and 1 deletion.
diff --git a/tests/LinkDotNet.Blog.IntegrationTests/SqlDatabaseTestBase.cs b/tests/LinkDotNet.Blog.IntegrationTests/SqlDatabaseTestBase.cs
@@ -13,10 +13,13 @@ namespace LinkDotNet.Blog.IntegrationTests;
 public abstract class SqlDatabaseTestBase<TEntity> : IAsyncDisposable
     where TEntity : Entity
 {
+    private readonly DbConnection connection;
+
     protected SqlDatabaseTestBase()
     {
+        connection = CreateInMemoryConnection();
         var options = new DbContextOptionsBuilder()
-            .UseSqlite(CreateInMemoryConnection())
+            .UseSqlite(connection)
             .Options;
         DbContext = new BlogDbContext(options);
         DbContextFactory = Substitute.For<IDbContextFactory<BlogDbContext>>();
@@ -35,6 +38,7 @@ public async ValueTask DisposeAsync()
     {
         GC.SuppressFinalize(this);
         await DbContext.DisposeAsync();
+        await connection.DisposeAsync();
     }
 
     private static DbConnection CreateInMemoryConnection()