static private CreateDatabase ( string connectString, string databaseName ) : void | ||
connectString | string | |
databaseName | string | |
return | void |
internal static void CreateDatabase(string connectString, string databaseName)
{
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
try
{
conn.ConnectionString = connectString;
conn.Open();
SqlCommand cmdCreateDb = new SqlCommand();
cmdCreateDb.CommandText = "CREATE DATABASE " + databaseName;
cmdCreateDb.CommandType = System.Data.CommandType.Text;
cmdCreateDb.Connection = conn;
cmdCreateDb.ExecuteNonQuery();
}
catch(Exception ex)
{
throw;
}
finally
{
if(conn != null)
conn.Close();
}
}
#endregion
public void Install(string masterConnectionString, string newDatabaseName, string newDatabaseConnectionString) { SqlServers.CreateDatabase(masterConnectionString, newDatabaseName); DateTime startTime = DateTime.Now; while (DateTime.Now.Subtract(startTime).TotalSeconds < 9) { Application.DoEvents(); } try { UpgradeInstaller.UpgradeDatabase(newDatabaseConnectionString, true); } catch (Exception ex) { System.Threading.Thread.Sleep(8000); try { UpgradeInstaller.UpgradeDatabase(newDatabaseConnectionString, true); } catch { throw; } } }