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.

175 articles Updated Aug 30, 2026 Page 6 of 7

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

SQL Server for C# and .NET articles

Page 6 of 7

Newest first

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
Dapper Micro ORM: A Lightweight Alternative to Stored Procedures

medium.com May 07, 2025 Issue #191

https://medium.com/@dharmikginoya/dapper-micro-orm-a-lightweight-alternative-to-stored-procedures-333163650d19

Dapper Performance

Read article Issue #191
How to Connect a Database to a Web API in C#

medium.com May 07, 2025 Issue #191

https://medium.com/@voidspidey/ee0d3c63687a

ASP.NET Core Web API

Read article Issue #191
EF Core 9 with SQL Server: Temporal Tables and Owned Entities

gunesramazan.medium.com May 06, 2025 Issue #190

https://gunesramazan.medium.com/using-temporal-tables-and-owned-entities-in-sql-server-with-ef-core-9-8b539c5054ca

EF Core

Read article Issue #190
Advanced Database Programming with C# 14 and Microsoft SQL Server

c-sharpcorner.com May 02, 2025 Issue #188

https://www.c-sharpcorner.com/article/advanced-database-programming-with-c-sharp-14-and-microsoft-sql-server/

C# EF Core

Read article Issue #188
Abstract Factory Pattern for Notification Services in C# 14

c-sharpcorner.com May 02, 2025 Issue #188

https://www.c-sharpcorner.com/article/abstract-factory-pattern-for-notification-services-in-c-sharp-14/

Dapper EF Core

Read article Issue #188
SQL Server CLR Integration and SSIS Automation with C#

c-sharpcorner.com Apr 28, 2025 Issue #184

https://www.c-sharpcorner.com/article/sql-server-clr-integration-and-ssis-automation-with-c-sharp/

C#

Read article Issue #184
Why would I add vectors to a relational database?

youtube.com Apr 17, 2025 Issue #177

https://www.youtube.com/watch?v=vHhKEN7Ru_k

PostgreSQL

Read article Issue #177
Entity Framework Core Tips: Reduce SQL Server Size and Improve Performance

medium.com Apr 17, 2025 Issue #177

https://medium.com/@yusufsarikaya023/entity-framework-core-tips-reduce-sql-server-size-and-improve-performance-77e650ae1ec2

EF Core Performance

Read article Issue #177
Create Foreign Keys Dynamically in SQL Server Database

c-sharpcorner.com Apr 16, 2025 Issue #176

https://www.c-sharpcorner.com/article/create-foreign-keys-dynamically-in-sql-server-database/

.NET Aspire Azure Azure Functions

Read article Issue #176
Integrating Elasticsearch with .NET, SQL Server, and Blazor for Advanced Search and Filtering

medium.com Apr 16, 2025 Issue #176

https://medium.com/@robhutton8/integrating-elasticsearch-with-net-sql-server-and-blazor-for-advanced-search-and-filtering-5d688e84485c

Blazor

Read article Issue #176
Enhancing Search Capabilities in SQL Server and Azure SQL with Hybrid Search and RRF Re-Ranking

devblogs.microsoft.com Apr 16, 2025 Issue #176

https://devblogs.microsoft.com/azure-sql/enhancing-search-capabilities-in-sql-server-and-azure-sql-with-hybrid-search-and-rrf-re-ranking/

Azure

Read article Issue #176
Explaining Tanspose DataTable Data in C#

c-sharpcorner.com Apr 16, 2025 Issue #176

https://www.c-sharpcorner.com/article/explaining-tanspose-datatable-data-in-c-sharp/

C#

Read article Issue #176
Efficient SQL Query to Remove Duplicates with ROW_NUMBER

c-sharpcorner.com Apr 10, 2025 Issue #172

https://www.c-sharpcorner.com/blogs/efficient-sql-query-to-remove-duplicates-with-rownumber

Dapper

Read article Issue #172
Top 20 SQL Best Practices Every Developer Should Follow

csharp.com Apr 10, 2025 Issue #172

https://www.csharp.com/blogs/top-20-sql-best-practices-every-developer-should-follow

Performance

Read article Issue #172
SQL Optimization: Filter Data Before or During a JOIN?

c-sharpcorner.com Apr 09, 2025 Issue #171

https://www.c-sharpcorner.com/Blogs/sql-optimization-filter-data-before-or-during-a-join

ASP.NET Core C# .NET 8

Read article Issue #171