/// <summary>
/// 删除数据
/// </summary>
public void Delete()
{
SqlDb db = new PostgreSqlDb(_connString);
db.IsShowSqlToConsole = _isShowSqlToConsole;
var dbFactory = db.DbBuilder.DbFactory;
var dbOperator = dbFactory.GetDbParamOperator();
//根据实体主键参数值查询数据
var result = db.Delete <UserInfo>(1);
//根据过滤SQL、过滤参数查询数据列表1
result = db.Delete <UserInfo>("UserId=2", null);
result = db.Delete <UserInfo>(string.Format("UserId={0}UserId", dbOperator), new { UserId = 3 });
}
/// <summary>
/// 删除所有数据
/// </summary>
public void DeleteAll()
{
SqlDb db = new PostgreSqlDb(_connString);
db.IsShowSqlToConsole = _isShowSqlToConsole;
var dbFactory = db.DbBuilder.DbFactory;
var dbOperator = dbFactory.GetDbParamOperator();
var result = db.Delete <UserInfo>("", null);
}
