select in Join experssion

Question

how to select all the columns from both query ( Join case) , see the example below :

var particiapants = from p in data.getAllParticipant() from l in dt.GetAll() where p.IdParticipant == l.IdParticipant select  p , l    ; ???

I want to display all the columns , and i dont want to do :

p.name , p.job .........

Shuvo Sarker · Answer

Example: var cus­tomers = new List { new Cus­tomer { Com­pa­nyId = “AC” Cus­tomerId = “Customer1” } new Cus­tomer { Com­pa­nyId = “not-AC” Cus­tomerId = “Customer2” } }; var user­Cus­tomers = new List { new User­Cus­tomer { Com­pa­nyId = “AC” Cus­tomerId = “Customer1” User = “not-admin” } new User­Cus­tomer { Com­pa­nyId = “AC” Cus­tomerId = “Customer1” User = “admin” } new User­Cus­tomer { Com­pa­nyId = “AC” Cus­tomerId = “Customer2” User = “not-admin” } new User­Cus­tomer { Com­pa­nyId = “AC” Cus­tomerId = “Customer2” User = “admin” } new User­Cus­tomer { Com­pa­nyId = “not-AC” Cus­tomerId = “Customer1” User = “not-admin” } new User­Cus­tomer { Com­pa­nyId = “not-AC” Cus­tomerId = “Customer1” User = “admin” } new User­Cus­tomer { Com­pa­nyId = “not-AC” Cus­tomerId = “Customer2” User = “not-admin” } new User­Cus­tomer { Com­pa­nyId = “not-AC” Cus­tomerId = “Customer2” User = “admin” } }; Linq Expression: var query = from c in cus­ tomers join uc in user­Cus­ tomers on new { c.CompanyId c.CustomerId } equals new { uc.CompanyId uc.CustomerId } where c.CompanyId == “AC” && uc.User == “admin“ select c;

Pooja Dixit · Answer

try it: var query = from e in Employee join d in Dept on e.deptno equals d.deptno select new {e.deptno d.deptno};

Tapan Patel · Answer

You need to use either join or union in this case (considering accurate design of your table). http://stackoverflow.com/questions/2767709/c-sharp-joins-where-with-linq-and-lambda

Bikesh Srivastava · Answer

Hi You can use like this.. varinnerJoinQuery= fromcategory in categories joinprod in productsoncategory.IDequalsprod.CategoryID select new {ProductName=prod.NameCategory=category.Name};

Ali Haider · Answer

oining on multiple columns in Linq to SQL is a little different. var query = from t1 in myTABLE1List // List join t2 in myTABLE1List on new { t1 . ColumnA  t1 . ColumnB } equals new { t2 . ColumnA  t2 . ColumnB } ... You have to take advantage of anonymous types and compose a type for the multiple columns you wish to compare against. This seems confusing at first but once you get acquainted with the way the SQL is composed from the expressions it will make a lot more sense under the covers this will generate the type of join you are looking for. EDIT Adding example for second join based on comment. var query = from t1 in myTABLE1List // List join t2 in myTABLE1List on new { A = t1 . ColumnA  B = t1 . ColumnB } equals new { A = t2 . ColumnA  B = t2 . ColumnB } join t3 in myTABLE1List on new { A = t2 . ColumnA  B = t2 . ColumnB } equals new { A = t3 . ColumnA  B = t3 . ColumnB } ...

pankaj rai · Answer

to use inner join ex: from d in table 1 join d1 in table 2 on d.id=d1.id select new (d.named1.name)

Ankur Goel · Answer

Use following LINQ expression: First data source: data . getAllParticipant () Second data source: dt . GetAll () Columns to join: IdParticipant IdParticipant Final Output: new {e e1} data . getAllParticipant () .Join( dt . GetAll ()  e => e. IdParticipant  e1 => e1. IdParticipant  (e e1) => new {e e1});