利用DbProviderFactory实现数据操作跨数据库数据操作类

最新推荐文章于 2020-06-27 11:07:33 发布

我想我是醉了

最新推荐文章于 2020-06-27 11:07:33 发布

阅读量546

点赞数

分类专栏： C#、ASP.NET开发技术大全文章标签：数据库 parameters sql string dataset exception

本文链接：https://blog.csdn.net/liujin983/article/details/4504268

版权

这是一个名为`DataAccess`的类，它实现了跨数据库操作的功能。类中包含方法如获取数据库提供者名称、连接字符串、数据工厂、创建数据库连接、创建命令对象以及执行查询并返回DataSet、DataView和DataTable。这些方法利用`ConfigurationManager.ConnectionStrings`从web.config文件中获取连接字符串，并根据不同的数据库提供者创建相应的数据库连接和命令对象。

摘要由CSDN通过智能技术生成

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

namespace Ths
{
    /** <summary>
    /// ========================================================
    /// 2006-9-13
    /// Wangzhq
    /// zhenqiang812@163.com
    /// wangzhq.cnblogs.com
    /// 数据工厂类,实现了跨数据库的操作.
    /// ========================================================
    /// </summary>
    public class DataAccess:PageBase
    {
        /** <summary>
        /// Webconfig配置连接字符串
        /// </summary>
        private string _confirString = "ConnectionString";
        /** <summary>
        /// 数据工厂类
        /// </summary>
        public DataAccess()
        {
        }
        /** <summary>
        /// 数据工厂类
        /// </summary>
        /// <param name="configString">web.config 关键字</param>
        public DataAccess(string configString)
        {
            ConfigString = configString;
        }

        /** <summary>
        /// 属性,设置数据库连接字符串
        /// </summary>
        public string ConfigString
        {
            get
            {
                return _confirString;
            }
            set
            {
                _confirString = value;
            }
        }

//==============================================GetProviderName==============================

        获得数据库的类型 public string GetProviderName(string ConfigString)#region 获得数据库的类型 public string GetProviderName(string ConfigString)
        /** <summary>
        /// 返回数据提供者
        /// </summary>
        /// <returns>返回数据提供者</returns>
        public string GetProviderName(string ConfigString)
        {

            ConnectionStringSettingsCollection ConfigStringCollention = ConfigurationManager.ConnectionStrings;
            if (ConfigStringCollention == null || ConfigStringCollention.Count <= 0)
            {
                throw new Exception("web.config 中无连接字符串!");
            }
            ConnectionStringSettings StringSettings = null;
            if (ConfigString == string.Empty)
            {
                StringSettings = ConfigurationManager.ConnectionStrings["ConnectionString"];
            }
            else
            {
                StringSettings = ConfigurationManager.ConnectionStrings[ConfigString];
            }
            return StringSettings.ProviderName;
        }
        /** <summary>
        /// 返回数据提供者
        /// </summary>
        /// <returns></returns>
        public string GetProviderName()
        {
            return GetProviderName(ConfigString);
        }
        #endregion

//=====================================================获得连接字符串====================================

        /** <summary>
        /// 获得连接字符串
        /// </summary>
        /// <returns></returns>
        public string GetConnectionString(string ConfigString)
        {
            ConnectionStringSettingsCollection ConfigStringCollention = ConfigurationManager.ConnectionStrings;
            if (ConfigStringCollention == null || ConfigStringCollention.Count <= 0)
            {
                throw new Exception("web.config 中无连接字符串!");
            }
            ConnectionStringSettings StringSettings = null;
            if (ConfigString == string.Empty)
            {
                StringSettings = ConfigurationManager.ConnectionStrings["ConnectionString"];
            }
            else
            {
                StringSettings = ConfigurationManager.ConnectionStrings[ConfigString];
            }
            return StringSettings.ConnectionString;

        }
        public string GetConnectionString()
        {
            return GetConnectionString(ConfigString);
        }

//==============================================GetDbproviderFactory=========================

        返回数据工厂 public DbProviderFactory GetDbProviderFactory()#region 返回数据工厂 public DbProviderFactory GetDbProviderFactory()
        /** <summary>
        /// 返回数据工厂
        /// </summary>
        /// <returns></returns>
        public DbProviderFactory GetDbProviderFactory()
        {
            DbProviderFactory f = null;
            string ProviderName = GetProviderName();
            switch (ProviderName)
            {
                case "System.Data.SqlClient":
                    f = GetDbProviderFactory("System.Data.SqlClient");
                    break;
                case "System.Data.OracleClient":
                    f = GetDbProviderFactory("System.Data.OracleClient");
                    break;
                case "System.Data.OleDb":
                    f = GetDbProviderFactory("System.Data.OleDb");
                    break;
                default:
                    f = GetDbProviderFactory("System.Data.SqlClient");
                    break;
            }
            return f;
        }

        /** <summary>
        /// 返回数据工厂
        /// </summary>
        /// <param name="providername"></param>
        /// <returns></returns>
        public DbProviderFactory GetDbProviderFactory(string providername)
        {
            return DbProviderFactories.GetFactory(providername);
        }
        #endregion

//==============================================CreateConnection=====&#