My coding exploration

How to pass list of values to a Stored Procedures from C#?

In C#, if we want to pass a single value to stored procedure from C#, it should be straight forward. Because based on the data type, we can pass the value appropriately.

How to link tables without Primary Key in Entity Framework (C#)?

In Entity Framework, it is quite common to bring relationship between two table by using the primary key of referencing table.

How to flatten the nested lists using LINQ in C#?

LINQ (Language Integrated Query) is a powerful feature in C#. It simplifies a way to query database in the C#. Recently, I came across the question raised by my team member on how to flatten the nested lists (List of lists) when querying the data in C#. So, I thought of go through the approach with an example using LINQ in this article. Let’s try with the simple example of list of integers as below.

How to tackle Deadlocks in C#?

Deadlocks are common challenging scenario in multithreaded programming environment developed in C#. A deadlock occurs when more than one thread tries to acquire the shared resource that is held by another thread. In this article, we will explore the concept of deadlocks, understand their cause and learn effective strategies to prevent them with the examples.

How to tackle thread synchronization problem in C#?

Nowadays, a lot of applications require multi threading environment to be highly performant. So, in that environment, there are more chances for synchronization problem which is when more than one thread try to access the same resource at a same time.