SQL Window Functions via Practical Examples

Learn to use SQL window functions, pivot tables and subqueries to calculate sales KPI

Advanced SQL queries via practical examples

As software developer, oftentimes we overlook the importance to write concise and efficient SQL queries. We…

Fake Multiple Inheritance in C#

Learn to use extension methods and interface default implementations to achieve free-risk multiple inheritance look-alike feature

IEnumerable vs IQueryable: Demystify & Dive deep into how query works

Learn about how queries work behind the scene, and the difference between IEnumerable and IQueryable

LAB SERIES #1 : Scaffold entities from database schema in EF Core 3.1

1/ Install packages EF Core tools: Install-Package Microsoft.EntityFrameworkCore.Tools SQL Server data provider for EF Core: Install-Package…

Blockchain is not another database

Blockchain is not invented to be another storage technology. However people often refer blockchain to distributed…

Blockchain in plain English

Misconceptions about blockchain technology are elucidated in a simple language. A simplistic definition of blockchain technology…

Create ASP.NET Core Web API for Ethereum DApps

Another approach to create decentralized application on Ethereum with Restful API as middleware

Write a token-based Ethereum smart contract

Learn to create a smart contract ERC20 compliant. Use contract to crowdfund your startup on blockchain…

ASP.NET Core Web API middle-ware for Ethereum – Settings

This is the first part of the tutorial on creating Aps.Net Core Web API for Ethereum’s…