static DatabaseCreateOrUpdateResponse CreateOrUpdateDatabase(SqlManagementClient sqlMgmtClient, string resourceGroupName, string serverName, string databaseName, string databaseEdition, string databasePerfLevel) { // Retrieve the server that will host this database Server currentServer = sqlMgmtClient.Servers.Get(resourceGroupName, serverName).Server; // Create a database: configure create or update parameters and properties explicitly DatabaseCreateOrUpdateParameters newDatabaseParameters = new DatabaseCreateOrUpdateParameters() { Location = currentServer.Location, Properties = new DatabaseCreateOrUpdateProperties() { CreateMode = DatabaseCreateMode.Default, Edition = databaseEdition, RequestedServiceObjectiveName = databasePerfLevel } }; DatabaseCreateOrUpdateResponse dbResponse = sqlMgmtClient.Databases.CreateOrUpdate(resourceGroupName, serverName, databaseName, newDatabaseParameters); return(dbResponse); }
static string _databasePerfLevel = ""; // "S0", "S1", and so on here for other tiers static void Main(string[] args) { // Authenticate: _token = GetToken(_tenantId, _applicationId, _applicationSecret); Console.WriteLine("Token acquired. Expires on:" + _token.ExpiresOn); // Instantiate management clients: _resourceMgmtClient = new ResourceManagementClient(new Microsoft.Rest.TokenCredentials(_token.AccessToken)); _sqlMgmtClient = new SqlManagementClient(new TokenCloudCredentials(_subscriptionId, _token.AccessToken)); Console.WriteLine("Resource group..."); ResourceGroup rg = CreateOrUpdateResourceGroup(_resourceMgmtClient, _subscriptionId, _resourceGroupName, _resourceGrouplocation); Console.WriteLine("Resource group: " + rg.Id); Console.WriteLine("Server..."); ServerGetResponse sgr = CreateOrUpdateServer(_sqlMgmtClient, _resourceGroupName, _serverlocation, _serverName, _serverAdmin, _serverAdminPassword); Console.WriteLine("Server: " + sgr.Server.Id); Console.WriteLine("Server firewall..."); FirewallRuleGetResponse fwr = CreateOrUpdateFirewallRule(_sqlMgmtClient, _resourceGroupName, _serverName, _firewallRuleName, _startIpAddress, _endIpAddress); Console.WriteLine("Server firewall: " + fwr.FirewallRule.Id); Console.WriteLine("Database..."); DatabaseCreateOrUpdateResponse dbr = CreateOrUpdateDatabase(_sqlMgmtClient, _resourceGroupName, _serverName, _databaseName, _databaseEdition, _databasePerfLevel); Console.WriteLine("Database: " + dbr.Database.Id); Console.WriteLine("Press any key to continue..."); Console.ReadKey(); }