sql to linq RSS

• • Reply
  

  studio7t7

  Member

  81 Points

  152 Posts

  sql to linq

  May 08, 2012 10:21 AM|LINK

  Hi,

  I have written a sql statement I need to convert to this in to LINQ.I am not really familiar with LINQ.

  SELECT (SELECT ISNULL(SUM(canning.intQuantity), 0) FROM tblCanning AS canning WHERE canning.strProdNo = 0073059001) -
   (SELECT ISNULL(SUM(tx.intQuantity), 0) FROM SS_tblTransaction AS tx WHERE tx.strProductNo = 0073059001) AS remain

  Can anybody help me

  Thanks
  
  

• • Reply
  

  pierrefrc

  Participant

  947 Points

  201 Posts

  Re: sql to linq

  May 08, 2012 12:13 PM|LINK

  Hi

  you can use:

  var result = (context.tblCannings.Where(c=>c.strProdNo == 73059001).Sum(c => (c.intQuantity.HasValue ? c.intQuantity.Value : 0))) - (context.SS_tblTransactions.Where(t=>t.strProductNo == 73059001).Sum(t => (t.intQuantity.HasValue ? t.intQuantity.Value : 0)));

  I hope this help

  Kindly mark this post as "Answer", if it helped you.
  • Edited by pierrefrc on May 08, 2012 12:14 PM
  • Marked as answer by decker dong - msft on May 14, 2012 01:55 AM