I’ve participated the Microsoft .NET challenge France 2022 final two months ago on 19 january 2023, 2 years after have participating the Microsoft .NET challenge France 2020 final.
The Microsoft .NET challenge France is co-organized by two companies:
SoftFluent, a French IT consulting company specialized in the Microsoft ecosystem with C#, .NET, Azure, SQL Server etc.
EditX, a Belgian company that hosts a lot of online competitions across Europe.
Change Data Capture (CDC) table uses __$update_mask to track the modifications of ordinal columns.
__$update_mask’s type is varbinary(128)
The function sys.fn_cdc_is_bit_set is provided within Microsoft SQL Server. It is used to calculate if the value of a column is modified, based on the column’s position and the __$update_mask.
It’s not easy to create integration test with database, no matter whether you create queries directly against entity framework’s DbContext or you create your queries with repositary pattern which operate on your DbSets.
You need to always connect to your database to test your use cases with the real data or fake data you have prepared.
The good news is you can use the EF core’s in-memory database provider to tackle it easily.
When you develop a web application in Angular for the front-end and C# or Java in the back-end, it’s frequently that you need to upload and download files.
Here is an example that may inspire you in your development.
Full-text index is different from clustered and non-clustered index in SQL Server.
Clustered and non-clustered index use a B-tree structure.
One table can have only one clustered index. And table data is physically ordered and stored into pages based on the clustered index. Page is the fundamental unit of data storage in SQL Server.
The table data is organized with root node (type: INDEX_PAGE), intermediate nodes (type: INDEX_PAGE) and leaf nodes (type: DATA_PAGE).
You’ll inevitablly write unit tests or integration tests for internal methods and protected methods in your .net project.
Here are some techniques you can use.
To test internal methods in projects developed in .NET Framework, you need add the following code in the AssemblyInfo.cs of the target target, then all its internal methods are visible to the tests project.
I need to generate Excel files in my recent work. The file is not huge and it’s around 5000 lines.
I have tried two open source libraries to generate them.
They are:
OpenXmlSdk
ClosedXml
There is very good library EPPlus which is very popular. It has become a commercial product since the version 5, so a license is required for commercial use. I work for a French bank, and I prefer to use an open source library because of the long purchase procedure in the bank and the cost.
The OpenAPI Initiative (OAI) was created in order to standardize the API design.The OpenAPI Specification (OAS) was originally based on the Swagger Specification, donated by SmartBear Software.
The OpenAPI is programming language agnostic.
You can see the OpenAPI Specification change history here