Data Binding error

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

Thank you team, it is working now 

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

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

Please the same error still pop u

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

Please this is the error that came after applying your code

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

        }