Disposing QueryFactory dispose also my connection

[TinmarCyfar]

When i dispose Queryfactory, il also dispose my connection (i use this connection in diffèrent other process)

Proposition : Delete this code ? (its not the role of sqlkata to dispose cnx)

[Cricle]

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

[oe-andreas-soroko]

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.