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