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...
Read tutorial
Browse articles
More programming tutorials
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...
Read tutorial
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 c...
Read tutorial
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...
Read tutorial
REST API Interview Questions for ASP.NET Core Developers
comment
Add Comment
If you're prepping for a .NET backend interview, chances are the panel will spend at least half the conversation on REST API design and ...
Read tutorial
Multi-Select Dropdown with Checkboxes in ASP.NET Web Forms
comment
Add Comment
A standard HTML <select multiple> control lets users choose multiple items, but the interaction is awkward: on Windows, users have to...
Read tutorial
How to Convert a List of Objects to CSV in C# | Step-by-Step Tutorial
comment
Add Comment
In this tutorial, you will learn how to convert a list of objects to a CSV file in ASP.NET MVC , leveraging Entity Framework to fetch data ...
Read tutorial
How to Convert a List to CSV in C# - A Step-by-Step Guide
comment
Add Comment
When working with large datasets in C#, it is often necessary to export the data to a file format that is easy to read and manipulate. One o...
Read tutorial
STUFF Function in SQL Server with Example
comment
Add Comment
SQL Server provides various built-in functions to manipulate and process data efficiently. One such function is the STUFF function, which i...
Read tutorial
How to Convert JSON to DataTable and DataSet in C# and VB.NET
comment
Add Comment
In the world of .NET development, effectively managing and processing JSON data is a key skill for modern developers. Whether you’re working...
Read tutorial
Upload and Read Excel File in WEB API using C#
comment
4 Comments
In this article, I will explain how to upload and read Excel files in excel in web API using c#. I will also explain how to insert the data ...
Read tutorial