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 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 ");
}
});
}
