首页 > 数据库技术 > 详细

GZDBHelper

时间:2017-09-11 16:06:58      阅读:375      评论:0      收藏:0      [点我收藏+]

NuGet:GZDBHelper

 

初始化:

 public class APIBase : ApiController
    {
        protected GZDBHelper.IDatabase db;
        public APIBase()
        {
            string sql = GZDBHelper.ConnectionStrings.BuildMSSQLConnectionString("local", "WDKB", "sa", "test");
            db = GZDBHelper.DatabaseFactory.CreateDatabase(sql, GZDBHelper.ConnectionStrings.ProviderNames.ProviderNameForMSSql, null);
        }
    }

命令参数类:

 public class SqlParameterProvider : DbParameterBase
    {

        //DbParameter GenerateParmeter(string parameterName, object value);

        //DbParameter GenerateParmeter(string parameterName, SqlDbType dbType);

        //DbParameter GenerateParmeter(string parameterName, SqlDbType dbType, int size);

        //DbParameter GenerateParmeter(string parameterName, SqlDbType dbType, int size, string sourceColumn);
        //protected abstract DbParameter GenerateParmeter(string parameterName, SqlDbType dbType, int size, string sourceColumn, ParameterDirection direction);

        //DbParameter GenerateParmeter(string parameterName, SqlDbType dbType, int size, ParameterDirection direction, bool isNullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value);

        //DbParameter SqlParameter(string parameterName, SqlDbType dbType, int size, ParameterDirection direction, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, bool sourceColumnNullMapping, object value, string xmlSchemaCollectionDatabase, string xmlSchemaCollectionOwningSchema, string xmlSchemaCollectionName);
        public void AddParameter(string parameterName, object value)
        {
            SqlParameter parm = new SqlParameter(parameterName, value);
            AddParameter(parm);
        }
        public void AddParameter(string parameterName, SqlDbType dbType, object value)
        {
            SqlParameter parm = new SqlParameter(parameterName, dbType);
            parm.Value = value;
            AddParameter(parm);
        }

        public void AddParameter(string parameterName, SqlDbType dbType, int size, object value)
        {
            SqlParameter parm = new SqlParameter(parameterName, dbType, size);
            parm.Value = value;
            AddParameter(parm);
        }
        public void AddParameter(string parameterName, SqlDbType dbType, int size, object value, ParameterDirection direction)
        {
            SqlParameter parm = new SqlParameter(parameterName, dbType, size);
            parm.Value = value;
            parm.Direction = direction;
            AddParameter(parm);
        }
        public void AddParameter(string parameterName, SqlDbType dbType, int size, object value, string sourceColumn)
        {
            SqlParameter parm = new SqlParameter(parameterName, dbType, size, sourceColumn);
            parm.Value = value;
            AddParameter(parm);
        }
    }

 使用例子:

技术分享

 

GZDBHelper

原文:http://www.cnblogs.com/GarsonZhang/p/7505329.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!