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.
189 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
-
Track every EF Core record change with temporal tables
roundthecode.com 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
antondevtips.com 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.com 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.com 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-sharpcorner.com 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-sharpcorner.com 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-sharpcorner.com 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-sharpcorner.com 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-sharpcorner.com 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.com 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-sharpcorner.com 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-sharpcorner.com 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.com 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.com 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.com Issue #483
GUID v7 in SQL Server: Performance Benefits, Limitations, and Best Practices
-
Building AI-Powered SQL Assistants with Semantic Kernel and .NET
c-sharpcorner.com 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.com 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-sharpcorner.com 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-sharpcorner.com 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
damienbod.com 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-sharpcorner.com Issue #477
Unlock .NET app scalability with database sharding. Learn benefits, challenges, and implementation strategies for high-growth applications.
-
Thread Pool Exhaustion in ASP.NET: The Async Database Trap
blog.dotnetframework.org Issue #477
If you’ve ever migrated a working ASP.NET application from synchronous database calls to async, and suddenly found yourself hitting connection pool timeouts under load, you’ve likely fallen into one o...
-
The complete guide to mastering Dapper micro-ORM in .NET
blog.elmah.io Issue #476
For developers who want to taste ORM but don't want to leave SQL either, Dapper is a perfect choice. Dapper runs SQL queries like ADO.NET but returns results as C# objects, like Entity Framework Core....
-
SQL Server Performance Tuning Techniques for Modern Applications
c-sharpcorner.com Issue #474
Learn SQL Server performance tuning techniques including indexing, query optimization, execution plans, statistics management, and database best practices.
-
Give your Agent memory with SQL Server and Microsoft Agent Framework | Data Exposed
youtube.com Issue #468
3:20 context provider and history provider with Microsoft Agent Framework 5:04 more details on the history provider and how Microsoft Agent Framework helps