private async Task clearExistingState(CancellationToken token) { _logger.ClearingExistingState(this); var types = _projection.ProjectedTypes(); using (var conn = _tenant.OpenConnection()) { foreach (var type in types) { var tableName = _tenant.MappingFor(type).TableName; var sql = $"delete from {_store.Events.DatabaseSchemaName}.mt_event_progression where name = :name;truncate {tableName} cascade"; var cmd = new NpgsqlCommand(sql).With("name", _projection.GetEventProgressionName(type)); await conn.ExecuteAsync(cmd, token); } } LastEncountered = 0; }
private async Task clearExistingState(CancellationToken token) { _logger.ClearingExistingState(this); var types = _projection.ProjectedTypes(); using (var conn = _tenant.OpenConnection()) { foreach (var type in types) { var tableName = _tenant.MappingFor(type).Table; var sql = $"delete from {_store.Events.DatabaseSchemaName}.mt_event_progression where name = :name;truncate {tableName} cascade"; await conn.ExecuteAsync(async (cmd, tkn) => { await cmd.Sql(sql) .With("name", type.FullName) .ExecuteNonQueryAsync(tkn) .ConfigureAwait(false); }, token); } } LastEncountered = 0; }