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