将IQueryable附加到IQueryable

Question

var q = _context.a
                .Include(x => x.status)
                .Include(x => x.type)
                .Where(x => x.status == 20);

var q1 = _context.a
                 .Include(x => x.status)
                 .Include(x => x.type)
                 .Where(x => x.status == 40);

我需要在Q的末尾有q1中的数据

Answer 1

试试这个：

var q = _context.a
                .Include(x => x.status)
                .Include(x => x.type)
                .Where(x => x.status == 20).AsQueryable();//ATTENTION AsQueryable()

var q1 = _context.a
                 .Include(x => x.status)
                 .Include(x => x.type)
                 .Where(x => x.status == 40).AsQueryable();//ATTENTION AsQueryable()

q = q.Concat(q1);

但是，您也可以将两个查询合并到一个查询中：

var q = _context.a
                .Include(x => x.status)
                .Include(x => x.type)
                .Where(x => x.status == 20 || x.status == 40)
                .OrderBy(x=>x.status);