Get Data Two Table

Question

I'm New in Linq c# .How to get data from Two table using Include().Please send me solution

Sachin Singh · Answer

under include you can't specify property name rather you will have to specify DbSet Name, instead of userName user TableName(DbSet Name) var PaidUser = _context.UserMaster .Include(u => u.UserChild).Where(x => x.UserId == x.UserId).ToList();

Sachin Singh · Answer

if you have navigation property in your table, include will work , otherwise you have no option other than join. var soDTO = from so in db.SalesOrderHeaders .Include(s => s.SalesOrderItems) select so; or var SDto=db.SalesOrderHeaders.include(x=>x.SalesOrderItems).ToList();

Piyush Pansuriya · Answer

Hi Sourabh. There is a simple way to get data from two tables using .Include() var customer = context.Customers.Include(c => c.Invoices); I will join the tables with foraign key relation.

Piyush Pansuriya · Answer

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?

Guest User · Answer

//var PaidUser = _context.UserMaster // .Include(u => u.UserName).Where(x => x.UserId == x.UserId).ToList();

Piyush Pansuriya · Answer

Hi Sourabh, May be you have add the where condition into include. Can you shere your code? So I can give you better solution.

Guest User · Answer

I have use this but i have face issue {"Lambda expression used inside Include is not valid."}