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