Relative Content

Tag Archive for c#linq

Linq aggregating on subgroups

Here is sample table :

C# LINQ Query – Get the Top 1 Record From Another Table

I am new to LINQ query and I am struggling to figure out how to get the LINQ query working that produces the same result as this SQL query below. Note that ProductCode table can have duplicated records that is why I use “Top 1”.

Reading data using LINQ ends in timeout

I am reading data using LINQ query which has millions of data and ends up in timeout . And how we can optimize the query to increase its performance.

How to set a global condition to hide entities that are deleted