public static OutboxCommands Build(string tablePrefix, SqlDialect sqlDialect)
{
var tableName = sqlDialect.GetOutboxTableName(tablePrefix);
var storeCommandText = sqlDialect.GetOutboxStoreCommand(tableName);
var cleanupCommand = sqlDialect.GetOutboxCleanupCommand(tableName);
var getCommandText = sqlDialect.GetOutboxGetCommand(tableName);
var setAsDispatchedCommand = sqlDialect.GetOutboxSetAsDispatchedCommand(tableName);
return(new OutboxCommands(
store: storeCommandText,
get: getCommandText,
setAsDispatched: setAsDispatchedCommand,
cleanup: cleanupCommand));
}
public static OutboxCommands Build(SqlDialect sqlDialect, string tablePrefix)
{
var tableName = sqlDialect.GetOutboxTableName(tablePrefix);
var optimisticStoreCommandText = sqlDialect.GetOutboxOptimisticStoreCommand(tableName);
var pessimisticBeginCommandText = sqlDialect.GetOutboxPessimisticBeginCommand(tableName);
var pessimisticCompleteCommandText = sqlDialect.GetOutboxPessimisticCompleteCommand(tableName);
var cleanupCommand = sqlDialect.GetOutboxCleanupCommand(tableName);
var getCommandText = sqlDialect.GetOutboxGetCommand(tableName);
var setAsDispatchedCommand = sqlDialect.GetOutboxSetAsDispatchedCommand(tableName);
return(new OutboxCommands(
optimisticStoreCommandText,
pessimisticBeginCommandText,
pessimisticCompleteCommandText,
getCommandText,
setAsDispatchedCommand,
cleanupCommand));
}
internal override string GetOutboxCleanupCommand(string tableName)
{
return(impl.GetOutboxCleanupCommand(tableName));
}