- ToDo: Rename this console app to SqlServerCodeGen
- .Net 8 console app
- uses
secrets.jsonto hold azure credentials - uses the older style of
private static void Main(string[] args) - `Azure.Storage.Blobs`` to interact with the Azure
- uses
Microsoft.Extensions.ConfigurationandConfigurationBuilderto pull insecrets.jsonwhich enables the json elements to be extracted
var config = new ConfigurationBuilder()
.AddUserSecrets<Program>()
.Build(); string blobConnectionString = $"{config["Blob:ConnectionString"]}";
string blobContainer = $"{config["Blob:Container"]}";
BlobServiceClient blobServiceClient = new BlobServiceClient(blobConnectionString);
BlobContainerClient containerClient = blobServiceClient.GetBlobContainerClient(blobContainer);The purpose of the console app is to loop through a container and output to the console Sql Server UPDATE statements
List<string> blobNamesList = containerClient.GetBlobs().Select(b => b.Name).ToList();
foreach (string item in blobNamesList)
{
Console.WriteLine($"UPDATE WeeklyVideo SET GraphicFile='{item}' WHERE WeeklyVideoTypeId=1 AND ShabbatWeekId={item.Substring(0, 3).TrimStart('0')}");
}
- [Console Templates](https://aka.ms/new-console-template for more information)
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent