How to rewrite this SQL statement to LINQ 2 SQL ?

Posted by Shyju on Stack Overflow See other posts from Stack Overflow or by Shyju
Published on 2010-06-16T14:44:11Z Indexed on 2010/06/16 14:52 UTC
Read the original article Hit count: 361

Filed under:
|

How can i convert this SQL query to its equivalent LINQ 2 SQL statement for VB.NET?

 SELECT COUNT(*) AS 'Qty', 
 IV200.itemnmbr,
 IV200.locncode,
 IV200.bin,
 CAST(IV112.Quantity as int) as 'Qty2' ,
 'parentBIN' = isnull(MDS.parentBIN,iv112.bin) 
   From IV00200 IV200 (nolock)
     inner join  IV00112 IV112 (nolock)
                      on  iv200.itemnmbr = iv112.itemnmbr 
                      and IV200.bin = IV112.bin
                      and iv200.locncode = iv112.locncode 
     left outer join  mds_container mds (nolock) 
                      on isnull(mds.locncode,'nul') = isnull(iv112.locncode,'nul') 
                      and isnull(mds.containerbin,'nul') = isnull(iv112.bin,'nul') 
                      where IV200.bin = 'MU7I336A80'
    group by IV200.itemnmbr, 
             IV200.locncode, 
             IV200.bin,
             IV112.Quantity,
             isnull(MDS.parentBIN,iv112.bin) 
    order by IV200.itemnmbr 

© Stack Overflow or respective owner

Related posts about sql

Related posts about linq-to-sql