/// <summary> /// 删除数据 /// </summary> public void Delete() { SqlDb db = new SQLiteDb(_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 }); }
public override DataSet UpdateCategory(string q) { category.Tables.Clear(); using (SQLiteDb db = new SQLiteDb(datafile)) category = db.Delete(Context.CategoryName, q, UpdateCategoryAdapter, UpdateCategoryFillOperation); return(category); }
/// <summary> /// 删除所有数据 /// </summary> public void DeleteAll() { SqlDb db = new SQLiteDb(_connString); db.IsShowSqlToConsole = _isShowSqlToConsole; var dbFactory = db.DbBuilder.DbFactory; var dbOperator = dbFactory.GetDbParamOperator(); var result = db.Delete <UserInfo>("", null); }
/// <inheritdoc/> public override DataSet Delete(string q) { data.Tables.Clear(); using (SQLiteDb db = new SQLiteDb(datafile)) data = db.Delete(Context.TableName, q, AdapterDelete, FillDelete); return(data); }