/// <summary> /// Creates an instance of external child resource in-memory. /// </summary> /// <param name="name">The name of this external child resource.</param> /// <param name="innerObject">Reference to the inner object representing this external child resource.</param> /// <param name="sqlServerManager">Reference to the SQL server manager that accesses firewall rule operations.</param> ///GENMHASH:F958650D21263F491EB84C4B1B980363:F9DB363750091A34604F0E5CF4D066EE internal SqlDatabaseImpl(string name, DatabaseInner innerObject, ISqlManager sqlServerManager) : base(innerObject, null) { this.name = name; this.sqlServerManager = sqlServerManager ?? throw new ArgumentNullException("sqlServerManager"); this.isPatchUpdate = false; this.importRequestInner = null; }
///GENMHASH:1C25D7B8D9084176A24655682A78634D:ABBCB4CE203E2AC2B27991A84095239D public ISqlDatabase GetDatabase(string databaseName) { DatabaseInner database = Extensions.Synchronize(() => Manager.Inner.ElasticPools.GetDatabaseAsync( ResourceGroupName, SqlServerName(), Name, databaseName)); return(new SqlDatabaseImpl(database.Name, database, Manager)); }
/// <summary> /// Creates an instance of external child resource in-memory. /// </summary> /// <param name="name">The name of this external child resource.</param> /// <param name="parent">Reference to the parent of this external child resource.</param> /// <param name="innerObject">Reference to the inner object representing this external child resource.</param> /// <param name="sqlServerManager">Reference to the SQL server manager that accesses firewall rule operations.</param> ///GENMHASH:A35E7EC57FEC5C249FB11AEB50216560:C7DB22944BBAB9F9EBF4DC3ECB3D4098 internal SqlDatabaseImpl(string name, SqlServerImpl parent, DatabaseInner innerObject, ISqlManager sqlServerManager) : base(innerObject, parent) { if (parent == null) { throw new ArgumentNullException("parent"); } this.name = name; this.sqlServerManager = sqlServerManager ?? throw new ArgumentNullException("sqlServerManager"); this.resourceGroupName = parent.ResourceGroupName; this.sqlServerName = parent.Name; this.sqlServerLocation = parent.RegionName; this.isPatchUpdate = false; this.importRequestInner = null; }
public async Task <bool> CreateDatabaseAsync(string dbName, string elasticPool, string location, CreateMode createMode, DatabaseEdition databaseEdition, string collation = "SQL_Latin1_General_CP1_CI_AS") { var dbInner = new DatabaseInner { ElasticPoolName = elasticPool, Location = location, Collation = collation, CreateMode = createMode, Edition = databaseEdition, }; var resultDbInner = await client.Databases.CreateOrUpdateAsync(azureResourceGroup, azureSQLServer, dbName, dbInner); return(string.IsNullOrEmpty(resultDbInner.Name) ? false : true); }
public async Task <bool> CreateDatabaseAsync(string databaseName) { var dbInner = new DatabaseInner { ElasticPoolName = _azureOptions.Value.ElasticPoolName, Location = Region.EuropeNorth.ToString(), Collation = CatalogCollationType.SQLLatin1GeneralCP1CIAS.ToString(), Edition = DatabaseEdition.GeneralPurpose, RequestedServiceObjectiveName = ServiceObjectiveName.ElasticPool, }; var resultDbInner = await _client.Databases.CreateOrUpdateAsync(_azureOptions.Value.ResourceGroupName, _azureOptions.Value.ServerName, databaseName, dbInner); return(!string.IsNullOrEmpty(resultDbInner.Name)); }
///GENMHASH:5E107B23DE34DEBD4ED372100F2024F8:0AF0D08DA20B3ABFC0CC6C3AE431D719 public SqlWarehouseImpl(string resourceGroupName, string sqlServerName, string sqlServerLocation, string name, DatabaseInner innerObject, ISqlManager sqlServerManager) : base(resourceGroupName, sqlServerName, sqlServerLocation, name, innerObject, sqlServerManager) { }
///GENMHASH:01F4015FD664AFA09FE455D9F817F348:C99C685A9D673A92118B74962283411C public SqlWarehouseImpl(string name, SqlServerImpl parent, DatabaseInner innerObject, ISqlManager sqlServerManager) : base(name, parent, innerObject, sqlServerManager) { }
/// <summary> /// Creates a new Azure SQL database or updates an existing Azure SQL database. /// Location is a required property in the request body, and it must be the /// same as the location of the SQL server. /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='resourceGroupName'> /// The name of the resource group that contains the resource. You can obtain /// this value from the Azure Resource Manager API or the portal. /// </param> /// <param name='serverName'> /// The name of the Azure SQL server. /// </param> /// <param name='databaseName'> /// The name of the Azure SQL database to be operated on (updated or created). /// </param> /// <param name='parameters'> /// The required parameters for creating or updating a database. /// </param> /// <param name='cancellationToken'> /// The cancellation token. /// </param> public static async Task <DatabaseInner> BeginCreateOrUpdateAsync(this IDatabasesOperations operations, string resourceGroupName, string serverName, string databaseName, DatabaseInner parameters, CancellationToken cancellationToken = default(CancellationToken)) { using (var _result = await operations.BeginCreateOrUpdateWithHttpMessagesAsync(resourceGroupName, serverName, databaseName, parameters, null, cancellationToken).ConfigureAwait(false)) { return(_result.Body); } }
/// <summary> /// Creates a new database or updates an existing database. /// </summary> /// <param name='operations'> /// The operations group for this extension method. /// </param> /// <param name='resourceGroupName'> /// The name of the resource group that contains the resource. You can obtain /// this value from the Azure Resource Manager API or the portal. /// </param> /// <param name='serverName'> /// The name of the server. /// </param> /// <param name='databaseName'> /// The name of the database to be operated on (updated or created). /// </param> /// <param name='parameters'> /// The required parameters for creating or updating a database. /// </param> /// <param name='cancellationToken'> /// The cancellation token. /// </param> public static async Task <DatabaseInner> CreateOrUpdateAsync(this IDatabasesOperations operations, string resourceGroupName, string serverName, string databaseName, DatabaseInner parameters, CancellationToken cancellationToken = default(CancellationToken)) { using (var _result = await operations.CreateOrUpdateWithHttpMessagesAsync(resourceGroupName, serverName, databaseName, parameters, SqlManagementClient.SetJsonAcceptHeader(), cancellationToken).ConfigureAwait(false)) { return(_result.Body); } }
///GENMHASH:478F77EE25B1DAD41512D7810F424A78:E1ECD7008D29BB72B20EB2538850BB93 internal SqlWarehouseImpl(string name, DatabaseInner innerObject, ISqlManager manager) : base(name, innerObject, manager) { }