Acme.PROJECTNAME.Install.SqlServers.CreateDatabase C# (CSharp) Метод

CreateDatabase() статический приватный Метод

static private CreateDatabase ( string connectString, string databaseName ) : void
connectString string
databaseName string
Результат 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

Usage Example

Пример #1
0
        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;
                }
            }
        }