SO is not a website when you throw everything here and expected people finish the job for you. Anyway, to give you some hint, I give you a straight suggestion: Select CostGroupId From CostGroups Where CostGroupType = 1 –> Stored these in A collection, like an array: var costGroupsIdArr = ctx.CostGroup.Where(x=>x.CostGroupType == 1).Select(x.CostGroupId).toArray(); Then from … Read more
You should group all person skills by person id, and then select only those groups, which contain both given category and sub category: unitOfWork.PersonSkillsRepository.GetAll() .GroupBy(p => p.PersonId) .Where(g => g.Any(p => p.IdCategory == ids.IdCategory) && g.Any(p => p.IdSubCategory == ids.IdSubCategory)) .Select(g => g.Key) For optimization, you can filter out skills which do not match any … Read more
Can you write this method on the DbContext class? Then you could write something like in a separate new class file (e.g. ActionContextExtensions.cs or something like that): public partial class ActionContext : DbContext { public IEnumerable<T> SelectAll<T>() where T: class { return this.Set<T>().AsEnumerable(); } } This returns the type as defined by the generic parameter … Read more
Start by breaking up your logic into separate operations rather than trying to write everything in one line. Compilers are smart cookies so they optimize things quite well, there’s no point making your code harder to read/understand: var facultySpecialties = specialty.faculty_specialties .Where(fs => fs.faculty.active) .ToList(); // Executes the query to retrieve faculty specialties. foreach(var facultySpecialty … Read more
That’s because allLogs is lazy in nature — it will actually hit the database when first enumerated through in the foreach (see “Deferred query execution” here). If you materialize the collection before hand like the following, you will see that it steps through the foreach quickly: db.StatusLogs .Where(sl => sl.ID.Value.Equals(foo)) .GroupBy(sl=>sl.bar) .ToList(); // <– pull … Read more
This is your problem: _cache.TryGetValue(“CountsStats”, out countStats) out will change the object that countStats is pointing to. If it’s found in the cache, then it will be the cached object. Great! If it isn’t, then it will be null. You need to create a new instance in this case. You should change your code to … Read more
If you want to convert this to the method syntax version, you can do this step by step. I like to start at the end and work through to the beginning: select to Select defines the source: .Select(g => g.OrderByDescending(s => s.MeasureDate).FirstOrDefault()); group is GroupBy: .GroupBy(s => s.SensorUnitId) .Select(g => g.OrderByDescending(s => s.MeasureDate).FirstOrDefault()); from the … Read more
Try this, var products = from listProducts in repository.All() where listProducts.Code == “48654” group listProducts by listProducts.family into grp select grp; For more information visit LINQ Group By 0 solved How to use GroupBy in LINQ? [duplicate]
You’re comparing apples and oranges. Each of the approaches you list has benefits and drawbacks, so it’s impossible to answer which is the “preferred way.” Likewise, many of these examples will return immediately because they use deferred execution, so they’ll technically run faster, but won’t actually make your program run any faster. But if you’re … Read more
I resume step by step: 1 – Create a console project. 2 – Install EF using Nuget: Install-Package EntityFramework 3 – Create SalesRepresentative: namespace EF { public partial class SalesRepresentative { public int ID { get; set; } public string Name { get; set; } public string Email { get; set; } public string CellPhone … Read more