BobbyCore数据库切换/DbSql.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using System.Configuration;
using System.Data.OleDb;
using System.Data.Common;

namespace Wld.DBCore
{
    internal class DbSql
    {

        private DbConnection con;
        private DataBaseType dbType;
     

        // Methods
        internal DbSql(DataBaseType dataBaseType)
        {
            switch (dataBaseType)
            {
                case DataBaseType.Access:
                    this.con = new OleDbConnection(ConfigurationManager.ConnectionStrings["AccessConn"].ConnectionString);
                    this.dbType = DataBaseType.Access;
                    break;
                default:
                    this.con = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString);
                    this.dbType = DataBaseType.SqlServer;
                    break;
            }

        }
        #region   打开数据库连接
        /// <summary>
        /// 打开数据库连接.
        /// </summary>
        private void Open()
        {
            // 打开数据库连接
            if (con.State == System.Data.ConnectionState.Closed && con != null)
                con.Open();
        }
        #endregion

        #region  关闭连接
        /// <summary>
        /// 关闭数据库连接
        /// </summary>
        public void Close()
        {
            if (con.State == System.Data.ConnectionState.Open && con != null)
                con.Close();
        }
        #endregion
        private void CommonParams(DbCommand cmd, List<DbParameter> cmdParms)
        {
            switch (dbType)