video player test

...

Ecommerce Site. See here

Extreme join and group By

var ssgroupAndjoin    =          (from invoice in _context.Invoices
                          from contact in _context.Contacts
                          where contact.ContactID == id && invoice.ContactID == id
                          join invoiceDetails in _context.InvoiceDetails on invoice.InvoiceID equals invoiceDetails.InvoiceID
                          join product in _context.Products on invoiceDetails.ProductID equals product.productID
                          join supplier in _context.Suppliers on product.SupplierID equals supplier.SuppID                       
                           select new
                          {
                              invoice,
                              invoiceDetails,
                              contact,
                              product,
                              supplier
                          } into invoices
                          group invoices by invoices.invoice.InvoiceID into invoceLists
                          select new
                          {                           
                              invoceLists
                          });



foreach(var result in results)
{
        foreach(var item in result.invoceLists)
       {
             invoiceResults.Add(new
             {
                  invoiceId = item.invoice.InvoiceID

             });
        }

}



#SSTEAM
we are making brotherhood
Sponsored By: Foring