For multiple criteria conditions

Photo from:
create procedure [dbo].[Usp_Read_Country_Code_Mapping]
@Codes varchar(max) = null…

Preprocessing in the earlier stage

public class TestResultInBound {
[JsonProperty ("supplier_code")]
public string SupplierCode { get; set; }
[JsonProperty ("supplier_name")]
public string SupplierName { get; set; }
[JsonProperty ("commodity_name")]
public string CommodityName { get; set; }
[JsonProperty ("site")]
public string Site { get; set; }
public string Unit { get; set; }
[JsonProperty ("test_value")]
public string TestValue { get; set; }
[JsonProperty ("test_result")]
public string TestResult { get; set; }

Not just compared equality but the difference parts

// SomeClass.cs
public class SomeClass{
public string PropertyName1 {get; set;}
// ...

public override bool Equals(object obj){
var other = obj as SomeClass;
if (other == null){
return false;
if(PropertyName1 != other.PropertyName1){
return false;
return true;
}// in some function or block
var class1 = new SomeClass {PropertyName1 = "Name1"};
var class2 = new SomeClass {PropertyName1 = "Name2"};
// should return false
var requal = class1.Equals(class2)…


Photo from:

BizTalk — take EDI 850 (X12_00401) N1 looing section as example

Photo from:
1. Receiving EDI850 (source in)
2. BizTalk mapping and processing
3. Store into database table (target)
4. ERP processing
5. Others...

Photo from:

Take ASP.NET Core 3.1 as an example

Photo from:
using Microsoft.AspNetCore.Http.Features;public class EventHub : Hub<IEventHub> {
public override Task OnConnectedAsync () {
var feature = Context.Features.Get<IHttpConnectionFeature>(); // here you could get your…

Using EPPlus package for exporting excel document(s)

Photo from:


public class Customer
public string ID{ get; set; }
public string Sex { get; set; }
public string Phone { get; set; }
public string Address { get; set; }
public DateTime CreateDate { get; set; }

.NET CORE Console Application

Photo from:
public static class Program
public static void Main(string[] args)
{Path_Of_Your_App}\AppName arg1 arg2
public static class Program
public static void Main(string[] args)
Console.WriteLine($"arg1 = {args[0]}");
Console.WriteLine($"arg2 …


Coding for fun

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store