Below is the object namespace TestingForCw2.Shared { public class Dog { [Key] public Int32 Id { get; set; } public string DogName { get; set; } public Int32 DogAge { get; set; } } } This is the code for…
I have a string: private const string Codes = "2,10"; public void method() { var displayCodes = Codes.Split(','); DemoResponse response = webService.GetResponse(); //getting response from API if(response.Errors.Any(x => displayCodes.Contains(x.StackTrace)) { int myCode = int.Parse(response.Errors.Select(x => x.StackTrace).FirstOrDefault()); } } This is…
The background task I am running in my asp.net application is taking long time to execute and is getting stuck at a linq query.How to optimize the linq query or can you suggest some alternatives so that this method or…
I'm facing a issue when trying to search my page when trying to filter from 5 parameters. If the parameters is null then I would want to ignore that search and only return results if there is a value in…
I have following situation: In my db table Schedule I have columns: IsConfirmed, IsAnonymous, DateTimeUtcRequestSend, EmailAddress, UMCN, Deleted, ServiceId User can be registered user or anonymous. If the user is anonymous, it has a flag IsAnonymous = 1 otherwise the…
I have a below linq query and getting data like below example want to remove duplications List<EmployeeSalary> lstEmployeeSalary = new EmployeeSalaryFactory().GetRelatedObjects(inValue, ddlPayDate, payRollType, payrollSearch) .Select(m => (EmployeeSalary)m) .ToList(); For ex.: Id Name EmpCode Salary DateOfSalary ------------------------------------------------------------- 1 Item1 IT00001 $100…
I have a LINQ query like this: var data = from user in _context.Users select new { UserId = user.Id, Username = user.UserName, RoleNames = (from userRole in _context.UserRoles join role in _context.Roles on userRole.RoleId equals role.Id where userRole.UserId ==…
Here lists a payment history of a customer in a db table CustomerId PayId FeePaid xx-yy-zz 37 0 xx-yy-zz 32 0 xx-yy-zz 31 30.00 xx-yy-zz 28 0 xx-yy-zz 26 0 xx-yy-zz 18 35.99 xx-yy-zz 17 0 xx-yy-zz 16 0 xx-yy-zz…
Consider the following object structure stored as documents: public class Foo { public string Id { get; set; } public List<FooBar> Bars { get; set; } // ... } public class FooBar { public string uid { get; set; }…
I have 2 databases and folowing models For db 1: Public class StorageItem { public int Id { get; set; } public string Name { get; set; } } for db 2: public class Storage { public int Id {…