public static void Initialise(SqlServerDbClientFactory factory, SqlServerDbSettings settings)
{
{
TryCreateTable();
}
void TryCreateTable()
{
using (var tx = new TransactionScope(TransactionScopeOption.RequiresNew))
{
using (var connection = factory.OpenClient())
{
using (var command = new SqlCommand(
@"
IF NOT EXISTS (
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_CATALOG = '" + settings.Database + @"'
AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = '" + settings.TableName + @"'
)
BEGIN
CREATE TABLE " + settings.Database + @".dbo." + settings.TableName + @" (
AggregateId uniqueidentifier NOT NULL PRIMARY KEY NONCLUSTERED,
[Schema] nvarchar(250) NOT NULL,
Json nvarchar(max) NOT NULL,
Version rowversion NOT NULL,
[ClusterId] int NOT NULL IDENTITY(1,1) UNIQUE CLUSTERED,
);
CREATE NONCLUSTERED INDEX IX_Schema ON " + settings.TableName + @"([Schema])
END",
connection))
{
command.ExecuteNonQuery();
}
}
tx.Complete();
}
}
}
public SqlServerDbClientFactory(SqlServerDbSettings config)
{
this.config = config;
}
public SqlServerRepository(SqlServerDbSettings settings)
{
this.settings = settings;
this.clientFactory = new SqlServerDbClientFactory(settings);
SqlServerDbInitialiser.Initialise(this.clientFactory, settings);
}
