数据访问层之疑问（DBHelper.cs）急

Question

我找到这么个文件DBHelper.cs
里面是using System;
using System.Data;
using System.Data.Common;
using System.Configuration;        public class DbHelper
        {
                private static string dbProviderName = ConfigurationManager.AppSettings["DbHelperProvider"];
                private static string dbConnectionString = ConfigurationManager.AppSettings["DbHelperConnectionString"];                private DbConnection connection;
                public DbHelper()
                {
                    this.connection = CreateConnection(DbHelper.dbConnectionString);
                }
                public DbHelper(string connectionString)
                {
                    this.connection = CreateConnection(connectionString);
                }
                public static DbConnection CreateConnection()
                {
                    DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);
                    DbConnection dbconn = dbfactory.CreateConnection();
                    dbconn.ConnectionString = DbHelper.dbConnectionString;
                    return dbconn;
                }
                public static DbConnection CreateConnection(string connectionString)
                {
                    DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);
                    DbConnection dbconn = dbfactory.CreateConnection();
                    dbconn.ConnectionString = connectionString;
                    return dbconn;
                }
                /// <summary>
                /// 执行的存储过程
                /// </summary>
                /// <param name="storedProcedure"></param>
                /// <returns></returns>
                public DbCommand GetStoredProcCommond(string storedProcedure)
                {
                    DbCommand dbCommand = connection.CreateCommand();
                    dbCommand.CommandText = storedProcedure;
                    dbCommand.CommandType = CommandType.StoredProcedure;
                    return dbCommand;
                }
                /// <summary>
                /// 执行的sql语句
                /// </summary>
                /// <param name="sqlQuery"></param>
                /// <returns></returns>
                public DbCommand GetSqlStringCommond(string sqlQuery)
                {
                    DbCommand dbCommand = connection.CreateCommand();
                    dbCommand.CommandText = sqlQuery;
                    dbCommand.CommandType = CommandType.Text;
                    return dbCommand;
                }                //增加参数#region 增加参数
                public void AddParameterCollection(DbCommand cmd, DbParameterCollection dbParameterCollection)
                {
                    foreach (DbParameter dbParameter in dbParameterCollection)
                    {
                        cmd.Parameters.Add(dbParameter);
                    }
                }
                /// <summary>
                /// 增加输出参数 适用于存储过程
                /// </summary>
                /// <param name="cmd">cmd对象</param>
                /// <param name="parameterName">参数名</param>
                /// <param name="dbType">参数类型</param>
                /// <param name="size">参数大小</param>
                public void AddOutParameter(DbCommand cmd, string parameterName, DbType dbType, int size)
                {
                    DbParameter dbParameter = cmd.CreateParameter();
                    dbParameter.DbType = dbType;
                    dbParameter.ParameterName = parameterName;
                    dbParameter.Size = size;
                    dbParameter.Direction = ParameterDirection.Output;
                    cmd.Parameters.Add(dbParameter);
                }
                /// <summary>
                /// 增加参数列表
                /// </summary>
                /// <param name="cmd">CMD对象</param>
                /// <param name="parameterName">参数名</param>
                /// <param name="dbType">参数类型</param>
                /// <param name="value">参数值</param>
                public void AddInParameter(DbCommand cmd, string parameterName, DbType dbType, object value)
                {
                    DbParameter dbParameter = cmd.CreateParameter();
                    dbParameter.DbType = dbType;
                    dbParameter.ParameterName = parameterName;
                    dbParameter.Value = value;
                    dbParameter.Direction = ParameterDirection.Input;
                    cmd.Parameters.Add(dbParameter);
                }
                /// <summary>
                /// 增加返回参数 适用于存储过程
                /// </summary>
                /// <param name="cmd"></param>
                /// <param name="parameterName"></param>
                /// <param name="dbType"></param>
                public void AddReturnParameter(DbCommand cmd, string parameterName, DbType dbType)
                {
                    DbParameter dbParameter = cmd.CreateParameter();
                    dbParameter.DbType = dbType;
                    dbParameter.ParameterName = parameterName;
                    dbParameter.Direction = ParameterDirection.ReturnValue;
                    cmd.Parameters.Add(dbParameter);
                }
                public DbParameter GetParameter(DbCommand cmd, string parameterName)
                {
                    return cmd.Parameters[parameterName];
                }    
        }
我现在用的是MYSQL数据库
那我把这里面的方法直接和MYSQL一起用吗还用这方法为什么是Db开头而不是SQL或Oledb开头？？
这个是不是一个通用的类   不管用什么数据库  都能这里面的方法是吧？？

Answer 1

参考：http://www.cnsdn.com.cn/blog/article.asp?id=2171另外你可以封装一下，具体参考：http://www.svnhost.cn/Article/Detail-75.shtml

Answer 2

它使用的是System.Data.Common命名空间下的东西
使用各种数据提供程序共享的类查阅msdn下这个命名空间的说明 有个链接是"在 ADO.NET 中编写与提供程序无关的代码"至于楼主提的问题 我不清楚 你可以试试看啊 呵呵~

Answer 3

.net的mysql方法我会
我想知道是不是
这个是不是一个通用的类？不管用什么数据库是不是都能用这里面的方法？
还用这方法为什么是Db开头而不是SQL或Oledb开头？？ 

Answer 4

这个只能在SQL SERVER下使用 假如你要使用Mysql的话，需要重新做，假如要做成通用的，mysql ，sql server等都可以用的就要向外扩张

Answer 5

mysql应该不可以用吧，语法有略微不同