LINQ Query for fetching data from Multiple Tables

Question

I am working in Asp.Net 4.0 C#-- MVC-3. I have one problem and don't know how to solve. I have 4 tables and want to fetch data from that tables with LINQ.

TABLES

1) Project_Master

    Field Names :   

    project_id (pk)
    project_name
    company_id (FK with company_master)
    company_category_id (FK with Company_Category_master)
    project_status_id (FK with Project_Status_Master)

2)Company_Master

   Field Names :

   company_id
   company_name
   company_category_id (FK with Company_Category_Master)

3) Company_Category_Master

   Field Names :

   Company_Category_Id
   Company_Category_Name

4) Project_Status_Master

   Field Name :

   Project_Status_Id
   Project_Status_Name

Below are the fields I need to fetch..(using LINQ Query)

Company_Name
Total completed project using status id(1)=complete (where staus 1 means completed)
Total Project
Company_category_name

So, how can I fetch data with linq query??

Thanks in advance...

Check this question: stackoverflow.com/questions/5207382/… — user1277789
– user1277789, Commented Mar 30, 2012 at 6:08
Do you know what a JOIN is? There is also a join keyword for linq. — Stephan
– Stephan, Commented Mar 30, 2012 at 9:05
Stan, with linq please also use tags for linq provider (linq to sql, entity framework, ...) — Gert Arnold
– Gert Arnold, Commented Mar 31, 2012 at 19:28

pjumble · Accepted Answer · 2012-03-30 08:43:12Z

3

Try the below example:

(From lse In Me.Leases, nty In Me.Entities, psg In Me.ProductionStages, lsg In LeaseStages _
        Where lse.LeaseName = leaseName _
        Select lse, lsg, nty, psg).Single

or you can use below example too:

var employeesQuery = from populationTable in db.Populations
join personTable in db.Persons on populationTable.Guid equals personTable.PopulationGuid
join employeeTable in db.Employees on personTable.Guid equals employeeTable.PersonGuid
select new { populationTable, personTable, employeeTable};

edited Mar 30, 2012 at 8:43

pjumble

17k6 gold badges45 silver badges52 bronze badges

answered Mar 30, 2012 at 6:09

SeeSharp

1791 gold badge4 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gert Arnold Over a year ago

You can also use? You should. The first example is a Cartesian product.

Collectives™ on Stack Overflow

LINQ Query for fetching data from Multiple Tables

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related