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