Home > Asp.net MVC > Cross join in LINQ

Cross join in LINQ

Sachin Mahajan Asp.net MVC, LINQ, Miscellaneous, MS SQL Server 0

It is simple to implement to cross join in LINQ

Suppose i have 2 tables 1. Customers & 2.order

Now i want cross join on both tables

var q = from c in dataContext.Customers

             from o in dataContext.Orders

            select new {

                                     c.CustomerID,

                                   c.ContactName,

                                   a.OrderID,

                                  a.OrderDate

                           };

 

Thanks 🙂

This Article is TAGGED in , . BOOKMARK THE permalink.

Avatar photo
Sachin Mahajan

Related articles

Top Web Accessibility Tools

Top Web Accessibility tools which will help to determine whether your web

Add loading only one time in angular project.

1. Add following code in app.js  [crayon-6767be16c9953928766990/] 2. Add below code in admin/main controller [crayon-6767be16c995a167889672/] 3. add below

CROSS APPLY and OUTER APPLY in SQL Server

In this article, we are learning the use of the CROSS APPLY

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">