Joining multiple tables in .net

Question

Hi All I am struggling to get this working in my applicaiton using C# MVC .Net framework 4.5 Any help is greatly appriciated. myProjects projects = db.myProjects.Find(id); Once the above line is executed I need to join to 3 other tables for looking up values to get the discription of below attributes. ProjectStatus ProgramName Priority. Can you please help? Regards Anand

Nilesh Shah · Answer

either you can look at the LINQ join examples here https://msdn.microsoft.com/en-us/library/bb311040.aspx or you can post your code with table definition so that someone can help But I suggest to not use joins on more than 2 tables in LINQ as it will affect performance Write a SP and move your code in SP get the result from SP and use it in C# - this is the best approach