I have this query: int maxShoeSize = Workers .Where(x => x.CompanyId == 8) .Max(x => x.ShoeSize); What will be in maxShoeSize if company 8 has no workers at all? UPDATE: How can I change the query in order to get 0 and not an exception? 11 Answers 11
Can someone please explain what a GroupJoin() is? How is it different from a regular Join()? Is it commonly used? Is it only for method syntax? What about query syntax? (A c# code example would be nice) 3 Answers 3
In C#, say I have a class called Note with three string member variables. public class Note { public string Title; public string Author; public string Text; } And I have a list of type Note: List<Note> Notes = new List<Note>(); What would be the cleanest way to get a list of all distinct values … Read more
In using the EntityFramework, I get the error “A lambda expression with a statement body cannot be converted to an expression tree” when trying to compile the following code: Obj[] myArray = objects.Select(o => { var someLocalVar = o.someVar; return new Obj() { Var1 = someLocalVar, Var2 = o.var2 }; }).ToArray(); I don’t know what … Read more
This question already has answers here: LINQ equivalent of foreach for IEnumerable<T> (22 answers) Closed 2 years ago. Is there any Linq style syntax for “For each” operations? For instance, add values based on one collection to another, already existing one: IEnumerable<int> someValues = new List<int>() { 1, 2, 3 }; IList<int> list = new … Read more
I have a list of people’s ID and their first name, and a list of people’s ID and their surname. Some people don’t have a first name and some don’t have a surname; I’d like to do a full outer join on the two lists. So the following lists: ID FirstName — ——— 1 John … Read more
I have a collection of MyClass that I’d like to query using LINQ to get distinct values, and get back a Dictionary<string, string> as the result, but I can’t figure out how I can do it any simpler than I’m doing below. What would some cleaner code be that I can use to get the … Read more
Seems like this is the kind of thing that would have already been answered but I’m unable to find it. My question is pretty simple, how can I do this in one statement so that instead of having to new the empty list and then aggregate in the next line, that I can have a … Read more
LINQ: Is it more efficient to use the Single() operator over First() when ever I know for certain that the query will return a single record? Is there a difference? 11 Answers 11
I have a class as follows: public class Tag { public Int32 Id { get; set; } public String Name { get; set; } } And I have two lists of tag: List<Tag> tags1; List<Tag> tags2; I used LINQ’s select to get the Ids of each tags list. And then: List<Int32> ids1 = new List<Int32> … Read more
