mysql管理工具dg_C#操作SqlServer MySql Oracle通用帮助类Db_Helper_DG（默认支持数据库读写分离、查询结果实体映射ORM）...-CSDN博客

本文链接：https://blog.csdn.net/weixin_28848933/article/details/113315003

1 /*********************************************************2 * CopyRight: QIXIAO CODE BUILDER.3 * Version:4.2.04 * Author:qixiao(柒小)5 * Create:2017-9-26 17:41:426 * Update:2017-9-26 17:41:427 * E-mail: dong@qixiao.me | wd8622088@foxmail.com8 * GitHub:https://github.com/dong666

9 * Personal web site:http://qixiao.me

10 * Technical WebSit:http://www.cnblogs.com/qixiaoyizhan/

11 * Description:12 * Thx , Best Regards ~13 *********************************************************/

14 usingMySql.Data.MySqlClient;15 usingOracle.ManagedDataAccess.Client;16 usingQX_Frame.Bantina.Options;17 usingSystem;18 usingSystem.Collections.Generic;19 usingSystem.ComponentModel;20 usingSystem.Data;21 usingSystem.Data.Common;22 usingSystem.Data.SqlClient;23 usingSystem.Linq;24 usingSystem.Reflection;25

26 namespaceQX_Frame.Bantina27 {28 public abstract classDb_Helper_DG29 {30 #region ConnString 链接字符串声明

32 ///

33 ///连接字符串 ConnString_Default 默认，且赋值时会直接覆盖掉读写34 ///

35 private static string _connString =Configs.QX_Frame_Helper_DG_Config.ConnectionString_DB_QX_Frame_Default;36 public static stringConnString_Default37 {38 get { return_connString; }39 set

40 {41 _connString =value;42 ConnString_RW =_connString;43 ConnString_R =_connString;44 }45 }46 ///

47 ///连接字符串 ConnString_RW 读写数据库使用48 ///

49 public static string ConnString_RW =_connString;50 ///

51 ///连接字符串 ConnString_R 读数据库使用52 ///

53 public static string ConnString_R =_connString;54 ///

55 ///DataBaseType Select default:sqlserver56 ///

57 public static Opt_DataBaseType dataBaseType =Configs.QX_Frame_Helper_DG_Config.DataBaseType;58

59 #endregion

61 staticDb_Helper_DG()62 {63 //if (string.IsNullOrEmpty(ConnString_RW) || string.IsNullOrEmpty(ConnString_R))64 //{65 //throw new ArgumentNullException("ConnString Can Not Be Null !");66 //}

67 }68

69 #region ExcuteNonQuery 执行sql语句或者存储过程,返回影响的行数---ExcuteNonQuery

70 ///

71 ///执行sql语句或存储过程，返回受影响的行数,不带参数。72 ///

73 /// 连接字符串，可以自定义，可以以使用SqlHelper_DG.ConnString

74 /// sql语句或存储过程名称

75 /// 命令类型有默认值CommandType.Text

76 /// 返回受影响的行数

77 public static int ExecuteNonQuery(string commandTextOrSpName, CommandType commandType =CommandType.Text)78 {79 using (SqlConnection_WR_Safe conn = newSqlConnection_WR_Safe(dataBaseType, ConnString_RW))80 {81 using (DbCommandCommon cmd = newDbCommandCommon(dataBaseType))82 {83 PreparCommand(conn.DbConnection, cmd.DbCommand, commandTextOrSpName, commandType);84 returncmd.DbCommand.ExecuteNonQuery();85 }86 }87 }88 ///

89 ///执行sql语句或存储过程，返回受影响的行数。90 ///

91 /// 连接字符串，可以自定义，可以以使用SqlHelper_DG.ConnString

92 /// sql语句或存储过程名称

93 /// 命令类型 t

94 /// SqlParameter[]参数数组，允许空

95 /// 返回受影响的行数

96 public static int ExecuteNonQuery(string commandTextOrSpName, CommandType commandType, paramsDbParameter[] parms)97 {98 using (SqlConnection_WR_Safe conn = newSqlConnection_WR_Safe(dataBaseType, ConnString_RW))99 {100 using (DbCommandCommon cmd = newDbCommandCommon(dataBaseType))101 {102 PreparCommand(conn.DbConnection, cmd.DbCommand, commandTextOrSpName, commandType, parms);//参数增加了commandType 可以自己编辑执行方式

103 returncmd.DbCommand.ExecuteNonQuery();104 }105 }106 }107 ///

108 ///执行sql命令，返回受影响的行数。109 ///

110 /// 连接字符串，可以自定义，可以以使用SqlHelper_DG.ConnString

111 /// sql语句或存储过程名称

112 /// 命令类型

113 /// object[]参数数组，允许空

114 /// 返回受影响的行数

115 public static int ExecuteNonQuery(string commandTextOrSpName, CommandType commandType, params object[] obj)116 {117 using (SqlConnection_WR_Safe conn = newSqlConnection_WR_Safe(dataBaseType, ConnString_RW))118 {119 using (DbCommandCommon cmd = newDbCommandCommon(dataBaseType))120 {121 PreparCommand(conn.DbConnection, cmd.DbCommand, commandTextOrSpName, commandType, obj);//参数增加了commandType 可以自己编辑执行方式

122 returncmd.DbCommand.ExecuteNonQuery();123 }124 }125 }126 #endregion

127

128 #region ExecuteScalar 执行sql语句或者存储过程,执行单条语句，返回单个结果---ScalarExecuteScalar

129 ///

130 ///执行sql语句或存储过程返回ExecuteScalar (返回自增的ID)不带参数131 ///

132 /// 连接字符串，可以自定义，可以以使用SqlHelper_DG.ConnString

133 /// sql语句或存储过程名称

134 /// 命令类型有默认值CommandType.Text

135 ///

136 public static object ExecuteScalar(string commandTextOrSpName, CommandType commandType =CommandType.Text)137 {138 using (SqlConnection_WR_Safe conn = newSqlConnection_WR_Safe(dataBaseType, ConnString_R, ConnString_RW))139 {140 using (DbCommandCommon cmd = newDbCommandCommon(dataBaseType))141 {142 PreparCommand(conn.DbConnection, cmd.DbCommand, commandTextOrSpName, commandType);143 returncmd.DbCommand.ExecuteScalar();144 }145 }146 }147 ///

148 ///执行sql语句或存储过程返回ExecuteScalar (返回自增的ID)149 ///

150 /// 连接字符串，可以自定义，可