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

sql-server-connection-pooling.md

If MinPoolSize is either not specified in the connection string or is specified as zero, the connections in the pool will be closed after a period of inactivity. However, if the specified MinPoolSize ...
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 ...
MCPmag

How To Quickly Test a SQL Connection with PowerShell

Unfortunately, not every SQL database is always available when we expect it to be. When you're creating automation scripts to discover, add, update or remove records from a remote SQL database, you ...