using
System;
using System.Data;
using System.Data.SqlClient;
namespace cnkk.Data
... {
/**//// <summary>
/// SQL Database.
/// </summary>
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;
/**//// <summary>
/// 设置等待命令执行的时间(以秒为单位)。
/// </summary>
public static int CommandTimeout
...{
set
...{
this.commandTimeout = value;
}
}
/**//// <summary>
/// Database connection string.
/// </summary>
public string ConnectionString
...{
get ...{ return connection.ConnectionString; }
}
private bool keepConnection = false;
/**//// <summary>
/// 保持数据库连接,设置为 true 可以提供更高数据库访问性能,但不保证是线程安全的。
/// </summary>
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();
}
}
}
}
}
}
using System.Data;
using System.Data.SqlClient;
namespace cnkk.Data
... {
/**//// <summary>
/// SQL Database.
/// </summary>
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;
/**//// <summary>
/// 设置等待命令执行的时间(以秒为单位)。
/// </summary>
public static int CommandTimeout
...{
set
...{
this.commandTimeout = value;
}
}
/**//// <summary>
/// Database connection string.
/// </summary>
public string ConnectionString
...{
get ...{ return connection.ConnectionString; }
}
private bool keepConnection = false;
/**//// <summary>
/// 保持数据库连接,设置为 true 可以提供更高数据库访问性能,但不保证是线程安全的。
/// </summary>
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();
}
}
}
}
}
}