Click here to Skip to main content
15,918,243 members
Please Sign up or sign in to vote.
4.00/5 (2 votes)
See more:
Hello,

This is my Normal Join Query
SQL
SELECT Folders.FolderName, FileMaster.FileName FROM FileMaster INNER JOIN Folders ON FileMaster.FolderId = Folders.Id AND FileMaster.UploadedBy = Folders.UserId

How to write in entity Frame work Like:-
C#
var query = from f in db.Folders
join fm in db.FileMasters on f.Id equals fm.FolderId
where fm.UploadedBy == SessionManager.UserId
select f;
Posted
Updated 28-Apr-14 22:28pm
v2

1 solution

C#
var query = from f in db.Folders
            join fm in db.FileMasters
            on new { f.Id, f.UserId }
            equals new { fm.FolderId, fm.UploadedBy }
            select f.FolderName + ";" + fm.Filename;


JAFC
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900