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.
193 articles Updated Page 2 of 8
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 2 of 8
Newest first
-
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.
-
AI-Powered Database Schema Evolution Using Entity Framework Core
C# Corner Issue #490
Enhance database schema evolution with Entity Framework Core and AI. Reduce risks, improve performance, and automate documentation for safer migrations.
-
Building AI-Powered SQL Query Performance Advisors with Entity Framework Core
C# Corner Issue #490
Build AI-powered SQL query advisors with Entity Framework Core to automatically detect bottlenecks, optimize performance, and boost application responsiveness.
-
Building an AI-Driven Database Query Performance Analyzer with .NET and SQL Server
C# Corner Issue #490
Build an AI-driven .NET and SQL Server analyzer to boost database query performance, reduce troubleshooting time, and enhance application responsiveness.
-
30 EF Core Interview Questions That Actually Get Asked in 2026
codewithmukesh Issue #488
30 real EF Core interview questions with great answers, red flags, and follow-ups. N+1, change tracking, migrations, concurrency - updated for EF Core 10.
-
Mastering .NET Interviews – Part 6: Entity Framework & Data Access
C# Corner Issue #487
Master .NET interviews: Dive into Entity Framework (EF) & data access. Learn EF Core, LINQ, migrations, transactions, and common interview questions.
-
Building Autonomous Database Optimization Assistants with .NET and Azure AI
C# Corner Issue #486
Build autonomous database optimization assistants with .NET and Azure AI. Enhance performance, reduce manual effort, and enable proactive management.
-
Migrating 200 Million Records in .NET: From Row-by-Row to a Crash-Safe Batched Pipeline
Medium Issue #485
A real-world walkthrough of how we rewrote a data migration four times before it was production-ready
-
We Moved from SQL Server to PostgreSQL in a .NET
Medium Issue #483
We moved one of our .NET systems from SQL Server to PostgreSQL mainly to reduce licensing cost and simplify our cloud setup.
-
GUID v7 in SQL Server: Performance Benefits, Limitations, and Best Practices
Medium Issue #483
GUID v7 in SQL Server: Performance Benefits, Limitations, and Best Practices
-
Building AI-Powered SQL Assistants with Semantic Kernel and .NET
C# Corner Issue #482
Build AI-powered SQL assistants with Semantic Kernel and .NET to unlock data insights. Empower users with natural language queries and secure data access.
-
UUID v7 in SQL Server: Can You Really Use It? (The Limitation Nobody Tells You About) Deep Dive
Medium Issue #482
By Pankaj Ikhar — Solution Architect | Mentor | Coach #LearnWithPankaj | Follow for Career Growth & Interview Preparation
-
How to Build AI-Powered Data Analysts Using Semantic Kernel and .NET
C# Corner Issue #482
Build AI-powered data analysts with Semantic Kernel and .NET. Understand natural language, query data, and generate actionable business insights.
-
📖 Building a Web-Based Timesheet Management System in ASP.NET Core
C# Corner Issue #480
Build a robust ASP.NET Core MVC timesheet system with SQL Server. Features include entry, allocation, approvals, auth, reporting & deployment.
-
Aspire Azure SQL deployment bug
Software Engineering Issue #478
This week, I was updating my Aspire applications after the latest release and I ran into a deployment bug for my test deployments. I could no longer deploy the database to Azure SQL. I got the followi...
-
Database Sharding in .NET Applications: Benefits, Challenges, and Implementation
C# Corner Issue #477
Unlock .NET app scalability with database sharding. Learn benefits, challenges, and implementation strategies for high-growth applications.