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 2 of 9
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 2 of 9
Newest first
-
Filtering EF Core by a Large List: The 2,100 Parameter Wall
codewithmukesh Issue #540
EF Core 10 changed how Contains sends a list to SQL Server. Here is the real parameter ceiling, what happens when you cross it, and benchmarks for every fix.
-
SQL Decomposition in a Nutshell
Microsoft Dev Blogs Issue #538
Application developers already know what happens when one method does everything: it becomes difficult to read, test, reason over, and safely change. We use patterns like decomposition, encapsulation,...
-
Microsoft.Data.SqlClient Retry Logic: Building Resilient .NET SQL Server Applications
C# Corner Issue #535
Learn how to use Microsoft.Data.SqlClient retry logic in .NET to handle transient SQL Server connection failures, improve application resilience, and build reliable database applications.
-
Try the new SqlClient and Retry connections natively
Microsoft Dev Blogs Issue #534
The 2002 release of the original .NET Framework shipped ADO.NET and System.Data.SqlClient, the driver for SQL Server that gave .NET applications a standard connection approach. Over the years, updates...
-
Beware of ValueGeneratedOnAdd when using EF
Josef Ottosson Issue #531
How a self-generated GUID had EF marking my brand-new claims as Modified instead of Added, and the one line of config that fixed it.
-
Build Modern and AI-Ready Apps with SQL and GitHub Copilot in VS Code
YouTube Issue #530
Learn how to go from local development to cloud deployment with a fully functional, AI-ready application powered by SQL Server. In this session, you’ll see how GitHub Copilot in VS Code streamlines da...
-
SQL and AI for Developers in Action
YouTube Issue #529
Come see the Microsoft team show you the latest innovations for SQL, ground to cloud to fabric, to help you build AI applications securely with your data. This will be a heavy demo-oriented session so...
-
Build a .NET 10 Web API - Minimal APIs, EF Core & SQL Server
Round The Code Issue #527
Build a .NET 10 Web API with Minimal APIs, Entity Framework Core and SQL Server, using Clean Architecture and FluentValidation.
-
Beyond Embeddings: Practical Vector Search with DiskANN in SQL Server
YouTube Issue #526
Vector support in SQL Server opens the door to modern semantic search scenarios—but embeddings alone are rarely enough. In this session, you’ll learn how to store, index, and query vector data in SQL ...
-
Your best friend: BlockOnPossibleDataLoss=True
Microsoft Dev Blogs Issue #524
Let's start with an admission: developers all hate BlockOnPossibleDataLoss. It is the bane of a smooth development workflow, as significant schema changes can block deployment because of BlockOnPossib...
-
How to Prevent and Handle SQL Deadlocks in .NET Applications
Medium Issue #522
Deadlocks are a common problem in applications that work with databases.
-
SQL Server Vector Search: Benchmarking EF Core Workloads
C# Corner Issue #521
Benchmark SQL Server vector search with EF Core. Explore exact vs. approximate search, performance factors, and best practices for RAG.
-
Database Performance in .NET
Medium Issue #521
In Part 1, I wrote about boundaries. In Part 2, I wrote about aggregates and invariants. In Part 3, I wrote about domain events. In Part 4…
-
How to Resolve SQL Server Error 40 ("Could Not Open a Connection to SQL Server")
C# Corner Issue #519
Resolve SQL Server Error 40 in ASP.NET Core. Troubleshoot connection issues with Entity Framework Core, connection strings, and configuration.
-
Common Mistakes in Manual SQL Database Recovery - Know What Not To Do
C# Corner Issue #516
Avoid common SQL database recovery mistakes. Learn best practices for manual recovery, when to use specialized tools, and prevent data loss.
-
Refactor your database with SQL projects in VS Code
Microsoft Dev Blogs Issue #514
SQL database projects are a fundamental tool for keeping your database in source control, tracking changes and collaborating on quickly evolving database needs. Not to be forgotten, their superpower i...
-
Understanding Entity Framework Core Migrations
C# Corner Issue #511
Master Entity Framework Core Migrations for seamless database schema management. Keep your database in sync with evolving C# models using the Code First approach.
-
Entity Framework Core 11 Migrations: Best Practices for Production Deployments
C# Corner Issue #505
Master EF Core 11 migrations for production. Learn best practices for safe deployments, avoiding downtime, and ensuring data integrity.
-
T-SQL Hygiene: What's the Big Deal with SET NOCOUNT ON?
Microsoft Dev Blogs Issue #501
Perhaps you have seen SET NOCOUNT ON; at the beginning of a stored procedure and wondered why it is there. By default, SQL Server uses SET NOCOUNT OFF;, which sends messages such as “(10 rows affected...
-
Track every EF Core record change with temporal tables
Round The Code Issue #499
Learn how to track every change to your EF Core records using SQL Server temporal tables, with examples for querying the history. The page Track every EF Core record change with temporal tables appear...
-
EF Core and Azure SQL Database: A Step-by-Step Guide
Dev Tips Issue #498
A step-by-step guide to using EF Core with Azure SQL Database - create the database in Azure Portal, connect and run migrations, add transient-fault resilience, and switch to passwordless Microsoft En
-
EF Core Interceptors: The Complete Guide (.NET 10)
codewithmukesh Issue #497
Learn EF Core interceptors in .NET 10 - all 7 types, how to register them, and how to add audit fields, soft deletes, and the current user without breaking dependency injection.
-
Bypassing the .NET GC: How I Hit 2.3 Million OPS With a C#-Native Embedded Database
Medium Issue #496
DataVo v0.1 Alpha: an open-source, zero-allocation SQL + vector engine that runs in-process, no native extensions required.
-
Building AI-Powered Database Query Optimization Tools with SQL Server and .NET
C# Corner Issue #493
Build AI-powered SQL Server query optimization tools with .NET. Automate performance analysis, detect bottlenecks, and get intelligent recommendations.
-
PostgreSQL vs SQL Server for Modern .NET Applications
C# Corner Issue #492
Compare PostgreSQL vs SQL Server for .NET apps. Explore licensing, performance, cloud, JSON, and scalability to choose the best fit.