You are not returning the sorted collection. IEnumerable<Customer> result = orderings[sortExpression](customerQuery.Skip(startRows).Take(maxRows)); return result; 3 solved My sorting is not returning correctly in Linq [closed]
try this IdAccess = from x in OffAcs where x.AccessDeccription == Combobox.SelectedText select x.IdAccess; or this: IdAccess = OffAcs.First(x=>x.AccessDeccription == Combobox.SelectedText).IdAccess; 3 solved how to point to a number that correspond value of this number is selected by user?
Really, you are asking two different questions. Entity Framework is not a database administration tool and as such does not have any functionality for directly loading data from a spreadsheet. If you research each part of your question separately, you might have more luck. Seeding data with Entity Framework Reading Excel Files with C# Reply … Read more
First, let’s define what we need. We need a table (view) with these fields: ProductId, ProductName, ProductViewCount, and RootCategoryId. Imagine, the Category table has RootCategoryId field already. Then we can use this query to receive the result: SELECT P.Id AS ‘ProductId’, P.Name AS ‘ProductName’, PVC.ProductViewCount, C.RootCategoryId FROM Category C INNER JOIN ProductCategory PC ON PC.CategoryId … Read more
You are not using the result of query IQueryable<StammdatenEntityModel> query = dbSet; query = query.OrderByDescending(s => s.CreateDateTime); query = query.Where(s => s.Deleted == false); if(!String.IsNullOrEmpty(keyword)) { query = query.Where(s => s.SerialNumber.Contains(keyword)); //simplified for SO } query = query.Skip(skip); query = query.Take(take); 0 solved IQueryable with Entity Framework – order, where, skip and take have no … Read more
First, I created a single table database to mimic the data structure: static void CreateAndSeedDatabase() { Context context = new Context(); TimeTracker entry1 = new TimeTracker() { UserId = 1, LoginTime = new DateTime(2000, 1, 1, 0, 0, 0), LogoutTime = new DateTime(2000, 1, 1, 1, 0, 0) }; TimeTracker entry2 = new TimeTracker() { … Read more
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