There is a small requirement in the project. C# 3 regular expressions match SQL table names. The table name involved in the SQL executed by the data access layer needs to be extracted through C# code, which is used to record some log-related content, because it is an older project. The data access layer is completely written by ado.net, and does not use advanced ORMs such as ef core to assist with persistence.
CPU 100% .NET performance analysis of HIS system, This is a case of performing performance analysis using the his system developed by .net in a production environment when the CPU is 100%. The post shows how to use windbg to find the performance bottleneck of the .net program. The original source is a post from cnblogs. If you can read Chinese, you can find its link at the bottom of the article.
If you are a C# developer and apply asp.net core to your project, do you know how ASP.NET Core reads Request.Body? When we use ASP.NET Core to develop projects, we will definitely involve the scene of reading Request.Body, because most POST requests store data in the Http Body. The main thing I use in my daily development is ASP.NET Core, so I often encounter this kind of scene. This post is to share the reading problem of Request.Body.
10+ SQL Server commonly used scripts, In the development environment, we can perform arbitrary operations on the database. Once the project is completed and is about to go online, we may perform some deletion operations on the database, such as deleting all stored procedures, all views, backups, restores, etc.