A Programmer with Microsoft tools

Category: azure

  • TILT- ConnectionSecrets in Azure–part 7

    There is relatively easy to use – just go to your web app in Azure,Configuration,ConnectionStrings and add your data. This tutorial is based on the following article: https://docs.microsoft.com/en-us/azure/app-service/tutorial-dotnetcore-sqldb-app The .NET Core code is simple: services.AddDbContext<MyDatabaseContext>(options =>         options.UseSqlServer(Configuration.GetConnectionString(“AZURE_SQL_CONNECTIONSTRING”))); Tools used: https://portal.azure.com/

  • TILT–CI and CD–part 6

    Because the Source Control is Github and has Actions when submitting the code,I use this. Also,when creating an Azure WebSite,you can integrate with Github and he will add the yaml for you and the secrets to deploy I have added also badge to see the result of the action in the readme file. For the…

  • TILT- database–part 3

    The Azure options for creating a database are enough to stay to think about: I will create an Azure Sql Database – now more options To choose one should evaluate deeply https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison And if you want to evaluate the cost,here are some prices: https://azure.microsoft.com/en-us/pricing/details/azure-sql-managed-instance/single/ I will go with Sql Managed instances When creating,the admin password…

  • FileExtension–part 6 – CI/CD

    So now how to make visible all those coding ? For tests –CodeCov,  https://app.codecov.io/gh/ignatandrei/FileExtension hosts for free to see the coverage For documentation – ReadTheDocs,  https://fileextension.readthedocs.io/en/latest/ hosts for free. For packaging  – NuGEt https://www.nuget.org/packages/FileExtension/ For more detailed analysis Sonar https://sonarcloud.io/summary/overall?id=ignatandrei_FileExtension can show code smells and bugs and more GitHub actions https://github.com/ignatandrei/FileExtension/actions allows me to run all those…

  • Exchange rates–what I have done in 37 hours–part 38

    What I have create for now in 37 hours : A source control – https://github.com/ignatandrei/InfoValutar A plugin based software – you can use to load any kind of exchange rates,for anywhere,provided that you implement the interface – see implementation Tests for some of the code Deployment: An Azure WebAPP  WebAPI deployment  – https://infovalutar.azurewebsites.net/swagger/index.html A Docker…

  • Azure functions – final–part 37

    So,I said,now just retrieve data – and put on database: try             {                 log.Info(“trying to save”);                 ISave save = new SaveSqlServer(null);                 await save.Save(data.ToArray());             }             catch(Exception ex)             {                 log.Error($”ERROR !! {ex.Message}”);             } This gives me a new whole error: ERROR !! Could not load type ‘System.IAsyncDisposable’ from assembly ‘netstandard,Version=2.1.0.0,Culture=neutral,PublicKeyToken=cc7b13ffcd2ddd51’. Ok. Coming from start: What I want ?…

  • Azure function–solving my own code problems–part 35

    1. My fault – the plugins does not exists in output this should be added to the output in order to the plugins to be copied to the output directory <ItemGroup> <None Remove=”plugins\” /> <Content Include=”plugins\**\*.dll” CopyToOutputDirectory=”Always” /> </ItemGroup> 2. Deploying,I should see what it is convenient: context.FunctionDirectory  OR context.FunctionAppDirectory log.LogInformation($”!!! C# Timer trigger function…

  • Loading data regularly–deploy plugins–Azure Function–part 34

    Now I have broken the build. Why ?Because of the docker file – to be optimized on local,I copy ecah csproj one by one and the I do dotnet restore. (If docker had a glob patttern! ) . So each time that I put a new project,the build will fail! Trying now from the Azure…

  • Loading data at regular intervals–Azure function –part 33

    I need to load data at scheduled intervals – it is normal that the exchange rates are published every day. So what options we have in Azure? WebJobs Worker Roles Azure functions After reading a lot,I decide on Azure Functions – it is the new kid on the block and battle tested. More,it has something…

  • Refactoring,AzureConnectionString,rss,asmx–part 28

    Now,I want to see that I can read from the database the exchange rates. For this,in Azure WebAPP I go to Settings => Configuration and add my connection string. But now I have a problem: I must read from the configuration.  So back on DI with InMemory class – I inject from ASP.NET Core the…