Post
Ask Question

Linq code in WebApi to return JSON result from multiple / Complex Data model

I have three models in my application. Customer can have single or multiple Orders and each order can contains single or multiple Products.

Write a Linq code to get Order details based on order number and return the result as JSON. 
 
Models: 

Customer Model:
  1. public class Customer  
  2. {  
  3.     public string CustomerName { get; set; }  
  4.     public int CustomerNumber { get; set; }  
  5.     public List<Order> Orders { get; set; }  
  6. }  
Order Model:
  1. public class Order  
  2. {  
  3.     public int OrderNumber { get; set; }  
  4.     public DateTime OrderDate{ get; set; }  
  5.     public List<Product> ProductList { get; set; }  
  6. }  
Product Model:
  1. public class Product  
  2. {  
  3.     public string ProductNumber { get; set; }  
  4.     public string Name { get; set; }  
  5.     public int Quantity { get; set; }  
  6.     public string Description { get; set; }  
  7.     public double Price { get; set; }  
  8.     public string ProductGroup { get; set; }  
  9.     public string OrderLineNumber { get; set; }  
  10.           
  11. }  
Linq Code to select Order Details based on Order number: 
  1. //Filter Result based on Order Number: LINQ query to find Order  
  2. var result = from customer in customersList  
  3.           from order in customer.Orders  
  4.           where order.OrderNumber.Equals(orderNumber)  
  5.           select new { customer.CustomerName, customer.CustomerNumber,order };  
 
Return Order Details as JSON Result:
  1. //Return JSON result for Order information  
  2. return new JsonResult { Data = result };