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();
}
}
}
}
}
}