score:3

Accepted answer

the linq query can be as follows.

try
    {

        using (myentities myentity = new myentities())
        {
            var result = (from s in carriers
                         join ent in coreent on s.coreentid equals ent.coreentid                       
                         where s.needstransfer == true
                         select s).single(); 
            //using single()/firstordefault() depends on what is the type of other objects. if it shows error to you than you can remove it
        }
        return result;
    }
    catch (exception ex)
    {
        return result;
    }

Related Query

More Query from same tag