F/ADO/DB/SqlCore.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.OracleClient;
using System.Data.SQLite;
using MySql.Data.MySqlClient;

namespace V.ADO
{
    /// <summary>
    /// 多数据库切换核心
    /// </summary>
    internal class SqlCore
    {

        #region 配置
        //定义多数据库DBHelp
        V.ADO.MSSql S;
        V.ADO.Oracle O;
        V.ADO.Access A;
        V.ADO.Excel E;
        V.ADO.Sqlite SL;
        V.ADO.MySql M;

        /// <summary>
        /// 定义分解Dictionary类
        /// </summary>
        internal V.ADO.ParameterResolve P;

        /// <summary>
        /// 数据库配置
        /// </summary>
        internal F.ADO.Model.DB ModelSql { get; set; }

        /// <summary>
        /// 重构
        /// </summary>
        /// <param name="ModelSql">数据库配置</param>
        internal SqlCore(F.ADO.Model.DB ModelSql)
        {
            this.ModelSql = ModelSql;
            switch (ModelSql.DBType)
            {
                case F.ADO.Enum.DBType.MSSql: S = new V.ADO.MSSql(ModelSql.SqlHelp); break;
                case F.ADO.Enum.DBType.Access: A = new V.ADO.Access(ModelSql.SqlHelp); break;
                case F.ADO.Enum.DBType.MySql: M = new V.ADO.MySql(ModelSql.SqlHelp); break;
                case F.ADO.Enum.DBType.Oracle: O = new V.ADO.Oracle(ModelSql.SqlHelp); break;
                case F.ADO.Enum.DBType.DB2: break;
                case F.ADO.Enum.DBType.File: break;
                case F.ADO.Enum.DBType.Memory: break;
                case F.ADO.Enum.DBType.Excel: E = new V.ADO.Excel(ModelSql.SqlHelp); break;
                case F.ADO.Enum.DBType.Sqlite: SL = new V.ADO.Sqlite(ModelSql.SqlHelp); break;
                default: break;
            }