public static void CreateQueue(this SqlTransaction tran, SqlObjectName queueName)
{
var script = LoadScript("CreateQueue");
script = script.Replace("{queueName}", queueName);
tran.ExecuteNonQuery(script);
}
public static void CreateMessageType(this SqlTransaction tran, SqlSchemalessObjectName messageTypeName)
{
var script = LoadScript("CreateMessageType");
script = script.Replace("{messageTypeName.Name}", messageTypeName.Name);
script = script.Replace("{messageTypeName}", messageTypeName);
tran.ExecuteNonQuery(script);
}
public static void CreateService(this SqlTransaction tran, SqlSchemalessObjectName serviceName, SqlObjectName queueName, SqlSchemalessObjectName contractName)
{
var script = LoadScript("CreateService");
script = script.Replace("{serviceName.Name}", serviceName.Name);
script = script.Replace("{serviceName}", serviceName);
script = script.Replace("{queueName}", queueName);
script = script.Replace("{contractName}", contractName);
tran.ExecuteNonQuery(script);
}
private static void CreateTrigger(this SqlTransaction tran, string triggerResource, SqlObjectName triggerName, SqlObjectName tableName, string dialogHandle, SqlSchemalessObjectName messageType, bool withNative)
{
var script = LoadScript(triggerResource);
script = script.Replace("{triggerName}", triggerName);
script = script.Replace("{tableName.Schema}", tableName.Schema);
script = script.Replace("{tableName.Name}", tableName.Name);
script = script.Replace("{tableName}", tableName);
script = script.Replace("{dialogHandle}", dialogHandle);
script = script.Replace("{messageType}", messageType);
if (withNative)
{
script = script.Replace("{with}", "WITH NATIVE_COMPILATION, SCHEMABINDING");
script = script.Replace("{as}", "BEGIN ATOMIC WITH ( TRANSACTION ISOLATION LEVEL = SNAPSHOT, LANGUAGE = N'us_english' )");
}
else
{
script = script.Replace("{with}", String.Empty);
script = script.Replace("{as}", String.Empty);
}
tran.ExecuteNonQuery(script);
}
public static void UpdateMessage(this SqlTransaction transaction, int id, string text)
{
transaction.ExecuteNonQuery($"UPDATE [dbo].[Messages] SET [Text] = '{text}' WHERE [Id] = {id}");
}
public static void InsertMessage(this SqlTransaction transaction, string text)
{
transaction.ExecuteNonQuery($"INSERT INTO [dbo].[Messages] ([Text]) VALUES (N'{text}')");
}
public static void EndConversation(this SqlTransaction tran, Guid conversation)
{
tran.ExecuteNonQuery($"DECLARE @dialog_handle UNIQUEIDENTIFIER = '{conversation}';{Environment.NewLine}END CONVERSATION @dialog_handle WITH CLEANUP;");
}
public static void DropQueue(this SqlTransaction tran, SqlObjectName queueName)
{
tran.ExecuteNonQuery($"DROP QUEUE {queueName}");
}
public static void DropService(this SqlTransaction tran, SqlSchemalessObjectName serviceName)
{
tran.ExecuteNonQuery($"DROP SERVICE {serviceName}");
}
public static void DropContract(this SqlTransaction tran, SqlSchemalessObjectName contract)
{
tran.ExecuteNonQuery($"DROP CONTRACT {contract}");
}
public static void DropMessageType(this SqlTransaction tran, SqlSchemalessObjectName messageTypeName)
{
tran.ExecuteNonQuery($"DROP MESSAGE TYPE {messageTypeName}");
}
public static void DropTrigger(this SqlTransaction tran, SqlObjectName triggerName)
{
tran.ExecuteNonQuery($"DROP TRIGGER {triggerName}");
}