Advertisement
Guest User

koStanaEChovek

a guest
Nov 17th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.04 KB | None | 0 0
  1.  var users = context.Users
  2.                 .Where(u => u.ProductsSold.Count > 0 && u.ProductsSold.Any(a => a.BuyerId != null))
  3.                 .Select(a => new
  4.                 {
  5.                     FirstName = a.FirstName,
  6.                     LastName = a.LastName,
  7.                     SoldProducts = a.ProductsSold
  8.                     .Select(b => new
  9.                     {
  10.                         b.Name,
  11.                         Price = b.Price.ToString("F2"),
  12.                         b.Buyer.FirstName,
  13.                         b.Buyer.LastName
  14.                     })
  15.                 }).OrderBy(x=> x.LastName).ThenBy(x=> x.FirstName).ToList();
  16.             var resolver = new DefaultContractResolver()
  17.             {
  18.                 NamingStrategy = new CamelCaseNamingStrategy()
  19.             };
  20.             var sett = new JsonSerializerSettings();
  21.             sett.ContractResolver = resolver;
  22.             sett.Formatting = Formatting.Indented;
  23.  
  24.             var json = JsonConvert.SerializeObject(users, sett);
  25.             return json;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement