how to arrange data properly using linq

thank you for your quick reply dear i have tried your linq  join logic earlier but you are not returning any thing as you are binding variables under  select new so eventually candidateData variable should be casted to ToList(); 

 var data = (from a in context.GetModel()
                        join acad in acadContext.GetModel() on a.CanId equals acad.CanId
                        where a.Id == id
                        select new
                        {
                            can = a,
                            academics = acad
                        });

here is your approach and its returning nothing and here is mine but issue still exist in it

 var data = (from a in context.GetModel()
                        join acad in acadContext.GetModel() on a.CanId equals acad.CanId
                        where a.Id == id
                        select new
                        {
                            can = a,
                            academics = acad
                        }).ToList();

when i debug my code it gives me data and academics have sames list of data as my DB.

i have to give academics to my model.academcs now this this is the main issue ican't do this.

please help me if you can solve it  i also don't want to use these lines of code

Hi Umair,

Your current approach of fetching data table by table is functional, it’s not optimal in terms of performance. You can load the data through either Eager loading (if using Entity Framework) using.Include() or joins in LINQ are better approaches for fetching related data in a single query, this approach is also reducing the number of database calls. 

//Eager Loading:
var candidate = db.Candidates
    .Include(c => c.Academics)  
    .Include(c => c.Tbl1)       
	.Include(c => c.Tbl2)       
	.Include(c => c.Tbl3)       
	.FirstOrDefault(c => c.CanId == someId);

//Joins in LINQ:
var candidateData = from c in db.Candidates
                    join a in db.Academics on c.CanId equals a.CanId
                    join t1 in db.Tbl1 on c.CanId equals t1.CanId
                    join t2 in db.Tbl2 on c.CanId equals t2.CanId
                    where c.CanId == someId
                    select new {
                        Candidate = c,
                        Academics = a,
                        Tbl1 = t1,
                        Tbl2 = t2
                    };