【 tulaoshi.com - ASP.NET 】
using System;using System.Data;using System.Data.SqlClient;
namespace cnkk.Data{ ///
/// SQL Database. /// public class Database : DisposableBase { private string connectionString; private SqlConnection connection;
protected Database(string connectionString) { this.connectionString = connectionString; }
protected Database(SqlConnection connection) { this.connection = connection; }
protected override void DisposeManaged() { base.DisposeManaged ();
this.connection.Dispose(); }
private SqlConnection GetConnection() { if ( KeepConnection ) { return this.connection; } else { return new SqlConnection(ConnectionString); } }
protected SqlConnection Connection { get { return this.connection; } }
private int commandTimeout = 30;
///
/// 设置等待命令执行的时间（以秒为单位）。 /// public static int CommandTimeout { set { this.commandTimeout = value; } }
///
/// Database connection string. /// public string ConnectionString { get { return connection.ConnectionString; } }
private bool keepConnection = false;
///
/// 保持数据库连接，设置为 true 可以提供更高数据库访问性能，但不保证是线程安全的。 /// public virtual bool KeepConnection { get { return keepConnection; }
set { if ( keepConnection != value ) { keepConnection = value;
if ( keepConnection == true ) { if ( connection.State == ConnectionState.Closed ) connection.Open(); } else { connection.Close(); } } } } }}
