SQLite improvements in EF Core 5.0

One of biggest limitations of SQLite database is that it has limited support for changing database schema after it was designed initially. For example, simple dropping of existing column is not possible. The only schema altering commands directly supported by SQLite are the rename table, rename column and add column commands. But altough not supported

Migration from .NET Core 3.1 to .NET 5 and EF Core 5.0 on real life project

In this article I will explain steps needed to upgrade project to .NET 5, EF Core 5.0 and C# 9.0 on real life project. First thing needed is Visual Studio 16.8. I will not work in earlier versions of VS. Next, download .NET 5 SDK and Runtime from https://dotnet.microsoft.com/download/dotnet/5.0. Once you open your projects inside

.NET tool to see installed .NET core version and .NET tool to see outdated project dependencies: dotnet-runtimeinfo and dotnet-outdated

If you want to quickly see version of .net installed there is dotnet --version command. However, if you want to see more detailed information including exact version of operating system and OS arhitecture there is dotnet-runtime info tool. https://www.nuget.org/packages/dotnet-runtimeinfo/ You can install it by running dotnet tool install --global dotnet-runtimeinfo. You can now run it

Authentication and authorization using Microsoft identity platform in Blazor web app

First thing you will need to do is go to https://portal.azure.com/#allservices and under services choose App registration and register new app. Once you create it application (client) ID and Directory(tenant) ID will be generated for you. You will need to add section like this to your app.settings file: "AzureAd": { "Instance": "https://login.microsoftonline.com/", "Domain": "yourdomain.com", "TenantId":
how to create nuget package

Creating nuget package

First step to create nuget package is to create .nuspecĀ  file. If you are familiar with npm then it is even easier for you because I will make comparison with npm along the way. In npm you would do npm initĀ to create package.json file, and it will walk you through some settings you will need