DEV Community: Naghme Vahabi

C#

Naghme Vahabi — Mon, 27 Jan 2025 06:30:44 +0000

C# 13 new params feature

Naghme Vahabi — Mon, 20 Jan 2025 09:03:13 +0000

🚨Comparing coding approaches in C# 13!

🚀 Previously, we were able to use only arrays when We used params keyword.
C# 13 introduces Params Collections, allowing you to use the following concrete types:

*Arrays
*IEnumerable
*List
*Span
Embracing new features enhances our coding experience!

READ_UNCOMMITTED in SQL Server

Naghme Vahabi — Sun, 12 Jan 2025 07:54:27 +0000

📑 Understanding READ_UNCOMMITTED in SQL Server
READ_UNCOMMITTED is the lowest isolation level in SQL Server. When a query runs with this isolation level:

🟢 Benefits:

Fastest reading performance
No locks on data
Never waits for locks to be released

🔴 Risks:

Dirty Read: May read uncommitted data
Non-Repeatable Read: Reading the same record twice might give different results

❓When to use:

Non-critical reporting
Displaying approximate stats and metrics
Where eventual consistency is acceptable
Reading low-importance data where 100% accuracy isn't required

❓When NOT to use:

Financial transactions
Critical calculations
Where data consistency is crucial
Interdependent operations

using(var transaction = connection.BeginTransaction(IsolationLevel.ReadUncommitted))
{
// Read Data
}

🔍 Nested superpowers: Local functions let you organize code right where you need it! They're like mini-methods that live inside your main method, keeping related logic tightly packed and crystal clear.

Naghme Vahabi — Tue, 07 Jan 2025 07:43:43 +0000