DBUtility/SqlServer.cs

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

using System.Data;
using System.Data.Common;
using System.Data.SqlClient;

namespace DBUtility
{
    public class SqlServer : DbHelper
    {
        public override IDbConnection CreateConnection()
        {
            return new SqlConnection(ConnectionString);
        }

        public override IDbCommand CreateCommand()
        {
            return new SqlCommand();
        }

        public override DbDataAdapter CreateDataAdapter(IDbCommand selectCommand,
            IDbCommand insertCommand, IDbCommand deleteCommand, IDbCommand updateCommand)
        {
            SqlDataAdapter adapter = new SqlDataAdapter();
            if (selectCommand != null)
                adapter.SelectCommand = selectCommand as SqlCommand;
            if (insertCommand != null)
                adapter.InsertCommand = insertCommand as SqlCommand;
            if (deleteCommand != null)
                adapter.DeleteCommand = deleteCommand as SqlCommand;
            if (updateCommand != null)
                adapter.UpdateCommand = updateCommand as SqlCommand;
            return adapter;
        }

        public override IDbDataParameter CreateDbParameter(string parameterName)
        {
            IDbDataParameter parameter = new SqlParameter();
            parameter.ParameterName = parameterName.Replace("?", "@").Replace(":", "@");
            return parameter;
        }
    }
}