Disposing QueryFactory dispose also my connection #650

Activity

1. Cricle commented on Jan 1, 2023

   

   Cricle

   on Jan 1, 2023

   More actions

   I think it can't removed. Because the QueryFactory responsibilities include the management of database connection.（：

   ❤️React with ❤️1Reacted by Aleksey N
2. oe-andreas-soroko commented on Feb 25, 2026

   

   oe-andreas-soroko

   on Feb 25, 2026

   More actions

   I ran into the same behavior as well.

   From my perspective, QueryFactory should not be responsible for opening/closing/disposing the underlying IDbConnection - especially when the connection is shared and managed outside of SqlKata (e.g., reused in further processing).

   At minimum, it would be great to have an opt-out / configuration flag to prevent disposal of the provided connection, similar in spirit to StreamReader(..., leaveOpen: true).

   That way:

   • SqlKata can still optionally manage a connection lifecycle for users who want it, but
   • callers who own the connection can retain full control and avoid unintended disposal.