I have an entity table with below model public class VulnerabilityImportFileLog { public Collection<Vulnerability> Vulnerability { get; set; } } Trying to return an string value using the select statement in the entity framework query var vulnerabilityImportFileLogSelect = vulnerabilityImportFileLogQuery .Select(vulnerabilityImportFileLog…
I have below model classes public class Hotel { public string hoteltype { get; set; } public List<Room> rooms { get; set; } } public class Room { public Room2 room { get; set; } public string name { get;…
I'm separating a string by first name and last name. I equate the last word to the last name. I equate the remainder to the firstname. This string can be empty or null. I'm checking for null return. but in…
I have this models public class RoutingAttributeModel { public int Bus_No { get; set; } public int Attribute_No { get; set; } public string Attribute_Name { get; set; } public string Status { get; set; } public string Notes {…
I have this Wishlist class: public class Wishlist { public int Id { get; set; } public int ProductId { get; set; } [ForeignKey("ProductId")] public virtual Product Product { get; set; } public string PersonId { get; set;} [ForeignKey("PersonId")] public…
So I have a list with post objects that have a visibility enum property. I'm trying to get all posts that have visibility == visibility.public and visibility == visibility.private && AuthorId == currentUserId. This doesn't seem to work: from e…
In the following code when I want to get sum for sumField I'm getting an error(Can Not Convert From Expression<Func<T, decimal>> To Func<T, decimal>) If I remove the Expression from the groupBy and sumField parameters, my problem will be solved,…
I have a problem and unfortunately can not find the solution! This is my database: enter image description here and I would like to store all PaymentSum(double) [PaymentInformation] in the Total (double) [Document]. This is the SQL statement: Select SUM(PaymentSum)…
I have a list which has following result set . public class PrExport { public string pId { get; set; } public string prName { get; set; } public string hId { get; set; } public string hName { get;…
I have 2 lists. List A consists of this value, status | level ----------------- open | low open | medium open | high closed | low closed | medium closed | high List B consists of this value, task |…