Get Data Two Table

Here you are doing wrong by adding propery into Inculde. Your UserMaster object alredy have the UserName so no need to include. Include is just used to get the data from other table which are in foraign key relation.

 

In short, what you expect the output from this statement?

//var PaidUser = _context.UserMaster

// .Include(u => u.UserName).Where(x => x.UserId == x.UserId).ToList();

Hi Sourabh,  May be you have add the where condition into include.

Can you shere your code? So I can give you better solution.

I have use this but i have face issue 

{"Lambda expression used inside Include is not valid."} 

Hi Sourabh.

There is a simple way to get data from two tables using .Include()

 I will join the tables with foraign key relation.

if you have navigation property in your table, include will work , otherwise you have no option other than join.