public bool Delete(Where where) {
using (SqlCommand command = new DbHelper().Command) {
string sql = $"delete from {Table} where {where.Result};";
return command.ExecuteNonQueryExt(sql, where) > 0;
}
}
public bool Update(Update update) {
Dictionary<string, dynamic> dic = update.Dic;
string where = update.WhereCore.Result;
string fv = string.Join(",", dic.Select(pair => $"{pair.Key}=@{pair.Key}"));
string sql = $"update {Table} set {fv} where {where};";
using (SqlCommand command = new DbHelper().Command) {
command.CommandText = sql;
int ret = command.ExecuteNonQueryExt(sql, update);
return ret > 0;
}
}
