linq combined column search

I want to search records which two column combination equals to the parameter, why it does not work?

public RDCheck SearchByUserPlusId(string uid)
        {
            RDCheckDataContext dc = new RDCheckDataContext(_connString);
            var query = (from r in dc.RDChecks
                         where (r.login + r.id).Equals(uid)
                         select r).FirstOrDefault();
            return query;
        }

for example, one record in table is id:4/login:test So I pass parameter uid=test4 but it r开发者_JS百科eturns null, why?

Use ToString() before the concatenation

public RDCheck SearchByUserPlusId(string uid)
{
       RDCheckDataContext dc = new RDCheckDataContext(_connString);
       var query = (from r in dc.RDChecks
                    where (r.login.ToString() + r.id.ToString()).Equals(uid)
                    select r).FirstOrDefault();
       return query;
}