A Programmer with Microsoft tools

  • 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–CRUD API–part 5

    It is true that usually you should not create CRUD API. In this case I was thinking that is faster just to have those already created and making the application later. More,the CRUD was created automatically – sgtarting from database. Install the generator https://marketplace.visualstudio.com/items?itemName=ignatandrei.databasetocode in VS2022,create a new solution and then edit the connectionDetails.txt with…

  • Friday links 486

    Gateway How We Design Our APIs at Slack – Slack Engineering The Ultimate,Free Incident Retrospective Template | Blameless Latency based SLO | Last9 SRE Platform The Programming Interview from Hell 15 Developer Portfolios to Inspire You – DEV Community Open sourcing the .NET 5 C# Language Extension for SQL Server – Microsoft SQL Server Blog…

  • TILT- tables–part 4

    I will keep very simple the database schema. I do not want for the moment an users table,so I just create a table with url a table with the tags a table with notes Azure Data Studio Trying Azure Data Studio – good point that it is integrated with Azure. Bad point – finding it…

  • 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…

  • TILT–specifications –part 2

    This is an application to store what I have learned today / each day . It will be one note string per day,note will be no more than 140 characters. It has tags – programming,life,and so on. Can add one link to the note. Can be saved on local ( desktop,mobile )or on cloud (…

  • Friday links 485

    (10) Kate Lister on Twitter: “How old were you when you realised your original plan of being really nice,working really hard,& taking on much more than you should in the hope you would be automatically rewarded for this without asking,was totally shit?” / Twitter The end of open source? | TechCrunch WiFi Card bndw/wifi-card: Print…

  • NetCoreUsefullEndpoints-4 Nuget package

    or NugetPackages there is a simple .NET Pack CLI command  and many configurations However,it is not so simple . See https://docs.microsoft.com/en-us/nuget/create-packages/package-authoring-best-practices . In practice,I have a readme.md file ( for showing on nuget.org ) and a readme.txt file( for the programmer to show help after installing the package) THis is what I have in the…

  • NetCoreUsefullEndpoints-3 CICD

    Now I find usefull that,every time that I push some code,the code is build and the nuget package is attached . So GitHub Actions to the rescue. There will be 2 GitHub actions – one for build and package,other for deploying to the Azure a test application This is the code for building. ( The…

I am ok , you are ok

Do nothing