public static void RunScript(string scriptPath) { using (DatabaseContext _DatabaseContext = new DatabaseContext()) { _DatabaseContext.ExecuteStoreCommand(Filer.ReadFromFile(scriptPath)); } }
public static void DeleteDatabaseIfExists() { using (DatabaseContext _DatabaseContext = new DatabaseContext()) { if (_DatabaseContext.DatabaseExists()) _DatabaseContext.DeleteDatabase(); } }
public static void CreateDatabaseIfDoesNotExist() { using (DatabaseContext _DatabaseContext = new DatabaseContext()) { if (!_DatabaseContext.DatabaseExists()) _DatabaseContext.CreateDatabase(); } }
public static string TestSqlClientConnectionString() { string connStr = string.Empty; using (DatabaseContext _db = new DatabaseContext()) { connStr = (_db.Connection as System.Data.EntityClient.EntityConnection).StoreConnection.ConnectionString; } return TestSqlClientConnectionString(connStr); }
public void ConnectionTest_OpensAConnection_ShouldPassIfSuccessful() { try { using (DatabaseContext db = new DatabaseContext()) { db.Connection.Open(); db.Connection.Close(); } } catch (Exception e) { Assert.Fail(e.Message); } }
protected void buttonCreateDatabase_Click(object sender, EventArgs e) { try { string newConnectionString = BuildEntityFrameworkConnectionStringForSqlClient ( txtServerAddress.Text, txtDbName.Text, chkUseIntegratedSecurity.Checked, txtUsername.Text, txtPassword.Text ); //create database using (DatabaseContext _DatabaseContext = new DatabaseContext()) { ((EntityConnection)_DatabaseContext.Connection).StoreConnection.ConnectionString = BuildSqlClientConnectionString ( txtServerAddress.Text, txtDbName.Text, chkUseIntegratedSecurity.Checked, txtUsername.Text, txtPassword.Text ); if (!_DatabaseContext.DatabaseExists()) { _DatabaseContext.CreateDatabase(); } } //save the new db connectionstring to config files SaveConnectionStringKey(Server.MapPath("~/web.config"), "DatabaseContext", newConnectionString); //show the proper message labelMessage.Text = MessageFormatter.GetFormattedNoticeMessage("Database created successfully. Click the Create 'Install Schema and Data' button to install database."); buttonInstall.Visible = true; txtDbName.ReadOnly = true; } catch (Exception ex) { labelMessage.Text = MessageFormatter.GetFormattedErrorMessage("Database creation failed: " + ex.Message); buttonInstall.Visible = false; } }