利用DbProviderFactory兑现数据操作跨数据库数据操作类-数据库教程-爱易网页

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

日期：2014-05-16　浏览次数：20442 次

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

原文：http://www.cnblogs.com/wangzhq/archive/2006/09/14/504309.html#1744469

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> ======================================================== /// /// 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(Conf <div class="clearfix"></div> </div> <nav aria-label="..."> <ul class="pager"> <li class="previous"><a href="42527">上一篇： PHP BB 与本地另一数据库冲突解决方法 </a></li> <li class="next"><a href="42525">下一篇：并发压力测试(2)badboy和jmeter的使用(转) </a></li> </ul> </nav> <div class="alert alert-warning" role="alert"> <strong>免责声明：</strong> 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。 </div> <div class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title">相关资料<span><a target="_blank" class="pull-right" href="/sjkjc/">更多></a></span></h3> </div> <div class="panel-body row"> <ol> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/sjkjc/48457' title=' 数据库实业和String替换 TableName_Field ' target="_blank"> 数据库实业和String替换 TableName_Field </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/sjkjc/55444' title=' DB2的JDBC联接驱动与URL总结 ' target="_blank"> DB2的JDBC联接驱动与URL总结 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/sjkjc/35859' title=' 从FusionIO的NVM压缩接口说起 ' target="_blank"> 从FusionIO的NVM压缩接口说起 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/sjkjc/37270' title=' exam_UNIX and relational database(4) ' target="_blank"> exam_UNIX and relational database(4) </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/sjkjc/41589' title=' 事宜小结 ' target="_blank"> 事宜小结 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/sjkjc/7735' title='ORACLE SQL功用优化系列 (二)' target="_blank"> ORACLE SQL功用优化系列 (二)</a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/sjkjc/56254' title=' undo表空间有关 ' target="_blank"> undo表空间有关 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/sjkjc/52314' title=' Oracle学习——块构造 ' target="_blank"> Oracle学习——块构造 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/sjkjc/57862' title=' Oracle字符串连接的步骤 ' target="_blank"> Oracle字符串连接的步骤 </a></li></div> </ol> </div> </div> </div> <div class="col-lg-4 hidden-sm hidden-xs">  <a id="AdPageRight1_AdPageRight" href="http://www.tdyun.com/cloud/?aiyiweb" target="_blank"><img class="img-responsive" src="/images/TdPageAd/vps2.png" alt="香港云服务器免备案云主机VPS 国内独立IP 独享15M 月付SSD" /></a> <script src='/Scripts/AdContentPage300_1.js' language='javascript'></script> <script src='/Scripts/AdContentPage300_2.js' language='javascript'></script> <script src='/Scripts/AdContentPage300_3.js' language='javascript'></script> <div class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title">推荐阅读<span><a target="_blank" class="pull-right" href="/sjkjc/">更多></a></span></h3> </div> <div class="panel-body"> <ol> <li class="articleAbout"><a href=/sjkjc/51532 title=' 怎么完全卸载Oracle ' target="_blank"> 怎么完全卸载Oracle </a></li> <li class="articleAbout"><a href=/sjkjc/7503 title='SQL墨守成规(4)创立表' target="_blank"> SQL墨守成规(4)创立表</a></li> <li class="articleAbout"><a href=/sjkjc/47994 title=' 日志 [2006年09月22日]oracle内存 ' target="_blank"> 日志 [2006年09月22日]oracle内存 </a></li> <li class="articleAbout"><a href=/sjkjc/42612 title=' MySQL数据库藏储引擎和分支现状 ' target="_blank"> MySQL数据库藏储引擎和分支现状 </a></li> <li class="articleAbout"><a href=/sjkjc/40607 title=' 批改Oracle连接数 ' target="_blank"> 批改Oracle连接数 </a></li> <li class="articleAbout"><a href=/sjkjc/50177 title=' 信息互换总线平台IEB ' target="_blank"> 信息互换总线平台IEB </a></li> <li class="articleAbout"><a href=/sjkjc/51461 title=' When to use DMU ' target="_blank"> When to use DMU </a></li> <li class="articleAbout"><a href=/sjkjc/42388 title=' SSH 联接多个数据库并且动态切换 ' target="_blank"> SSH 联接多个数据库并且动态切换 </a></li> <li class="articleAbout"><a href=/sjkjc/7367 title='项目开发中MSSQL运用存储进程的益处' target="_blank"> 项目开发中MSSQL运用存储进程的益处</a></li> <li class="articleAbout"><a href=/sjkjc/51748 title=' oracle 乱码有关问题 ' target="_blank"> oracle 乱码有关问题 </a></li> <li class="articleAbout"><a href=/sjkjc/50076 title=' Oracle10g EM应用 ' target="_blank"> Oracle10g EM应用 </a></li> <li class="articleAbout"><a href=/sjkjc/37875 title=' oracle exp/imp 空表不能导出的有关问题 ' target="_blank"> oracle exp/imp 空表不能导出的有关问题 </a></li> <li class="articleAbout"><a href=/sjkjc/55708 title=' C3P0 有关问题 ' target="_blank"> C3P0 有关问题 </a></li> <li class="articleAbout"><a href=/sjkjc/48258 title=' Oracle备份与恢复(1) ' target="_blank"> Oracle备份与恢复(1) </a></li> <li class="articleAbout"><a href=/sjkjc/38094 title=' 单用户装配Oracle 11g 单机ASM ' target="_blank"> 单用户装配Oracle 11g 单机ASM </a></li> <li class="articleAbout"><a href=/sjkjc/37700 title=' ORA-01830: 日期格式图片在转换整个输入字符串之前结束的解决方法 ' target="_blank"> ORA-01830: 日期格式图片在转换整个输入字符串之前结束的解决方法 </a></li> <li class="articleAbout"><a href=/sjkjc/41357 title=' 加载ibatis文件出现超时错误的解决方法 ' target="_blank"> 加载ibatis文件出现超时错误的解决方法 </a></li> <li class="articleAbout"><a href=/sjkjc/40644 title=' 运用分析服务多维模式建立简单的分析模型 ' target="_blank"> 运用分析服务多维模式建立简单的分析模型 </a></li> <li class="articleAbout"><a href=/sjkjc/44284 title=' hibernate 逆向工程：依据数据库已有表，配置生成相关的实体类与配置文件 ' target="_blank"> hibernate 逆向工程：依据数据库已有表，配置生成相关的实体类与配置文件 </a></li> <li class="articleAbout"><a href=/sjkjc/44062 title=' MS SQL server JDBC 联接驱动 ' target="_blank"> MS SQL server JDBC 联接驱动 </a></li> </ol> </div> </div> </div> </div> <div class="clearfix"></div> <footer class=" footer navbar-bottom"> <em>友情链接：</em> <a href="http://www.aiyiweb.com/" target="_blank">爱易网 </a> <a href="http://www.aiyiweb.com/" target="_blank">云虚拟主机技术 </a> <a href="http://www.aiyiweb.com/" target="_blank">云服务器技术 </a> <a href="http://www.aiyiweb.com/" target="_blank">程序设计技术 </a> <a href="http://www.aiyiweb.com/" target="_blank">开发网站 </a> <a href="http://www.aiyiweb.com/" target="_blank">APP开发教程 </a> <br /> <script type="text/javascript">(function(){document.write(unescape('%3Cdiv id="bdcs"%3E%3C/div%3E'));var bdcs = document.createElement('script');bdcs.type = 'text/javascript';bdcs.async = true;bdcs.src = 'http://znsv.baidu.com/customer_search/api/js?sid=15239353030108964139' + '&plate_url=' + encodeURIComponent(window.location.href) + '&t=' + Math.ceil(new Date()/3600000);var s = document.getElementsByTagName('script')[0];s.parentNode.insertBefore(bdcs, s);})();</script> Copyright © 2013-2024 爱易网页当前在线：1678人　网站在1天1时16分47秒内访问总人数：309335人当前 9.07% 　<a href="https://beian.miit.gov.cn" target="_blank">粤ICP备18100884号-2 </a> <script charset="UTF-8" id="LA_COLLECT" src="//sdk.51.la/js-sdk-pro.min.js"></script> <script>LA.init({ id: "JszEmKrtpbU59dY5", ck: "JszEmKrtpbU59dY5" })</script> </footer> </div> </body> </html>