06 Oct 2020, SUN Jiangong
I’ve looked for some complete solution to download an EXCEL file from an ASP.NET Web API in Angular 9 application, but I didn’t find it.
As I’ve done it recently, I would like to share my implementation with you if it helps.
More …
05 Oct 2020, SUN Jiangong
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:
More …
21 Sep 2020, SUN Jiangong
Github-pages is very practical to host static websites, not only Jekyll based websites, but also Angular, React based static websites etc.
You don’t need to purchase a space for the websites hosting. It’s totally free! All you need is just a GitHub account. :)
More …
12 Jun 2020, SUN Jiangong
In software development, there are at least several environments to manage: development (DEV), staging (STAG or PRE), and production (PRD).
There will be integration (INT), user acceptance testing (UAT) in a more complete environment configuration.
It could be frustrating when managing all those environments because a small error in the deployment could generate an incident, or disaster!
Fortunately there is a cool tool to facilitate the environment management and software deployment in visual studio.
More …
08 Jun 2020, SUN Jiangong
Unlike ASP.NET CORE Web API, ASP.NET MVC Web API’s will not serialize the output in camelCase.
camelCase example:
PascalCase example:
More …
28 May 2020, SUN Jiangong
When you implement an ASP.NET CORE Web API, you may want the API to support all clients from anywhere and enable credentials at the same time.
You need to make the CORS (Cross Origin Resource Sharing) configuration in your Web API.
More …
01 May 2020, SUN Jiangong
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
More …
21 Apr 2020, SUN Jiangong
Leonard Richardson has defined a Model to determine an REST API maturity, called Richardson Maturity Model.
There are 4 levels of maturity.

More …
30 Mar 2020, SUN Jiangong
If you have used Entity Framework, you have probably known that there are 3 possible approaches to work with the database:
Database First is the most common practice when working an existing database.
In this case, an .EDMX (Entity Data Model XML) file will be generated when you map the database in your project. And it contains all the data models.
With Model First approach, you start by creating .EDMX file with models in the designer, then you generate the database from the .EDMX file.
With Code First approach, you create the data models firstly, and then generate or update the database with incremental migrations.
You have refined control on the details of data models, like the column constraints(max/min length), relationships etc.
And with the migration history, you can easily move forward or rollback your database version while ensuring the data model consistency.
More …
28 Mar 2020, SUN Jiangong
I’ve met this error when I check the version of SQL Server LocalDb in my machine.
>sqllocaldb.exe versions
Error:

More …