一个有KeepConnection开关的C#的Database类

最新推荐文章于 2022-12-09 08:27:21 发布

wuyxdream

最新推荐文章于 2022-12-09 08:27:21 发布

阅读量863

点赞数

分类专栏： DotNet技术文章标签： database c# string 数据库 class sql

本文链接：https://blog.csdn.net/wuyxdream/article/details/420913

版权

DotNet技术专栏收录该内容

19 篇文章 0 订阅

订阅专栏

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