data access
SQL Server for C# and .NET Articles, Tutorials & News
SQL Server for C# and .NET articles, tutorials, and news from the DotNetNews archive.
208 articles Updated Page 6 of 9
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 6 of 9
Newest first
-
Entity Framework or Dapper: which one is better for .NET/C#?
Medium Issue #270
There’s no right answer. Each of these ORMs has its own strengths. However, to figure out which one is more suitable for you at the moment…
-
-
Indexing Internals for Developers and DBAs
Visual Studio Magazine Issue #270
Microsoft’s Bradley Ball dives into the inner workings of SQL Server indexing to help developers and DBAs speak the same language, avoid common pitfalls, and boost performance with smarter, more inten...
-
SQL Server Features: A Comprehensive Guide for Developers
C# Corner Issue #268
Mastering Advanced SQL Server Features: A Comprehensive Guide for Developers
-
Bulk Inserts in .NET: Fast, Lock-Friendly with SqlBulkCopy
Medium Issue #266
Import millions of records in SQL Server with batching for maximum throughput and minimal locking.
-
Mastering Common Table Expressions (CTEs) in SQL Server
C# Corner Issue #266
This article explains SQL Server Common Table Expressions (CTEs), covering benefits, performance, best practices, and real-world examples, helping developers simplify complex queries, improve readabil...
-
SQL Server CLR Integration: Development, Deployment, Security, Architecture, Patterns, and Real-World Use Cases
C# Corner Issue #266
Explore SQL Server CLR Integration’s power to bridge .NET and relational databases. Learn best practices, security, and real-world use cases to build scalable, secure, high-performance data-driven app...
-
Building an Invoice Entry System with Angular, ASP.NET Core, Dapper, CQRS, and SQL Server
C# Corner Issue #265
Learn how Vibe Coding revolutionizes retail merchandising by replacing static seasonal plans with AI-powered, multi-agent systems that detect trends, align inventory, adjust pricing, and personalize c...
-
Building an ASP.NET GridView with DatePicker Filter and WebMethod Dropdown
C# Corner Issue #262
Learn how to build a dynamic ASP.NET GridView with a DatePicker filter and a dropdown populated using WebMethod from SQL Server using C# and AJAX for real-time filtering.
-
On .NET Live | Supercharge your SQL development with modern .NET
YouTube Issue #262
.NET 8 vs .NET 9: Migration Guide and Best Practices
-
COALESCE vs. ISNULL: Better NULL Handling in .NET Apps
itnext.io Issue #259
Compare COALESCE and ISNULL to write cleaner, portable SQL for your .NET data layers. Continue reading on ITNEXT »
-
Monitor Performance by Using the Query Store
C# Corner Issue #259
Query Store in SQL Server helps monitor query performance over time by storing execution plans, runtime stats, and wait times. It enables troubleshooting, plan forcing, and tracking regressions effect...
-
Supercharged Performance with SQL Partitioning & C#: One Strategy, Multiple Tables
Medium Issue #258
Scenario:
-
On .NET Live | Supercharge your SQL development with modern .NET
YouTube Issue #258
Designing Modular Caching Layers in .NET Applications
-
Announcing General Availability of UNISTR function and ANSI SQL || Operator in Azure SQL
Microsoft Dev Blogs Issue #257
We’re excited to announce the General Availability (GA) of two long-standing capabilities that address critical needs for SQL developers and enterprise customers in Azure SQL Database and Azure SQL Ma...
-
🔴 VS Code Live - Boost Your SQL Development in VS Code: GitHub Copilot, Containers, and More
YouTube Issue #257
How to Outsource ASP.NET Development Successfully: A 2025 Guide
-
Announcing SQLDBEntityNotifier: Effortless Real-Time SQL Server Change Tracking for .NET
Medium Issue #257
I’m excited to announce the release of SQLDBEntityNotifier, a lightweight, event-driven .NET library for SQL Server change tracking…
-
Repeater Control in ASP.NET Web Forms with C#
C# Corner Issue #256
Learn how to use the Repeater control in ASP.NET Web Forms with C# to display IPO data from a SQL Server database. This lightweight, customizable control is ideal for simple, flexible, HTML-driven dat...
-
SQL Best Practices from a .NET Core Developer’s Lens — What I Wish I Knew Earlier
Medium Issue #253
https://medium.com/@sunita.rawat.cgi/sql-best-practices-from-a-net-core-developers-lens-what-i-wish-i-knew-earlier-b954a8b83a41
-
Temp Tables vs CTEs in SQL Server: What You Should Really Know
C# Corner Issue #250
https://www.c-sharpcorner.com/article/temp-tables-vs-ctes-in-sql-server-what-you-should-really-know/
-
Code First vs. Database First: A Pragmatic Guide for Modern Software Engineers
Medium Issue #241
https://medium.com/@MatinGhanbari/code-first-vs-database-first-a-pragmatic-guide-for-modern-software-engineers-29ac04f1daa1
-
🚀 Automating SQL Server Database Backups and Remote Table Sync
C# Corner Issue #241
https://www.c-sharpcorner.com/article/automating-sql-server-database-backups-and-remote-table-sync/
-
Boost SQL Server Performance in .NET: The Hybrid Index Strategy (Part 3)
itnext.io Issue #240
https://itnext.io/boost-sql-server-performance-in-net-the-hybrid-index-strategy-part-3-ebaf40397ed2?source=rss------dotnet-5
-
Why You Must Switch from System.Data.SqlClient to Microsoft.Data.SqlClient Now
Medium Issue #236
https://medium.com/@nagarajvela/why-you-must-switch-from-system-data-sqlclient-to-microsoft-data-sqlclient-now-3d9ba2a8b9c2
-
How Indexed Views Cut SQL Server Dashboard Load Time by 93% (Part 2)
itnext.io Issue #235
https://itnext.io/how-indexed-views-cut-sql-server-dashboard-load-time-by-93-part-2-82a0463ba462