Join in LINQ and Entity Framework

c# entity-framework linq

Question

In SQL I to get the distinct statement, I used join to get it as below

select distinct 
    col1 
from 
    table1 a 
inner join 
    table2 b on a.code = b.vcode

How can the same be implemented in linq over Entity Framework?

Please suggest me.

1
10
11/4/2015 4:24:25 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

var result = (from a in table1
              join b in table2 on a.code equals b.vcode
              select a.col1).Distinct();
14
11/4/2015 2:10:38 PM

Popular Answer

You can also use method syntax:

var query = table1.Join(table2,
                        a => a.code,
                        b => b.vcode,
                        (a,b) => a.col1)
                   .Distinct();
w.b

Related Questions

Cross edmx "join" between Linq to Entities and Entity Framework

I have two entities, each from a different database and therefore different edmx files. There is, however, an infered relationship between them....Foo... has many ...Bar...s for example....What's the easiest way to do this join in the EntityFramework, with fewest database calls?...Thanks.
entity-framework linq-to-entities
asked by NikolaiDante

Linq to Entities vs. Linq to SQL vs. Entity Framework

I read a lot of articles about how to work with a database in WPF .Net 4 application. As I understood, the main two technologies are:...Linq to SQL (L2S)...Entity Framework (EF)...but sometimes I also can see mention of Linq to Entities (L2E) technology, but can't find clear explanation what difference between EF and L2E....So, my question is: Does...
ado.net entity-framework linq-to-entities linq-to-sql
asked by Mike B.

Outer left Entity Framework through Linq To Entities using Where Clause

I have read all the posts related to implementing the equivalent of a LEFT OUTER JOIN in Linq to Entities (.NET 3.5) when using the Entity Framework, but have yet to find a solution to the following problem....Given two tables, represented by the objects below:... public class Foo { public int FooId; // primary key public st...
entity-framework left-join linq-to-entities outer-join
asked by EulerOperator

Should I use lambda or LINQ for a multi-table join in Entity Framework 4.1?

I'm new to the Entity Framework and I'm trying to convert a multi table join to use the Entity framework. The original SQL looked something like this...JOIN tab_NewsCommunities S1 ON S1.News_ID = tab_News.NewsID inner join tab_communities com on S1.Community_ID = com.Community_ID and com.RecordStatus_ID = 2 JOIN tab_Communities c ON S1.Community_I...
asp.net-mvc entity-framework lambda linq sql
asked by NullReference

The LINQ expression node type 'Invoke' is not supported in the entity framework's LINQ to Entities.

can anyone help me out in solving my issue. I am using the code given below:...public IEnumerable<InvoiceHeader> Getdata(Expression<Func<InvoiceHeader, bool>> predicate) { return AccountsContext.InvoiceHeaders.Include("Company").Include("Currency") .Include("BusinessPartnerRoleList").Include("DocumentType") .Where(predicate); } ...
c# entity-framework expression linq predicate
asked by zaheer abbas

LEFT JOIN or RIGHT JOIN using LINQ Entity-Framework

Trying joining using Linq. What should i use ? Left join or right join?... APPLICANT TABLE PROFILE TABLE APPLICANT_ID|profile_id|Applicant_Name| |profile_id|Applicant_Name 1 | NULL | RAY HEAVENS | | 1 | MARK LAPID 2 | NULL | BEN TULFO | | 2 | SUPER MAN 3 | 1...
asp.net asp.net-mvc c# entity-framework linq
asked by Enrique Gil

Entity Framework LINQ joining 5 tables on multiple columns (impossible?!)

Please see image: ...I am trying to create a LINQ query that combines 5 different tables on 1 to 3 different columns. I am basically taking the examples of 2 tables and repeating the join sections for tables 3 through 5. ...UPDATE: how do I get the following LINQ query to work?????... var match = (from t1 in context.cKNA1 join...
asp.net-mvc asp.net-mvc-4 entity-framework join linq-to-entities
asked by TryingReallyHardToDoBetter

Entity Framework left join on multiple tables creates inner join instead

I'm trying to create a query that joins four tables together, only one of which is guaranteed to exist. I've been successful creating left joins in EF before, but never with more than one join. Here is the query:... var details = (from planInfo in context.PlanInfo join templateRec in context.ProductTemplates o...
c# entity-framework entity-framework-6 linq
asked by kindwarrior

Entity Framework forcing Inner Join when Left Join DefaultIfEmpty() Syntax used

I'm trying to create a fairly complex query with the Oracle EF framework (Oracle.ManagedDataAccess.EntityFramework nuget package, version 12.1.2400) with numerous left joins, utilizing the .DefaultIfEmpty() syntax:...from i in dbHR.Identities join p in dbHR.Personals on new { key1 = i.ID, key2 = true, key3 = true } ...
c# entity-framework-6 join linq-to-entities oracle
asked by James

Only parameterless constructors and initializers are supported in LINQ to Entities in linq join with tuples

I am trying to join two table and create a tuples list but getting error as 'Only parameterless constructors and initializers are supported in LINQ to Entities'...var list = ( from a in db.CategoryRatings join c in db.OverallPerformanceByCategories on a.CategoryRatingId equals c.CategoryRatingId where c.ReviewId == review.Review...
c# entity-framework entity-framework-6 linq tuples
asked by Rocky

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow