How to Perform Inner Joins Using LINQ to SQL?

Use Linq to SQL to execute the internal connection

When using Linq to SQL, understanding the syntax of the internal connection is important for query and combination of data from multiple tables. Internal connections allow you to retrieve data that meets the specific conditions of cross -table.

Grammar Overview:

The basic syntax connected to the linq to sql in the ON clause in C#is as follows:

Let's break down the grammar:

from t1 in db.Table1
join t2 in db.Table2 on t1.field equals t2.field
select new {t1.field2, t2.field3}

<键> Keywords: initialization query.

<<> and
• : Alias ​​to be connected. from
<指>: Specify the first table to be connected.
• t1 <指>: Instructions will be executed internal connection. t2
<指>: Specify the second table to be connected.
• in db.Table1 <定>: Define the connection conditions to equate the specific fields in the two tables.
• <指>: Specify the fields to be retrieved from the connection table. join
• <示> Example query: db.Table2
• In order to demonstrate the grammar, let's create a query that retrieves all dealer contacts and its corresponding dealer information. on
• In the query here: select

<<> and

are the tables to be connected. <<> and

are fields used to connect conditions.

<句> The statement retrieval of dealers (

var dealercontacts = from contact in DealerContact
                     join dealer in Dealer on contact.DealerId equals dealer.ID
                     select contact;

).

By understanding the grammar connected in the Linq to SQL, you can effectively query and combine data from different tables, so as to retrieve the information you need.

The above is the detailed content of How to Perform Inner Joins Using LINQ to SQL?. For more information, please follow other related articles on the PHP Chinese website!