Articles & tutorials
Weekly digest: the best articles, once a week, no spam.
Articles tagged #ADO.NET
4 article(s)
-
Export SQL Data to Excel in C# Without Office Interop (ClosedXML)
Export SQL Server data to Excel in C# with ClosedXML instead of Office Interop: no Office install, safe on servers and containers, with a Web API download.
@llaxmikant · Mar 21, 2026 -
Bulk Upload into SQL Server using SqlBulkCopy and C#
Load 100,000 rows in under a second with SqlBulkCopy: column mappings, batch sizes, transactions, staging tables, and the constraint fine print — measured for real.
@llaxmikant · Feb 28, 2026 -
Compare DataTables with LINQ: Except, Intersect and Union
To compare two ADO.NET DataTable objects, call AsEnumerable() on each to get a sequence of DataRow, then apply LINQ set operators: Except gives rows in the…
@llaxmikant · Jan 1, 2026 -
C# DataTable to CSV, List or JSON: Convert and Export in .NET
Convert or export a C# DataTable to CSV, a typed List<T> or a JSON string with three reusable extension methods that handle commas, quotes and DBNull.
@llaxmikant · Nov 19, 2025