/// <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); }