Convert List to CSV in C# With Example
comment
Add Comment
Converting a list to a CSV file in C# is a common requirement in software development, especially when exporting data for reports or da...
Structured Logging Architecture with Serilog in ASP.NET Core
comment
Add Comment
Most ASP.NET Core projects start their logging story the same way: someone adds Serilog, wires up a console sink and a file sink, and c...
Temp Table vs Table Variable vs CTE in SQL Server
comment
Add Comment
Every T-SQL developer hits this fork in the road eventually: you need to stash some intermediate result set inside a stored procedure, ...
SQL Server PIVOT and UNPIVOT: Dynamic SQL Case Study
comment
Add Comment
The short answer: PIVOT turns row values into columns for reporting (row-to-column transformation), and UNPIVOT does the reverse, turning c...
How to Secure an ASP.NET Core Deployment on Linux (Nginx & Systemd)
comment
Add Comment
If you want to secure a .NET Core deployment on Linux, the short answer is this: never expose Kestrel directly to the internet, put a r...
Secure ASP.NET Core Web API JWT Authentication
comment
Add Comment
If you've already wired up JWT bearer authentication in an ASP.NET Core Web API, you've solved maybe a third of the actual security ...
EF Core Query Performance: AsNoTracking, Loading & N+1
comment
Add Comment
Most EF Core performance problems don't announce themselves. You write clean LINQ, the app works fine locally against a small seed datab...
T-SQL WHERE Clause FAQ: NULLs, Errors & Performance
comment
Add Comment
The short answer to most WHERE clause confusion in T-SQL (Transact-SQL, Microsoft's SQL dialect for SQL Server) comes down to one t...
How to Export a DataTable to CSV in C# and VB.NET (Escaping, UTF-8, Streaming)
comment
3 Comments
If you need to export a DataTable to a CSV file in C# or VB.NET, the tricky part isn't writing the rows — it's escaping the values ...
N+1 Query Problem in ASP.NET Core & EF Core: How to Fix It
comment
Add Comment
If your ASP.NET Core API feels slow under real traffic even though every individual query looks fine in isolation, there's a good chance...