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 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

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
Performance, security, and tooling

DotNetNews Apr 03, 2025 Issue #167

A varied roundup of .NET guides on performance, API security, Azure basics, testing, Blazor, MAUI, and observability for working developers.

ASP.NET Core Azure Blazor

Issue #167
Understanding Parameter Sniffing in SQL Server

csharp.com Apr 02, 2025 Issue #166

https://www.csharp.com/article/understanding-parameter-sniffing-in-sql-server/

ASP.NET Core Azure DevOps C#

Read article Issue #166
Understanding SQL Execution Plans

csharp.com Mar 24, 2025 Issue #159

https://www.csharp.com/article/understanding-sql-execution-plans/

Performance

Read article Issue #159
Temp Tables vs. Table Variables vs. CTEs: Which One Should You Really Use?

medium.com Mar 19, 2025 Issue #156

https://medium.com/@riturajpokhriyal/temp-tables-vs-table-variables-vs-ctes-which-one-should-you-really-use-b427679038cd

Dapper Performance

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

csharp.com Mar 06, 2025 Issue #147

https://www.csharp.com/Blogs/efficient-sql-query-to-remove-duplicates-with-rownumber

ASP.NET Core C# .NET 10

Read article Issue #147
Boost SQL Server Performance with Memory-Optimized Tables

csharp.com Mar 05, 2025 Issue #146

https://www.csharp.com/article/boost-sql-server-performance-with-memory-optimized-tables/

Performance

Read article Issue #146
EF Core 8 & .NET 9 Raw SQL Queries: The Ultimate Guide to Unmapped Types

medium.com Mar 05, 2025 Issue #146

https://medium.com/@ashokreddy343/ef-core-8-net-9-raw-sql-queries-the-ultimate-guide-to-unmapped-types-1837b225afe2

.NET 9 EF Core

Read article Issue #146
Reduce NULL Storage in SQL Server with Sparse Columns

csharp.com Feb 18, 2025 Issue #135

https://www.csharp.com/article/reduce-null-storage-in-sql-server-with-sparse-columns/

ASP.NET Core Benchmarking C#

Read article Issue #135
Logging, CQRS, and DI in .NET

DotNetNews Dec 31, 2024 Issue #100

A mixed .NET roundup covering logging, CQRS, saga and DI patterns, ASP.NET Core performance, Azure OpenAI, and SQL Server ETL tips.

ASP.NET Core Azure CQRS

Issue #100
.NET 9 performance and caching tips

DotNetNews Dec 19, 2024 Issue #93

Issue #93 mixes .NET 9 speed notes, SQL Server and Fabric data pieces, ASP.NET Core guidance, and practical caching and DI advice.

ASP.NET Core Azure .NET 9

Issue #93