public void TestCustomDatabaseName() { //you can also create a new database per test (it's not very fast) //here we customise the database name and put the file in %TEMP% var options = new TestDatabaseOptions("ProductContext") { DatabaseName = "Test", DatabaseFilePath = Path.Combine(Path.GetTempPath(), "Test"), //DataSource = @".\SqlExpress", //if this is installed }; var td = new CreateTestDatabase.TestDatabase(options); td.CreateDatabase(); td.InitConnectionString(); //if you've already done this with AssemblyInitialize, EF has been initialized and the connection string is different //NB: this isn't the connection string in app.config var connectionString = ConfigurationManager.ConnectionStrings["ProductContext"].ConnectionString; using (var con = new SqlConnection(connectionString)) { Assert.AreEqual("(LocalDB)\\MSSQLLocalDB", con.DataSource); Assert.AreEqual("Test", con.Database); } }
public void TestCustomDatabaseName() { //you can also create a new database per test (it's not very fast) //here we customise the database name and put the file in %TEMP% var options = new TestDatabaseOptions("ProductContext") { DatabaseName = "Test", DatabaseFilePath = Path.Combine(Path.GetTempPath(), "Test"), //DataSource = @".\SqlExpress", //if this is installed }; var td = new CreateTestDatabase.TestDatabase(options); td.CreateDatabase(); td.InitConnectionString(); //if you've already done this with AssemblyInitialize, EF has been initialized and the connection string is different //NB: this isn't the connection string in app.config var connectionString = ConfigurationManager.ConnectionStrings["ProductContext"].ConnectionString; using (var con = new SqlConnection(connectionString)) { Assert.AreEqual("(LocalDB)\\MSSQLLocalDB", con.DataSource); Assert.AreEqual("Test", con.Database); } }
/// <summary> /// Creates a temporary database overriding the app.Config connectionString to create a SqlServer 14 localDb. /// </summary> /// <param name="connectionStringName">Name of the connection string.</param> /// <exception cref="System.ArgumentNullException">connectionStringName</exception> public static void Create(string connectionStringName) { if (connectionStringName == null) throw new ArgumentNullException("connectionStringName"); var td = new TestDatabase(new TestDatabaseOptions(connectionStringName)); td.CreateDatabase(); td.InitConnectionString(); }
/// <summary> /// Creates a temporary database overriding the app.Config connectionString to create a SqlServer 14 localDb. /// </summary> /// <param name="connectionStringName">Name of the connection string.</param> /// <exception cref="System.ArgumentNullException">connectionStringName</exception> public static void Create(string connectionStringName) { if (connectionStringName == null) { throw new ArgumentNullException("connectionStringName"); } var td = new TestDatabase(new TestDatabaseOptions(connectionStringName)); td.CreateDatabase(); td.InitConnectionString(); }