I am confused to understand the difference between Linq's Count() for IQueryable and Linq's Count() for IEnumerable. I have the following method which has to return the same result of the counts, but enumerableCount equals 2 while queryableCount is 0:…
Looking for direct way to convert/cast all elements of List<string> to a list of particular type which has one string property. Type Class with one string property: public class ClaimNumber { public string claimNumber { get; set; } } The…
I have query for getting data await _dbContext.VwJobSupplierWithScores .Where(x => x.JobId == jobId && x.SupplierKey == supplierKey) .OrderBy(x => x.SpendCurrencyJob) .Select((x, i) => new {item = x, index = i}) .FirstOrDefaultAsync())!, But for some reasons EF cannot translate it and…
I am new to LINQ queries and want to use FirstOrDefault in my existing LINQ query. List<vUserAll> employee = (from o in db.vUsersAll where (o.sAMAccountName == modifiedAccountName || o.CN == modifiedAccountName) && o.Domain == "dExample" select o).ToList(); What's the correct…
I have a table "StaffMembers" that have columns indicating the number of days worked in a month, the properties in the model are as follows: public class StaffMember { public int Id { get; set; } public string Name {…
public class CategoryDomainModel { public string? _id { get; set; } public string? RestaurantID { get; set; } public string? CategoryName { get; set; } public Enums.Status Status { get; set; } } public class MenuItemDomainModel { public string? _id…
I want to get all dates in the last three months, so I did the following: protected void BindPermissions(int empNum) { var permPeriod = new Dictionary<int, int>(); permPeriod.Add(DateTime.Now.Year, DateTime.Now.Month); permPeriod.Add(DateTime.Now.AddMonths(-1).Year, (DateTime.Now.AddMonths(-1).Month)); permPeriod.Add(DateTime.Now.AddMonths(-2).Year, (DateTime.Now.AddMonths(-2).Month)); var dt = payload_object.AttendancePermissionBO.permissionList .Where(x => x.empNum…
my question is simple but I got stuck with something. Can you tell me how can I reduce 2 select into 1 select LINQ in c#? I am using CloudNative.CloudEvents NuGet package for cloud-native events. var orderEvents = input .Select(_…
I have an .Net5 solution using Entity Framework 5.0.0. Im able to save data to the Backend SQL DB and all is well. But when I try to check is a record exist using the statement below im getting an…
I have the following Category Model: public class CategoryDTO { public int Id { get; set; } public string Name { get; set; } public List<SelectList> WarehouseNames { get; set; } } Warehouse Model: public class Warehouse { public int…