Temporal Table was added in SQL SERVER 2016. The primary feature of temporal table is to record a table’s history data. Temporal table will record every data that is added, updated or deleted in a table in any movement. The new version of EntityFramework Core also has some Temporal Table functions. Temporal Table primary has […]
Creating a branch in GitHub 1. On GitHub, navigate the main menu icon in the repository and click View all branches in the main drop-down menu. 2. After clicking View all branches in the drop-down menu，you will navigate to the new page. You then click New branch which is shown on the right top side
Creating and Restoring deleted branches in GitHub Read More »
When I tried to create a new table in SQL Server Management Studio (SSMS) 2014, I encountered the following error: I checked the SQL Server version using the select @@version command. I found out that it was 2019, which is different from the SSMS 2014. The error message appeared because the SQL Server version and
The backend version is not supported to design database Read More »
This is because .NET Core pre-set to using HTTPS protocol. If the certificate is not installed, this error will be reported. To resolve this issue, execute the following dotnet command. dotnet dev-certs https –trust When executing the dotnet command shown above, you might encounter the following error The current version of .Net I used in
When a programmer writes code, he or she doesn’t want to have every specific custom data and settings in the code. Instead, they want to have those written in a configuration file. This article will introduce how to set an object list in .Net Framework App.config and .Net Core Appsetting.json respectively and also how to
Extract List or Array data from .NET Framework AppConfig or .NET Core AppSetting file Read More »
WCF offers HTTP Service. Prior to Web API, we could use WCF(Windows Communication Foundation) to construct HTTP Service. WCF supports both REST and RPC Web Service model. There are still many programs used legacy WCF services to execute web service. When we tried to shift from Visual Studio 2015 or Visual Studio 2017 to the
How to activate WCF Service in Visual Studio 2022 Read More »
Steps 1. Before deploying angular app to IIS, don’t forget to download IIS URL Rewrite module. This will solve Angular app’s route problems. 2. When you deploy angular app to IIS server, type the command below in cmd console ng build –base-href “/AngularTest/” –prod(you can use any other name other than AngularTest). If the command
SQL SERVER has GENERATE SCRIPT command can export vendor’s database schema and data to the client’s SQL SERVER. Besides, GENERATE SCRIPT also provides various customized options. For example, you can check whether the client’s SQL Server already has the same schema table compared to the vendor’s. You can also choose whether you just want to
After .net 5 came up, a new C# 9 mechanism called Record has drawn C# developer much attention. Record has both Reference Type and Value Type features. It is used to store data like struct, however as it is Reference Type, it has behaviors like encapsulate and inheritance. Hence we can use record to store
Registry is windows built-in hierarchical database which stores computer system information. We can modify or insert registry value by hand-on or through programming language. For example in C#, we can use Microsoft.Win32.Registry to set Registry’s key and value,. However, sometimes we cannot Set Registry’s key and value perhaps due to permission problem. Another reason is
Can’t Set Registry Key and Value, Want a solution? Read More »