A Programmer with Microsoft tools

Category: TILT

  • TILT–HealthCheck–part 8

    Read about https://docs.microsoft.com/en-us/azure/architecture/patterns/health-endpoint-monitoring In ASP.NET Core it is easy to add health checks to your web application. I have added for Sqlite in the release and for SqlServer in the Azure. This is the code bool IsBuildFromCI = new XAboutMySoftware_78102118871091131225395110108769286().IsInCI; //more code builder.Services .AddHealthChecksUI(setup => { var health = “/healthz”; if (IsBuildFromCI) { health =…

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

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

  • TILT–idea–part 1

    I want to try a new generator from DB with Roslyn – so a new application should come. The name is TILT – Thing I Learned Today. What it does 1. Let you put a TILT  per day ( and this is a tricky point,what is a day …). A TILT can have a subject…

  • Busy with TILT

    Just thinking to a new application –  TILT – Things I Learned Today . It will allow me to verify Database 2 Code – an sample project – and many of Roslyn Source Code Generators. If you want to participate,just let me know. It will be on Azure as most as possible – and with…