I have an entity like: public class TEvent { public int? January { get; set; } public int? February { get; set; } public int? March { get; set; } public int? April { get; set; } public int? May…
I have a problem, i need to compare two TimeZOnes, one from data base and other from our system, i managed to compare both lists and create two lists of strings with only names of time zones but can´t create…
i am working on a ticket where there is a array of data i am passing as parameter to a method and based on the parameter and another date parameter i want filtered result but i am not able to…
I am writing a Unit test where in i am passing array of two records and i want to send it to a method which can filter the records and pass only a single record but i have tried to…
I have LINQ expression to take top 15 most frequently used answers Here is expression var latestAnswers = await _dbContext.TextAnswers.Include(x => x.CompanySurvey).ThenInclude(x => x.Survey) .Where(x => x.CompanySurvey.Survey.FiscalYear == 2022) .GroupBy(x => x.Answer) .OrderByDescending(g => g.Count()) .Take(15) .ToListAsync(); But I get…
I have a ClassA with 10 fields and have the following list populated with 100 records. List<ClassA> abc = new List<ClassA>(); I have another class ClassB with 12 fields where 10 fields are same as Class and 2 extra fields…
I have this query where I want to return results if the search string provided yields data from the 'FirstName' and 'LastName' column of my database. They each work individually as I can get results for Firstname = 'john' and…
I'm having the above error and don't know what to do. You can assume the tables are already set up correctly. Here is the problem code: var setting = _context.Settings.FirstOrDefault(); ICollection<PD_Datafile> PD_Datafiles = new Collection<PD_Datafile>(); for (int i = 0;…
I have two related tables like below : Users : public partial class Users { [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")] public Users() { } public int ID { get; set; } public int UserType_ID { get; set; } public string Email { get;…
I have one table in database named Balance and a list of dates as follows: List<string> allDates = { "2021-01-02", "2021-01-03", "2021-01-04" } Balance table: Id, Amount, BalanceDate 1, 233, "2021-01-02" 2, 442, "2021-01-03 I need to fetch the records…