<div>
do u mean something like this<br />

<pre><code id="code-20-40189845-1">var d = from emp in Employee 
             join dep in Department on dep,Id = emp.DepartmentId
             select dep;</code></pre>
<br />
<br />
here select dep would return all column in department
</div>


do u mean something like this


var d = from emp in Employee 
             join dep in Department on dep,Id = emp.DepartmentId
             select dep;



here select dep would return all column in department

<div>
What do you mean by &quot;whole raw?&quot;
</div>


<div>
Gautam You have joined just two tables I need code how to do this on multiple table.<br />
<br />
Kaufmed whole raw means:: &nbsp;i need to return data from 5 tables . 2 tables have 20+ columns and i need all columns value . so don't want to specify each column like TableC.Column1, TableD.Column2 for those tables rather want to return like ( TableC.allcolumns, tableD.AllColums, TableA.Column1, Table2. Column2) from other 3 tables i want to return only 4/5 columns from each table.
</div>


Gautam You have joined just two tables I need code how to do this on multiple table.

Kaufmed whole raw means::  i need to return data from 5 tables . 2 tables have 20+ columns and i need all columns value . so don't want to specify each column like TableC.Column1, TableD.Column2 for those tables rather want to return like ( TableC.allcolumns, tableD.AllColums, TableA.Column1, Table2. Column2) from other 3 tables i want to return only 4/5 columns from each table.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have 5 tables . <br />
Table A with Person ID as Primary Key<br />
Table B with Service ID as Primary key <br />
Table C Service ID as FK<br />
Table D Service ID as FK<br />
<br />
Table E Service ID as FK<br />
<br />
Now when user search by Service ID I need to join 5 tables to send all data . Is there any option to pass whole raw from particular table without mentioning all fields ?
</div>
</div>


Hi,

I have 5 tables . 
Table A with Person ID as Primary Key
Table B with Service ID as Primary key 
Table C Service ID as FK
Table D Service ID as FK

Table E Service ID as FK

Now when user search by Service ID I need to join 5 tables to send all data . Is there any option to pass whole raw from particular table without mentioning all fields ?

Need help Joining 5 Tables in LinQ

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although ports exist for Java, PHP, JavaScript and ActionScript. LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources.