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); }

Data Binding error

Sanjeeb Lenka