Notes
C# High-Frequency IoT Logging: Ditching EF for SqlBulkCopy
When MES receives machine IoT telemetry, frequent single inserts choke the DB. Learn to optimize performance using SqlBulkCopy.
MES API Security: JWT + Custom Role Interceptors in .NET Core
Prevent unauthorized access! Sharing a custom attribute-based authorization interceptor scheme commonly used in ASP.NET Core Web APIs.
Generating Excel Templates with Dynamic Dropdowns using C# NPOI
Mass uploading materials is common in MES. Learn how to generate Excel templates with hidden sheets and data validation using NPOI.
Industrial File Uploads: Chunking Large Files with Layui and C#
Workshop CAD drawings and logs can be huge. Standard HTTP POSTs fail easily. Learn to implement chunked uploads and merges.
Hacking Layui Tree: Asynchronous Loading for Million-Node BOMs
Bills of Materials (BOM) go deep. Learn to use Layui Tree with a C# backend to implement lazy loading and prevent browser crashes.
Debugging Diary: Uncovering SQL Server Deadlocks caused by EF Core
Production suddenly crashes? Tracing how deadlocks occur in complex WMS transfer operations and solving them via NOLOCK isolation.
RoLID-11K：The First Large-Scale Dashcam Dataset for Roadside Litter Detection
The First Large-Scale Dashcam Dataset for Roadside Litter Detection。