Devart Forums

Code: Select all

    public class Table1
    {
        public long Id { get; set; }

        public string Value { get; set; }

    }

    public class Table2
    {
        public long Id { get; set; }

        public string Value { get; set; }

        public string Table1Id { get; set; }
    }
 

Code: Select all

var dbContext = new AppDbContext();

var query = from table2 in dbContext.Set<Table2>().AsQueryable()
            join table1 in dbContext.Set<Table1>().AsQueryable()  on table2.Table1Id equals table1.Id.ToString() into table1Joind
            from table1 in table1Joind.DefaultIfEmpty()
			select new
            {
                Table1Value=table1.Value,
                Table2Value=table2.Value,
            };
			
var result = await query.ToListAsync();