public void Create(AzureDatabaseTierDetails azureDetails = null) { using (var connection = SqlConnectionFactory.CreateAndOpen(_builder.CloneForMaster().ConnectionString)) using (var command = new SqlCommand(Commands.Database_Create, connection)) { if (azureDetails != null && _server.IsAzure()) { if (!string.IsNullOrWhiteSpace(azureDetails.ElasticPool)) { command.CommandText = Commands.Database_Create_Azure_Pool .Replace("@ElasticPool", azureDetails.ElasticPool); } else { command.CommandText = Commands.Database_Create_Azure_Single .Replace("@Edition", azureDetails.Edition) .Replace("@ServiceObjective", azureDetails.ServiceObjective); } } command.CommandText = command.CommandText.Replace("@Database", _builder.InitialCatalog); command.ExecuteNonQuery(); } }