Data Binding error

Question

Hello Team I tried binding these tables together and this is the error mesage that came in the screenshot below public JsonResult UpdateItem(int? ItemId) { var dataList = objRestaurantDBEntities.tblItems.Include(tblCategory).Include(tblQuantity).ToList(); var modifiedData = dataList.AsEnumerable().Where(x => x.ItemId == ItemId).Select(d => new bindItem { ItemId = d.ItemId CategoryId = d.CategoryId PCode = d.PCode CategoryName = d.tblCategory.CategoryName QuantityId = d.QuantityId Quantity = d.tblQuantities.Quantity ItemName = d.ItemName ItemPrice = d.ItemPrice Active = d.Active }).FirstOrDefault(); return Json(modifiedData JsonRequestBehavior.AllowGet); }

Ali Benchaaban · Answer

Based on the provided class definitions it looks like you have defined the relationships between tblCategory  tblItem  and tblQuantity correctly. The error you mentioned earlier suggests that the LINQ query is not able to find a QuantityId property in tblItem . In your bindItem class you have defined QuantityId as a property but it's not clear if you want to map this to tblQuantity.QuantityId or some other property. Here's an updated LINQ query that should help you map the properties correctly: public JsonResult UpdateItem(int? ItemId) { var dataList = objRestaurantDBEntities.tblItems .Include(tblCategory) .Include(tblQuantities) .ToList(); var modifiedData = dataList .Where(x => x.ItemId == ItemId) .Select(d => new bindItem { ItemId = d.ItemId CategoryId = d.CategoryId PCode = d.PCode CategoryName = d.tblCategory.CategoryName QuantityId = d.tblQuantities.FirstOrDefault()?.QuantityId Quantity = d.tblQuantities.FirstOrDefault()?.Quantity ?? 0 ItemName = d.ItemName ItemPrice = d.ItemPrice Active = d.Active }) .FirstOrDefault(); return Json(modifiedData JsonRequestBehavior.AllowGet); } Make sure to test this updated query and adjust it further based on your specific requirements and business logic. Regards

Anandu G Nath · Answer

public JsonResult UpdateItem(int? ItemId) { var dataList = objRestaurantDBEntities.tblItems .Include(tblCategory) .Include(tblQuantities) .ToList(); var modifiedData = dataList .Where(x => x.ItemId == ItemId) .Select(d => new { d.ItemId d.CategoryId d.PCode CategoryName = d.tblCategory.CategoryName QuantityId = d.QuantityId Quantity = d.tblQuantities.Quantity d.ItemName d.ItemPrice d.Active }) .FirstOrDefault(); if (modifiedData != null) { return Json(modifiedData JsonRequestBehavior.AllowGet); } else { return Json(new { error = Item not found } JsonRequestBehavior.AllowGet); } } Check this code

Emmmanuel FIADUFE · Answer

Thank you team it is working now

Emmmanuel FIADUFE · Answer

public partial class tblCategory { public tblCategory() { this.tblItems = new HashSet (); } public int CategoryId { get; set; } public string CategoryName { get; set; } public virtual ICollection tblItems { get; set; } } public partial class tblItem { public tblItem() { this.tblQuantities = new HashSet (); } public int ItemId { get; set; } public string PCode { get; set; } public string ItemName { get; set; } public decimal ItemPrice { get; set; } public Nullable CategoryId { get; set; } public int Active { get; set; } public virtual tblCategory tblCategory { get; set; } public virtual ICollection tblQuantities { get; set; } public partial class tblQuantity { public int QuantityId { get; set; } public int ItemId { get; set; } public int Quantity { get; set; } public virtual tblItem tblItem { get; set; } } public class bindItem { public int ItemId; public int? CategoryId; public string PCode; public string CategoryName; public int? QuantityId; public int Quantity; public string ItemName; public decimal ItemPrice; public int Active; }

Ali Benchaaban · Answer

Hello The error you're encountering suggests that the tblItems class does not have a property named QuantityId . This could be due to a typo or because the QuantityId property is not part of the tblItems entity in your database model. Assuming that QuantityId is a valid property in your database model you should check for the correct naming and casing. If the property is named differently or has a different casing you need to adjust your LINQ query accordingly. Could you give us your data model used within this code ? Regard BENCHAABAN Ali

Emmmanuel FIADUFE · Answer

Please the same error still pop u

Sachin Singh · Answer

Please try this var dataList = objRestaurantDBEntities.tblItems .Include(tblCategory) .Include(tblQuantity) .ToList(); var modifiedData = dataList .Where(x => x.ItemId == ItemId) .Select(d => new bindItem { ItemId = d.ItemId CategoryId = d.CategoryId PCode = d.PCode // Check if tblCategory and tblQuantities are not null before accessing their properties CategoryName = d.tblCategory?.CategoryName QuantityId = d.QuantityId Quantity = d.tblQuantity?.Quantity ItemName = d.ItemName ItemPrice = d.ItemPrice Active = d.Active }) .FirstOrDefault();

Emmmanuel FIADUFE · Answer

Please this is the error that came after applying your code

Sachin Singh · Answer

try to use this public JsonResult UpdateItem(int? ItemId) { var dataList = objRestaurantDBEntities.tblItems.Include(tblCategory).Include(tblQuantity).ToList(); var modifiedData = dataList.AsEnumerable().Where(x => x.ItemId == ItemId).Select(d => new bindItem { ItemId = d.ItemId CategoryId = d.CategoryId PCode = d.PCode CategoryName = d.tblCategory.select(x=>x.CategoryName).FirstOrDefault() QuantityId = d.QuantityId Quantity = d.tblQuantities.select(x=>x.Quantity).FirstOrDefault() ItemName = d.ItemName ItemPrice = d.ItemPrice Active = d.Active }).FirstOrDefault(); return Json(modifiedData JsonRequestBehavior.AllowGet); }