public void ShouldDispose()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
"After creating a database"
._(() => connectionProvider.CreateDatabase());
using (var lifecycle = connectionProvider.ToSelfDeletingDisposable())
{
"Make sure the table doesn't exist"
._(() =>
{
var doesTableExist = connectionProvider.CheckTableExistence("dbo", "SimpleClass");
doesTableExist.Should().BeFalse();
});
"Create the table"
._(() =>
{
connectionProvider.EnsureTableExists <SimpleClass>("dbo", "SimpleClass");
});
"Make sure the table does exist"
._(() =>
{
var doesTableExist = connectionProvider.CheckTableExistence("dbo", "SimpleClass");
doesTableExist.Should().BeTrue();
});
"Truncate the table"
._(() =>
{
connectionProvider.TruncateTable("dbo", "SimpleClass");
});
"Delete the table"
._(() =>
{
connectionProvider.DropTable("dbo", "SimpleClass");
});
"Make sure the table doesn't exist"
._(() =>
{
var doesTableExist = connectionProvider.CheckTableExistence("dbo", "SimpleClass");
doesTableExist.Should().BeFalse();
});
}
}
