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.

165 articles Updated Jul 21, 2026 Page 5 of 7

Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.

SQL Server for C# and .NET articles

Page 5 of 7

Newest first

SQL Best Practices from a .NET Core Developer’s Lens — What I Wish I Knew Earlier

medium.com Aug 01, 2025 Issue #253

https://medium.com/@sunita.rawat.cgi/sql-best-practices-from-a-net-core-developers-lens-what-i-wish-i-knew-earlier-b954a8b83a41

.NET Core

Read article Issue #253
Temp Tables vs CTEs in SQL Server: What You Should Really Know

c-sharpcorner.com Jul 29, 2025 Issue #250

https://www.c-sharpcorner.com/article/temp-tables-vs-ctes-in-sql-server-what-you-should-really-know/

ASP.NET Core Clean Architecture .NET 9

Read article Issue #250
Code First vs. Database First: A Pragmatic Guide for Modern Software Engineers

medium.com Jul 16, 2025 Issue #241

https://medium.com/@MatinGhanbari/code-first-vs-database-first-a-pragmatic-guide-for-modern-software-engineers-29ac04f1daa1

EF Core

Read article Issue #241
🚀 Automating SQL Server Database Backups and Remote Table Sync

c-sharpcorner.com Jul 16, 2025 Issue #241

https://www.c-sharpcorner.com/article/automating-sql-server-database-backups-and-remote-table-sync/

Azure

Read article Issue #241
Boost SQL Server Performance in .NET: The Hybrid Index Strategy (Part 3)

itnext.io Jul 15, 2025 Issue #240

https://itnext.io/boost-sql-server-performance-in-net-the-hybrid-index-strategy-part-3-ebaf40397ed2?source=rss------dotnet-5

ASP.NET Core Authentication Azure

Read article Issue #240
Why You Must Switch from System.Data.SqlClient to Microsoft.Data.SqlClient Now

medium.com Jul 09, 2025 Issue #236

https://medium.com/@nagarajvela/why-you-must-switch-from-system-data-sqlclient-to-microsoft-data-sqlclient-now-3d9ba2a8b9c2

.NET Core

Read article Issue #236
How Indexed Views Cut SQL Server Dashboard Load Time by 93% (Part 2)

itnext.io Jul 08, 2025 Issue #235

https://itnext.io/how-indexed-views-cut-sql-server-dashboard-load-time-by-93-part-2-82a0463ba462

Performance

Read article Issue #235
How to Collaboratively Work with SQL Server 2025, Visual Studio Code, and GitHub Copilot (Step-by-Step Guide)

c-sharpcorner.com Jun 24, 2025 Issue #225

https://www.c-sharpcorner.com/article/how-to-collaboratively-work-with-sql-server-2025-visual-studio-code-and-github/

GitHub Copilot Visual Studio Code

Read article Issue #225
Build modern data applications with SQL Server 2025 | Data Exposed

youtube.com Jun 17, 2025 Issue #220

https://www.youtube.com/watch?v=pckjd-5rT9M

C# EF Core GitHub Copilot

Read article Issue #220
Horizontal vs Vertical Partitioning in SQL

c-sharpcorner.com Jun 13, 2025 Issue #218

https://www.c-sharpcorner.com/article/horizontal-vs-vertical-partitioning-in-sql/

Azure C# Performance

Read article Issue #218
A story of collaborating agents: chatting with your database the right way

devblogs.microsoft.com Jun 13, 2025 Issue #218

https://devblogs.microsoft.com/azure-sql/a-story-of-collaborating-agents-chatting-with-your-database-the-right-way/

Azure OpenAI

Read article Issue #218
Transactional Messaging in .NET: Integrating Brighter’s Outbox Pattern with SQL Server and RabbitMQ

medium.com Jun 13, 2025 Issue #218

https://medium.com/@actor-swe/transactional-messaging-in-net-integrating-brighters-outbox-pattern-with-sql-server-and-rabbitmq-181ae87212cd

RabbitMQ Service Bus

Read article Issue #218
Use Copilot to Create and Edit Power Fx formulas

c-sharpcorner.com Jun 13, 2025 Issue #218

https://www.c-sharpcorner.com/article/use-copilot-to-create-and-edit-power-fx-formulas/

Performance

Read article Issue #218
Debunking the "Filter Early, JOIN Later" SQL Performance Myth

milanjovanovic.tech Jun 12, 2025 Issue #217

https://www.milanjovanovic.tech/blog/debunking-the-filter-early-join-later-sql-performance-myth

Performance

Read article Issue #217
Using Oracle with Entity Framework

nodogmablog.bryanhogan.net Jun 04, 2025 Issue #211

https://nodogmablog.bryanhogan.net/2025/05/using-oracle-with-entity-framework/

EF Core

Read article Issue #211
SQL Server Transaction Locks: Identification & Resolution

c-sharpcorner.com Jun 04, 2025 Issue #211

https://www.c-sharpcorner.com/article/sql-server-transaction-locks-identification-resolution/

Performance

Read article Issue #211
New AI Features in SQL Server 2025

devblogs.microsoft.com May 28, 2025 Issue #206

https://devblogs.microsoft.com/azure-sql/new-ai-features-in-sql-server-2025/

OpenAI

Read article Issue #206
Mastering Named, Positional, and Input/Output Parameters in Stored Procedures with EF Core

c-sharpcorner.com May 26, 2025 Issue #204

https://www.c-sharpcorner.com/article/mastering-named-positional-and-inputoutput-parameters-in-stored-procedures-wi/

EF Core

Read article Issue #204
Announcing the General Availability (GA) of JSON data type & JSON aggregates…

devblogs.microsoft.com May 26, 2025 Issue #204

https://devblogs.microsoft.com/azure-sql/announcing-the-general-availability-ga-of-json-data-type-json-aggregates/

Azure

Read article Issue #204
Mastering Time Zone Comparison in C# 12 and .NET 8 with SQL Server

medium.com May 13, 2025 Issue #195

https://medium.com/@ashokreddy343/mastering-time-zone-comparison-in-c-12-and-net-8-with-sql-server-2817c4e3110e

C#

Read article Issue #195
Efficiently and Elegantly Modeling Embeddings in Azure SQL and SQL Server

devblogs.microsoft.com May 12, 2025 Issue #194

https://devblogs.microsoft.com/azure-sql/efficiently-and-elegantly-modeling-embeddings-in-azure-sql-and-sql-server/

Azure

Read article Issue #194
Ultimate Guide to Entity Framework Core in the HR Domain — Migrations, Seeding, Raw SQL &…

medium.com May 12, 2025 Issue #194

https://medium.com/@venkataramanaguptha/ultimate-guide-to-entity-framework-core-in-the-hr-domain-migrations-seeding-raw-sql-d65d8ca33968

EF Core

Read article Issue #194
Building an E-Commerce Chatbot in ASP.NET Using SQL Server

c-sharpcorner.com May 08, 2025 Issue #192

https://www.c-sharpcorner.com/blogs/building-an-ecommerce-chatbot-in-asp-net-using-sql-server

ASP.NET Core OpenAI

Read article Issue #192
Your Database Isn’t a Junk Drawer — So Stop Treating It Like One

medium.com May 08, 2025 Issue #192

https://medium.com/@michaelmaurice410/your-database-isnt-a-junk-drawer-so-stop-treating-it-like-one-80abb47f29ec

EF Core

Read article Issue #192
Avoid These 7 C# Coding Mistakes Beginners Make

medium.com May 08, 2025 Issue #192

https://medium.com/@venkataramanaguptha/avoid-these-7-c-coding-mistakes-beginners-make-7477cf3248f9

Azure

Read article Issue #192