一個有KeepConnection開關的C#的Database類

2024-07-21 02:18:11

字體：大中小

供稿：網(wǎng)友

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>
/// 設置等待命令執(zhí)行的時間（以秒為單位）。
/// </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>
/// 保持數(shù)據(jù)庫連接，設置為 true 可以提供更高數(shù)據(jù)庫訪問性能，但不保證是線程安全的。
/// </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();
}
}
}
}
}
}

本文來源于網(wǎng)頁設計愛好者web開發(fā)社區(qū)http://www.html.org.cn收集整理，歡迎訪問。

上一篇：C# Builder 實現(xiàn)POP3信箱的監(jiān)視

下一篇：一個用C＃寫的詞法分析程序