score:1

Accepted answer
public list<task> gettasks(int empid) 
{
    return ttask
        .where(t => ttaskview.where(v => v.id == empid).select(v => v.taskid).contains(t.id))
        .select(t => new task() 
        { 
            id = t.id, 
            actionableid = t.actionableid, 
            statusid = t.statusid, 
            typeid = t.typeid, 
            description = t.description 
        }).tolist();
}

score:1

var query =
    from tt in tasktable
    join tvt in taskviewtable on tt.id equals tvt.taskid into xs
    where xs.any(z => z.employeeid == empid)
    select tt;

Related Query

More Query from same tag