GitHub

SqlConnection.GetSchema fails when SqlConnection.Transaction is not null

System.InvalidOperationException: Unable to build the 'Columns' collection because execution of the SQL query failed. See the inner exception for details. ---> System.InvalidOperationException: ...
GitHub

System.Data.SqlClient.SqlConnection does not roll back open transaction on dispose

SQL Server version is 2014 if it matters. Trivial reproduction causes timeout unless ;pooling=false is appended to the connection string. using System; using System.Data; using System.Data.SqlClient; ...
note

【C#入門】Disposeって何者!? 〜外部リソースは後片付けが大事〜

タカシ「センセー！SQLサーバーに接続するコード書いてたら、Disposeって出てきたんですが……これって何ですか ...
Ars Technica

.NET - Keep a SqlConnection open or open and close it repeatedly?

This is a basic question that I think I know the answer to but I just wanted to double check the consensus view. <BR><BR>I've got a WinService written in C#/.NET 2.0. It's job is to be continually ...