本文整理汇总了C#中System.Data.SqlClient.SqlConnection.ResetStatistics方法的典型用法代码示例。如果您正苦于以下问题:C# SqlConnection.ResetStatistics方法的具体用法?C# SqlConnection.ResetStatistics怎么用?C# SqlConnection.ResetStatistics使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlClient.SqlConnection
的用法示例。
在下文中一共展示了SqlConnection.ResetStatistics方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: SQLServerDatabase
/// <summary>
/// Creates an instance of this class.
/// </summary>
/// <param name="dataSource">Name or IP address of the server.</param>
/// <param name="initialCatalog">Name of the database.</param>
/// <param name="integratedSecurity">Integrated security. Defaults to true.</param>
/// <param name="asynchronousProcessing">Determines whether asynchronous processes is enabled. Defaults to true.</param>
/// <exception cref="System.InvalidOperationException"></exception>
/// <exception cref="System.Data.SqlClient.SqlException"></exception>
/// <exception cref="System.ArgumentException"></exception>
public SQLServerDatabase(string dataSource, string initialCatalog, bool integratedSecurity = true, bool asynchronousProcessing = true)
{
try
{
_semaphore = new Semaphore(1, 1);
_sqlConnection = new SqlConnection(string.Format("Data Source={0};Initial Catalog={1};Integrated Security={2};Asynchronous Processing={3}", dataSource, initialCatalog, integratedSecurity.ToString(), asynchronousProcessing.ToString()))
{
FireInfoMessageEventOnUserErrors = true,
StatisticsEnabled = true
};
Open();
_serverVersion = _sqlConnection.ServerVersion;
_sqlConnection.ResetStatistics();
Close();
}
catch { Close(); throw; }
}