private void SetConnectionString(string connectionString, string serviceType)
{
ConnectionStringType type;
switch (serviceType)
{
case "SQLServer":
type = ConnectionStringType.SQLServer;
break;
case "MySQL":
type = ConnectionStringType.MySql;
break;
default:
type = ConnectionStringType.Custom;
break;
}
var _connectionString = new ConnectionStringDictionary
{
Properties = new Dictionary <string, ConnStringValueTypePair>
{
{ "Cupertino_" + _appName, new ConnStringValueTypePair {
Value = connectionString, Type = type
} }
}
};
_client.WebApps.UpdateConnectionStrings(_rgName, _appName, _connectionString);
}
public static ConnectionStringDictionary UpdateSiteConnectionStrings(this IWebAppsOperations webApp,
string resourceGroupName,
string name,
ConnectionStringDictionary connectionStrings)
{
return(webApp.UpdateConnectionStrings(resourceGroupName, name, connectionStrings));
}
protected override IConnectionProvider GetConnectionProvider()
{
IDictionary conProviderDict = ConnectionStringDictionary.Parse(ConnectionString);
string provider = (string)conProviderDict["Provider"];
if (provider == null)
{
provider = "SQLCLIENT";
}
return(GetConnectionProvider("Mainsoft.Data.Configuration/SqlClientProviders", provider));
}
private bool CheckConnectionString(string connectionString)
{
ConnectionStringDictionary connectionStrings = _client.WebApps.ListConnectionStrings(_rgName, _appName);
foreach (var item in connectionStrings.Properties)
{
if (item.Value.Value.Equals(connectionString))
{
return(true);
}
}
return(false);
}
public static async Task UpdateConnectionStringsAsync(this IWebAppsOperations operations, TargetSite targetSite,
ConnectionStringDictionary connectionStringDictionary, CancellationToken cancellationToken = default)
{
if (targetSite.HasSlot)
{
await operations.UpdateConnectionStringsSlotWithHttpMessagesAsync(targetSite.ResourceGroupName,
targetSite.Site, connectionStringDictionary, targetSite.Slot, cancellationToken : cancellationToken);
}
else
{
await operations.UpdateConnectionStringsWithHttpMessagesAsync(targetSite.ResourceGroupName,
targetSite.Site, connectionStringDictionary, cancellationToken : cancellationToken);
}
}
protected override IConnectionProvider GetConnectionProvider()
{
IDictionary conProviderDict = ConnectionStringDictionary.Parse(ConnectionString);
string jdbcUrl = (string)conProviderDict["JdbcUrl"];
if (jdbcUrl == null)
{
string provider = (string)conProviderDict["Provider"];
if (provider != null)
{
return(GetConnectionProvider("Mainsoft.Data.Configuration/OleDbProviders", provider));
}
}
return(new GenericProvider(conProviderDict));
}
static async Task CreateSite(string rgName, string appServicePlanName, string siteName, string location)
{
// Create/Update the resource group
var rgCreateResult = await _resourceGroupClient.ResourceGroups.CreateOrUpdateAsync(rgName, new ResourceGroup { Location = location });
// Create/Update the App Service Plan
var serverFarmWithRichSku = new ServerFarmWithRichSku
{
Location = location,
Sku = new SkuDescription
{
Name = "F1",
Tier = "Free"
}
};
serverFarmWithRichSku = await _websiteClient.ServerFarms.CreateOrUpdateServerFarmAsync(rgName, appServicePlanName, serverFarmWithRichSku);
// Create/Update the Website
var site = new Site
{
Location = location,
ServerFarmId = appServicePlanName
};
site = await _websiteClient.Sites.CreateOrUpdateSiteAsync(rgName, siteName, site);
// Create/Update the Website configuration
var siteConfig = new SiteConfig
{
Location = location,
PhpVersion = "5.6"
};
siteConfig = await _websiteClient.Sites.CreateOrUpdateSiteConfigAsync(rgName, siteName, siteConfig);
// Create/Update some App Settings
var appSettings = new StringDictionary
{
Location = location,
Properties = new Dictionary<string, string>
{
{ "MyFirstKey", "My first value" },
{ "MySecondKey", "My second value" }
}
};
await _websiteClient.Sites.UpdateSiteAppSettingsAsync(rgName, siteName, appSettings);
// Create/Update some Connection Strings
var connStrings = new ConnectionStringDictionary
{
Location = location,
Properties = new Dictionary<string, ConnStringValueTypePair>
{
{ "MyFirstConnString", new ConnStringValueTypePair { Value = "My SQL conn string", Type = DatabaseServerType.SQLAzure }},
{ "MySecondConnString", new ConnStringValueTypePair { Value = "My custom conn string", Type = DatabaseServerType.Custom }}
}
};
await _websiteClient.Sites.UpdateSiteConnectionStringsAsync(rgName, siteName, connStrings);
}
public async Task Setup()
{
var resourceManagementEndpointBaseUri =
Environment.GetEnvironmentVariable(AccountVariables.ResourceManagementEndPoint) ??
DefaultVariables.ResourceManagementEndpoint;
var activeDirectoryEndpointBaseUri =
Environment.GetEnvironmentVariable(AccountVariables.ActiveDirectoryEndPoint) ??
DefaultVariables.ActiveDirectoryEndpoint;
resourceGroupName = Guid.NewGuid().ToString();
clientId = ExternalVariables.Get(ExternalVariable.AzureSubscriptionClientId);
clientSecret = ExternalVariables.Get(ExternalVariable.AzureSubscriptionPassword);
tenantId = ExternalVariables.Get(ExternalVariable.AzureSubscriptionTenantId);
subscriptionId = ExternalVariables.Get(ExternalVariable.AzureSubscriptionId);
var resourceGroupLocation = Environment.GetEnvironmentVariable("AZURE_NEW_RESOURCE_REGION") ?? "eastus";
authToken = await Auth.GetAuthTokenAsync(activeDirectoryEndpointBaseUri,
resourceManagementEndpointBaseUri, tenantId, clientId, clientSecret);
var resourcesClient = new ResourcesManagementClient(subscriptionId,
new ClientSecretCredential(tenantId, clientId, clientSecret));
resourceGroupClient = resourcesClient.ResourceGroups;
var resourceGroup = new ResourceGroup(resourceGroupLocation);
resourceGroup = await resourceGroupClient.CreateOrUpdateAsync(resourceGroupName, resourceGroup);
webMgmtClient = new WebSiteManagementClient(new TokenCredentials(authToken))
{
SubscriptionId = subscriptionId,
HttpClient = { BaseAddress = new Uri(DefaultVariables.ResourceManagementEndpoint) },
};
var svcPlan = await webMgmtClient.AppServicePlans.BeginCreateOrUpdateAsync(resourceGroup.Name, resourceGroup.Name,
new AppServicePlan(resourceGroup.Location));
site = await webMgmtClient.WebApps.BeginCreateOrUpdateAsync(resourceGroup.Name, resourceGroup.Name,
new Site(resourceGroup.Location) { ServerFarmId = svcPlan.Id });
existingSettings = new StringDictionary
{
Properties = new Dictionary <string, string> {
{ "ExistingSetting", "Foo" }, { "ReplaceSetting", "Foo" }
}
};
existingConnectionStrings = new ConnectionStringDictionary
{
Properties = new Dictionary <string, ConnStringValueTypePair>
{
{
"ExistingConnectionString",
new ConnStringValueTypePair("ConnectionStringValue", ConnectionStringType.SQLAzure)
},
{
"ReplaceConnectionString",
new ConnStringValueTypePair("originalConnectionStringValue", ConnectionStringType.Custom)
}
}
};
await webMgmtClient.WebApps.UpdateConnectionStringsAsync(resourceGroupName, site.Name, existingConnectionStrings);
webappName = site.Name;
}
static async Task CreateSite(string rgName, string appServicePlanName, string siteName, string location)
{
// Create/Update the resource group
var rgCreateResult = await _resourceGroupClient.ResourceGroups.CreateOrUpdateAsync(rgName, new ResourceGroup { Location = location });
// Create/Update the App Service Plan
var serverFarmWithRichSku = new ServerFarmWithRichSku
{
Location = location,
Sku = new SkuDescription
{
Name = "F1",
Tier = "Free"
}
};
serverFarmWithRichSku = await _websiteClient.ServerFarms.CreateOrUpdateServerFarmAsync(rgName, appServicePlanName, serverFarmWithRichSku);
// Create/Update the Website
var site = new Site
{
Location = location,
ServerFarmId = appServicePlanName
};
site = await _websiteClient.Sites.CreateOrUpdateSiteAsync(rgName, siteName, site);
Console.WriteLine($"Site outbound IP addresses: {site.OutboundIpAddresses}");
// Create/Update the Website configuration
var siteConfig = new SiteConfig
{
Location = location,
PhpVersion = "5.6"
};
siteConfig = await _websiteClient.Sites.CreateOrUpdateSiteConfigAsync(rgName, siteName, siteConfig);
// Create/Update some App Settings
var appSettings = new StringDictionary
{
Location = location,
Properties = new Dictionary <string, string>
{
{ "MyFirstKey", "My first value" },
{ "MySecondKey", "My second value" }
}
};
await _websiteClient.Sites.UpdateSiteAppSettingsAsync(rgName, siteName, appSettings);
// Create/Update some Connection Strings
var connStrings = new ConnectionStringDictionary
{
Location = location,
Properties = new Dictionary <string, ConnStringValueTypePair>
{
{ "MyFirstConnString", new ConnStringValueTypePair {
Value = "My SQL conn string", Type = DatabaseServerType.SQLAzure
} },
{ "MySecondConnString", new ConnStringValueTypePair {
Value = "My custom conn string", Type = DatabaseServerType.Custom
} }
}
};
await _websiteClient.Sites.UpdateSiteConnectionStringsAsync(rgName, siteName, connStrings);
// List the site quotas
Console.WriteLine("Site quotas:");
CsmUsageQuotaCollection quotas = await _websiteClient.Sites.GetSiteUsagesAsync(rgName, siteName);
foreach (var quota in quotas.Value)
{
Console.WriteLine($" {quota.Name.Value}: {quota.CurrentValue} {quota.Unit}");
}
// Get the publishing profile xml file
using (var stream = await _websiteClient.Sites.ListSitePublishingProfileXmlAsync(rgName, siteName, new CsmPublishingProfileOptions()))
{
string profileXml = await(new StreamReader(stream)).ReadToEndAsync();
Console.WriteLine(profileXml);
}
// Restart the site
await _websiteClient.Sites.RestartSiteAsync(rgName, siteName, softRestart : true);
}
static async Task CreateSite(string rgName, string appServicePlanName, string siteName, string location)
{
// Create/Update the resource group
var rgCreateResult = await _resourceGroupClient.ResourceGroups.CreateOrUpdateAsync(rgName, new ResourceGroup { Location = location });
// Create/Update the App Service Plan
var serverFarmWithRichSku = new ServerFarmWithRichSku
{
Location = location,
Sku = new SkuDescription
{
Name = "F1",
Tier = "Free"
}
};
serverFarmWithRichSku = await _websiteClient.ServerFarms.CreateOrUpdateServerFarmAsync(rgName, appServicePlanName, serverFarmWithRichSku);
// Create/Update the Website
var site = new Site
{
Location = location,
ServerFarmId = appServicePlanName
};
site = await _websiteClient.Sites.CreateOrUpdateSiteAsync(rgName, siteName, site);
// Create/Update the Website configuration
var siteConfig = new SiteConfig
{
Location = location,
PhpVersion = "5.6"
};
siteConfig = await _websiteClient.Sites.CreateOrUpdateSiteConfigAsync(rgName, siteName, siteConfig);
// Create/Update some App Settings
var appSettings = new StringDictionary
{
Location = location,
Properties = new Dictionary <string, string>
{
{ "MyFirstKey", "My first value" },
{ "MySecondKey", "My second value" }
}
};
await _websiteClient.Sites.UpdateSiteAppSettingsAsync(rgName, siteName, appSettings);
// Create/Update some Connection Strings
var connStrings = new ConnectionStringDictionary
{
Location = location,
Properties = new Dictionary <string, ConnStringValueTypePair>
{
{ "MyFirstConnString", new ConnStringValueTypePair {
Value = "My SQL conn string", Type = DatabaseServerType.SQLAzure
} },
{ "MySecondConnString", new ConnStringValueTypePair {
Value = "My custom conn string", Type = DatabaseServerType.Custom
} }
}
};
await _websiteClient.Sites.UpdateSiteConnectionStringsAsync(rgName, siteName, connStrings);
}
static async Task CreateSite(string rgName, string appServicePlanName, string siteName, string location)
{
// Create/Update the resource group
var rgCreateResult = await _resourceGroupClient.ResourceGroups.CreateOrUpdateAsync(rgName, new ResourceGroup { Location = location });
// Create/Update the App Service Plan
var serverFarmWithRichSku = new ServerFarmWithRichSku
{
Location = location,
Sku = new SkuDescription
{
Name = "F1",
Tier = "Free"
}
};
serverFarmWithRichSku = await _websiteClient.ServerFarms.CreateOrUpdateServerFarmAsync(rgName, appServicePlanName, serverFarmWithRichSku);
// Create/Update the Website
var site = new Site
{
Location = location,
ServerFarmId = appServicePlanName
};
site = await _websiteClient.Sites.CreateOrUpdateSiteAsync(rgName, siteName, site);
// Create/Update the Website configuration
var siteConfig = new SiteConfig
{
Location = location,
PhpVersion = "5.6"
};
siteConfig = await _websiteClient.Sites.CreateOrUpdateSiteConfigAsync(rgName, siteName, siteConfig);
// Create/Update some App Settings
var appSettings = new StringDictionary
{
Location = location,
Properties = new Dictionary<string, string>
{
{ "MyFirstKey", "My first value" },
{ "MySecondKey", "My second value" }
}
};
await _websiteClient.Sites.UpdateSiteAppSettingsAsync(rgName, siteName, appSettings);
// Create/Update some Connection Strings
var connStrings = new ConnectionStringDictionary
{
Location = location,
Properties = new Dictionary<string, ConnStringValueTypePair>
{
{ "MyFirstConnString", new ConnStringValueTypePair { Value = "My SQL conn string", Type = DatabaseServerType.SQLAzure }},
{ "MySecondConnString", new ConnStringValueTypePair { Value = "My custom conn string", Type = DatabaseServerType.Custom }}
}
};
await _websiteClient.Sites.UpdateSiteConnectionStringsAsync(rgName, siteName, connStrings);
// List the site quotas
Console.WriteLine("Site quotas:");
CsmUsageQuotaCollection quotas = await _websiteClient.Sites.GetSiteUsagesAsync(rgName, siteName);
foreach (var quota in quotas.Value)
{
Console.WriteLine($" {quota.Name.Value}: {quota.CurrentValue} {quota.Unit}");
}
// Restart the site
await _websiteClient.Sites.RestartSiteAsync(rgName, siteName, softRestart: true);
}
