[ad_1] Avoiding the foreach will lose a small amount of performance and make the code harder to follow, but based on your (probably wrong) question, here is the equivalent LINQ: var ans = listL1.elements.SelectMany(level1 => level1.elements.SelectMany(level2 => listL2.elements.Select(level3 => new Level() { itemFromLevel1 = level1, itemFromLevel2 = level2, itemFromLevel3 = level3}))).ToList(); 2 [ad_2] solved How … Read more
[ad_1] This is a pretty straightforward query: allDevices.Where(d => d.Options.Any(o => o.Name == “Foot Pedal” && o.Installed)); Remember that a lambda is just a function. It can call other functions, declare variables, and everything else you can do in normal code. [ad_2] solved Linq and List of Lists
Introduction [ad_1] Linq and List of Lists is a powerful combination of technologies that can be used to create powerful and efficient data structures. Linq is a set of language-integrated query (LINQ) technologies that allow developers to query and manipulate data in a variety of ways. List of Lists is a data structure that allows … Read more
[ad_1] a.) In the above code, I am not sure what (DateTime?) startDate means? This is saying cast startDate to a DateTime? object. startDate might be a DateTime and for purposes of this for loop, it’s being cast to a nullable DateTime (DateTime?) b.) scorecardMonths on the very last line… sees to be some object.. … Read more
[ad_1] I would use join to find the matches: Dictionary<int, string> dict = new Dictionary<int, string> { {1, “A”}, {2, “B”}, {3, “c”}, {4, “D”}, {5, “E”}, }; string[] values = new [] {“A”,”D”,”E”}; var query = from kvp in dict join s in values on kvp.Value equals s select new {kvp.Key, Found = true}; … Read more
[ad_1] Regardless of whether the type of c is a reference type or a value type, when setting a variable c = something, you are overwriting whatever the variable referred to. So the original object that c referred to is no longer referenced. This does not change the list from updating its reference either though, … Read more
[ad_1] The first method should use this method: https://msdn.microsoft.com/en-us/library/vstudio/bb549393(v=vs.100).aspx Something like: return students.GroupBy(student => student.Level, (level, students) => new Tuple(level, students.Count())); Sorry I’m unable to test this, but basically like your version I’m using a lambda to say Group all students by level. The second lambda tells the method what to do with those groups. … Read more
[ad_1] your SQL to LINQ look like this:- try this from po1 in PO join pu in POUnit on po1.POID equals pou.POID join s in Scope on pou.ScopeCodeID equals s.ScopeID join t in Timesheet on s.ScopeID equals t.ScopeID join pr in Projects on s.ProjectID equals pr.ProjectID where s.ProjectID = 1 group by s.ScopeID Select new … Read more
[ad_1] If you want to retrieve only some of the columns then use the following overload: var result = data.GroupBy(key => key.Role, element => element.DocumentType); Otherwise you can also use this projection: var result = data.GroupBy(key => key.Role) .Select(g => new { Role = g.Key, Documents = g.Select(i => i.DocumentType) }); 3 [ad_2] solved How … Read more
[ad_1] You should create some dummy data to fill in the gaps. Since you’re doing a Sum, you can just create some dummies of your input data. To do so, I’ve assumed that Set is List<SourceData> – change this as necessary: public class SourceData { public DateTime Date { get; set; } public long TotalHours … Read more
[ad_1] Is this what you are looking for? public class Worker { public string Name {get;set;} public string CompanyId {get;set;} public string CompanyName {get;set;} } public class Company { public string Name {get;set;} public string Id {get;set;} } var companyList = new List<Company> { new Company{Id = “1”, Name = “Company 1”}, new Company{Id = … Read more
[ad_1] You want to use Any for that since l_obja is not a list of the ids. List<ClassA> l_obja = Obj1.exp.Values.Where(i => i.Id == mid).ToList(); List<ClassB> l_objb = Obj1.Pol.Values.Where(i => l_obja.Any(a => a.MGId == i.GId)); [ad_2] solved LINQ with List
[ad_1] Try something like this: List<User> users = db.Users.Where(user => user.Roles.Any(r => r.Name == role)).ToList(); This is the case if you want to compare role names otherwise implement your Equal method 2 [ad_2] solved How to convert for each loop over objects list property into linq statement
[ad_1] First of all, this code is incorrect: List<users> userList = getUsers(); public class user { string Name; string Country; DateTime EnrollmentDate; } List<users> should be List<user>. Next to that, the Name, Country and EnrollmentDate should be marked public in order to be accessed. The same goes for the return type of the extract unQualifiedUsers-method … Read more
[ad_1] To check if a list contains a number: if (myList.Contains(0.0)) … To check if a list does NOT contain a number: if (!myList.Contains(0.0)) … [ad_2] solved check where a list entry is not 0.0 [closed]