GZDBHelper
2024-09-04 13:38:40
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);
}
}
使用例子:
最新文章
- BrnShop mvc3升级mvc4
- PHP扩展开发及内核应用
- 谈谈vertical-align的text-bottom和text-top - 韦奕
- 理解button标签的默认行为
- RBL开发笔记三
- python学习之路-day3
- CoreOS
- 为Python添加默认模块搜索路径
- BZOJ 1036 树的统计-树链剖分
- FreeMarker笔记 前言&;第1章 入门
- 2.4 easyui - panel的使用
- C#程序及批处理中确定windows操作系统的方法
- 错误:Unsupported major.minor version 51.0的解决
- useradd和adduser
- Sql 优化解决方案
- IdentityServer4客户端如何获取自定义声明,了解一下?
- Python爬虫3-parse编码与利用parse模拟post请求
- adoquery怎样判断数据在缓存中有修改啊
- Java 接口 Closeable
- MATLAB:图像水平、垂直、水平垂直镜像、转置、旋转变换(flipdim、mirror、transp、imrotate函数)