Advertisements How to merge two lists by unique field value and fill empty fields with values ​​of one of the list? I have a class where unique field is Model_id: class Structure { public string Category { get; set; } public string Place { get; set; } public string Model_id { get; set; } public… Read More How to merge two lists by a unique field value and fill empty fields with values from one list?

Advertisements I’m asked to create a function which removes all the elements from a list of integers respecting a specified condition i.e. the element is multiple of his index. It is very easy to do it with iterations and things like that but I wanted to do it in a "cuter" way just to get… Read More Removing elements from a List which respect a condition on the index

Advertisements I am facing one simple question here and since I am new in LINQ, I really need someone help. I have one SQL Query to Sum Amount based on Client ID, CommissionName and Date only from a DateTime. Here is the SQL Query : SELECT ClientId, CommisionName , CAST(Date AS DATE) DateOnly , sum(Amount)… Read More Multiple Group By and Count in LINQ Entity Framework

Advertisements I have to write a query using C# / LINQ, the equivalent of this: select RoleName from dbo.Roles where RoleId in (2,3,4,5,6) In my code I have a list of short ids (idRoles is a list of shorts ( example: 1,2,3,4)) and this code: List<string> roleNameList = new List<string>(); roleNameList = _dbContext .Roles .Where(r… Read More How to write query where condition in List of shorts

Advertisements I have this method: public async Task<List<string>> FindUsedComments(List<string> commentIds) { if (!commentIds.Any()) return new List<string>(); var usedCommentIds = GetNoTraking.Select(x => x.OrginalCommentId).AsEnumerable().Intersect(commentIds).ToList(); return usedCommentIds; } and it works fine! but if i change AsEnumerable to AsAsyncEnumerable it`s show me this error: ‘IAsyncEnumerable<string>’ does not contain a definition for ‘Intersect’ and the best extension method overload… Read More How can I use AsAsyncEnumerable in Linq?

Advertisements I have a list of objects that are in the order that I want to select them, but not sure how to do it… For example, if I have List<obj> mylist where obj has properties: start, end How do I create a list of numbers that contains start1, end1, start2, end2, start3, end3, etc…… Read More How do I Linq Select Multiple properties of objects?

Advertisements I have a Table class to which I pass a generic list of objects called data. Since the objects stored in the list can be of various type I implemented the following Table class public class Table<T> { private List<T> _data; public Table(List<T> data) { _data = data; //other constructor stuff } } The… Read More LINQ on a List<T> passed to a class

Advertisements I would like to understand the following snippet: class TestNewGuid { public Guid RequestId { get; set; } = Guid.NewGuid(); // any other fields } [Fact] public void Test() { var toInitAnEnumerable = new int[] {1}; var requests = toInitAnEnumerable .Select(a => new TestNewGuid()); var requestIds = requests .Select(a => a.RequestId) .ToHashSet(); // this… Read More Unexpected Guid change during a Linq request

Advertisements I am creating dynamic query for linq using contains but I am not getting any results back. Results exists in SQL. What am I doing wrong here? Since I can have N values for columns, .Contains should be okay. Code: public IAsyncEnumerable<MyTable> GetMyTableRecordsPerFilter( IReadOnlyList<string> filters, CancellationToken cancellationToken) { var queryParams = generateQuery(filters); var query… Read More Why dynamic Linq does not work with .contains?

Advertisements I have a simple sales header / sales line item table and I would like to return all header items where there the total quantity of line items is not zero I thought I could just do a join but that returns the header items duplicated for each line item: var orders = from… Read More LINQ to return only header items where line items are not zero