public Task DeleteAsync(K id)
{
return(SQLTask.SQLTaskExecute(async() =>
{
using (var conn = tableInfo.CreateConnection())
{
await conn.ExecuteAsync(deleteSql, new { StateId = id });
}
}));
}
public async Task CompleteAsync <T>(T data) where T : IEventBase <K>
{
var table = await tableInfo.GetTable(data.Timestamp);
if (!completeSqlDict.TryGetValue(table.Name, out var sql))
{
sql = $"UPDATE {table.Name} set iscomplete=TRUE where id=@Id";
completeSqlDict.TryAdd(table.Name, sql);
}
using (var conn = tableInfo.CreateConnection())
{
await conn.ExecuteAsync(sql, new { Id = data.Id });
}
}