The value of OrderId keep showing zero on the console panel

Hello Emma,

Please review the below points:

• Make sure in database id is not zero. and try to add, update and delete records and check id not affected.
• Check database connection and table mappings are properly configured.

Check the below code Make sure the OrderId is mapped properly and retrieving proper table data.

public ActionResult getNewOrder()
{
   using (db = new ASPNETMASTERPOSTEntities())
   {
      var dataList = db.tblCustomers.Include("tblOrders");
      var modifiedData = dataList.AsEnumerable().SelectMany(x => x.tblOrders.Select(d => new OrderViewModel
         {
           CustomerId = x.CustomerId,
           CustomerName = d.tblCustomer.CustomerName,
           PhoneNo = d.tblCustomer.PhoneNo,
           OrderDate = d.tblCustomer.OrderDate,
           CategoryName = d.CategoryName,
           ProductName = d.ProductName,
           Quantity = d.Quantity,
           UnitPrice = d.UnitPrice,
           TotalAmount = d.TotalAmount,
           OrderId = d.OrderId //Make sure OrderId Field mapped and in UI not spelling change.
         })).ToList();
         return Json(modifiedData, JsonRequestBehavior.AllowGet);
   }
}

Thanks