public void TestExecuteScalar()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
using (connectionProvider.ToSelfDeletingDisposable())
{
connectionProvider.CreateDatabase();
connectionProvider.ExecuteScalar <int>("Select 1");
}
}
public void TestExecute()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
using (connectionProvider.ToSelfDeletingDisposable())
{
connectionProvider.CreateDatabase();
connectionProvider.ExecuteNonDapper("Use [" + connectionProvider.DatabaseName + "]");
}
}
public void ShouldDispose()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
"After creating a database"
._(() => connectionProvider.CreateDatabase());
"Disposing of the disposable provided by the ToSelfDeletingDisposable extension method should delete the database"
._(() =>
{
using (var lifecycle = connectionProvider.ToSelfDeletingDisposable())
{
var result = connectionProvider.ExecuteScalar <int>("SELECT 1 ");
}
});
}
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();
});
}
}
public void InsertSimpleClass()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
"After creating a database"
._(() => connectionProvider.CreateDatabase());
using (var lifecycle = connectionProvider.ToSelfDeletingDisposable())
{
BddStringExtensions._("Create the table", () =>
{
connectionProvider.EnsureTableExists <SimpleClass>("dbo", "SimpleClass");
});
BddStringExtensions._("Insert into the table", () =>
{
connectionProvider.Insert(SimpleClass.GetSample(), "SimpleClass");
});
}
}
public void SlowBulkInsertSimpleClass()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
"After creating a database"
._(() => connectionProvider.CreateDatabase());
using (var lifecycle = connectionProvider.ToSelfDeletingDisposable())
{
BddStringExtensions._("Create the table", () =>
{
connectionProvider.EnsureTableExists <SimpleClass>("dbo", "SimpleClass");
});
BddStringExtensions._("Insert into the table", () =>
{
var listOfSimpleClass = Enumerable.Range(0, 1000).Select(i => SimpleClass.GetSample()).ToList();
foreach (var simpleClass in listOfSimpleClass)
{
connectionProvider.Insert(simpleClass, "SimpleClass");
}
});
}
}
