<div>
That's (almost) equal to an INNER JOIN, so maybe:<br />
<br />
&nbsp;Select distinct t.* FROM table t inner join tableb b where t.id = b.id
</div>


That's (almost) equal to an INNER JOIN, so maybe:

 Select distinct t.* FROM table t inner join tableb b where t.id = b.id

<div>
<div class="content wysiwyg-content">
Is there a linq equivalent for &quot;IN&quot; operator in Select * FROM table where Id IN (Select Id FROM tableB)?
</div>
</div>


Is there a linq equivalent for "IN" operator in Select * FROM table where Id IN (Select Id FROM tableB)?

linq equivalent for &quot;IN&quot; operator in Select * FROM table where Id IN (Select Id FROM tableB)

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

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).

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.

LINQ Query

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

linq equivalent for &quot;IN&quot; operator in Select * FROM table where Id IN (Select Id FROM tableB)

linq equivalent for "IN" operator in Select * FROM table where Id IN (Select Id FROM tableB)