Union All for Entity framework using Lambda

Question

I’m having problems in a query using lambda and Entity Framework in C#. When transforming a simple sql query into lambda works perfectly, as example below.

SQL query

    public DataSet ListarRecebidos()
    {
        ch.Conectar();
        string sql = "";
        sql = "SELECT * FROM SCEBD019 WHERE CLIMOVI>='"+VCLIMOVI+"' AND CLIPAGO <='"+VCLIPAGO+"'";
        SqlDataAdapter da = new SqlDataAdapter(sql, ch.cn);
        DataSet ds = new DataSet();
        da.Fill(ds);
        ch.Desconectar();
        return ds;
    }

Consulta Lambda

public object ListarContasRecebidas(DateTime dataMovi, DateTime dataPagamento) => context.sCEBD019s.Where(c => c.CLIMOVI >= dataMovi && c.CLIPAGO <= dataPagamento).Select(c => new { c.PRONOTA, c.CLIPAGO, c.CLIRAZA, c.CLIVPAG, c.PAGCODI, c.PAGNOME, c.CARNOME, c.CLIMOVI, c.CLIPROC, c.CLIVENC, c.CLIREFE, c.CLICHEQ, c.CLIBANC, c.CLIOBSE, c.FUNCODI, c.CLIDUPL}).AsNoTracking().ToList();

Now, a sql query using the UNION ALL I can’t do lambda at all. I’ve searched several forums, but I haven’t seen anyone using lambda, only LINQ.

If anyone has any tips or suggestions I really appreciate it, because I’ve wasted a lot of time on it. It doesn’t even have to be answer or code ready, only a north is enough.

Below is the sql query using the UNION ALL

public DataSet ListarTodos()
    {
        ch.Conectar();
        string sql = "";
        sql = "SELECT * FROM SCEBD018 where SCEBD018.CLICODI='"+VCLICODI+"' AND SCEBD018.CLIMOVI>='"+VCLIMOVI+"' " +
            "AND SCEBD018.CLIVENC<='"+VCLIVENC+"' UNION ALL (SELECT * FROM SCEBD019 WHERE " +
            "SCEBD019.CLICODI = '"+VCLICODI+"' AND SCEBD019.CLIMOVI >= '"+VCLIMOVI+"' AND " +
            "SCEBD019.CLIVENC <= '"+VCLIVENC+"')";
        SqlDataAdapter da = new SqlDataAdapter(sql, ch.cn);
        DataSet ds = new DataSet();
        da.Fill(ds);
        ch.Desconectar();
        return ds;
    }