how sql query convert in Linq
I want to convert my sql query in to linq 
my query is :

    SELECT    Distinct(Invoice.InvoiceID),  Invoice.InvoiceDate, Invoice.InvoiceNo, Invoice.InvoiceAmount, Invoice.PaymentDays, Buyer.BuyerName, Supplier.SupplierName, Buyer.BuyerID, 
                          Payment.PendingAmount
    FROM         Buyer INNER JOIN
                          Invoice ON Buyer.BuyerID = Invoice.BuyerID INNER JOIN
                          Supplier ON Invoice.SupplierID = Supplier.SupplierID INNER JOIN
                          Payment ON Buyer.BuyerID = Payment.BuyerID AND Supplier.SupplierID = Payment.SupplierID
    WHERE    ((DATEDIFF(day, Invoice.InvoiceDate, GETDATE()) > Invoice.PaymentDays)  and Invoice.status= 'false') 
    Union(
    SELECT   Invoice.InvoiceID,  Invoice.InvoiceDate, Invoice.InvoiceNo, Invoice.InvoiceAmount, Invoice.PaymentDays, Buyer.BuyerName, Supplier.SupplierName, Buyer.BuyerID, 
                          Payment.PendingAmount
    FROM         Buyer INNER JOIN
                          Invoice ON Buyer.BuyerID = Invoice.BuyerID INNER JOIN
                          Supplier ON Invoice.SupplierID = Supplier.SupplierID INNER JOIN
                          Payment ON Buyer.BuyerID = Payment.BuyerID AND Supplier.SupplierID = Payment.SupplierID
    WHERE  Payment.PendingAmount > 0 )


any one please convert this query in to linq or how i write this query in Linq

thanks in advance



how sql query convert in Linq
===

I want to convert my sql query in to linq 
my query is :

    SELECT    Distinct(Invoice.InvoiceID),  Invoice.InvoiceDate, Invoice.InvoiceNo, Invoice.InvoiceAmount, Invoice.PaymentDays, Buyer.BuyerName, Supplier.SupplierName, Buyer.BuyerID, 
                          Payment.PendingAmount
    FROM         Buyer INNER JOIN
                          Invoice ON Buyer.BuyerID = Invoice.BuyerID INNER JOIN
                          Supplier ON Invoice.SupplierID = Supplier.SupplierID INNER JOIN
                          Payment ON Buyer.BuyerID = Payment.BuyerID AND Supplier.SupplierID = Payment.SupplierID
    WHERE    ((DATEDIFF(day, Invoice.InvoiceDate, GETDATE()) > Invoice.PaymentDays)  and Invoice.status= 'false') 
    Union(
    SELECT   Invoice.InvoiceID,  Invoice.InvoiceDate, Invoice.InvoiceNo, Invoice.InvoiceAmount, Invoice.PaymentDays, Buyer.BuyerName, Supplier.SupplierName, Buyer.BuyerID, 
                          Payment.PendingAmount
    FROM         Buyer INNER JOIN
                          Invoice ON Buyer.BuyerID = Invoice.BuyerID INNER JOIN
                          Supplier ON Invoice.SupplierID = Supplier.SupplierID INNER JOIN
                          Payment ON Buyer.BuyerID = Payment.BuyerID AND Supplier.SupplierID = Payment.SupplierID
    WHERE  Payment.PendingAmount > 0 )


any one please convert this query in to linq or how i write this query in Linq

thanks in advance


