Call Method from Linq query.

Question

Hello Everybody,

I am using Linq query and call method Like..

oPwd = objDecryptor.DecryptIt((c.Password.ToString())

it will return null value.

Means this will not working.

how I Resolve this.

Thanks..

var q =
    from s in db.User
    join c in db.EmailAccount on s.UserId equals c.UserId
    join d in db.POPSettings 
        on c.PopSettingId equals d.POPSettingsId
    where s.UserId == UserId && c.EmailId == EmailId
    select new
    {
        oUserId = s.UserId,
        oUserName = s.Name,
        oEmailId = c.EmailId,
        oEmailAccId = c.EmailAccId,
        oPwd = objDecryptor.DecryptIt(c.Password.ToString()),
        oServerName = d.ServerName,
        oServerAdd = d.ServerAddress,
        oPOPSettingId = d.POPSettingsId,
    };

Answer 1

This has nothing about Linq query. you need to debug method objDecryptor.DecryptIt

Answer 2

If that is LINQ-to-SQL or EF, you'll need to break it into steps (as it can't execute that at the DB). For example:

    var q = 
        from s in db.User
        join c in db.EmailAccount on s.UserId equals c.UserId
        join d in db.POPSettings on c.PopSettingId equals d.POPSettingsId
        where s.UserId == UserId && c.EmailId == EmailId
        select new
        {
            oUserId = s.UserId,
            oUserName = s.Name,
            oEmailId = c.EmailId,
            oEmailAccId = c.EmailAccId,
            oPwd = c.Password,
            oServerName = d.ServerName,
            oServerAdd = d.ServerAddress,
            oPOPSettingId = d.POPSettingsId,
        };

then use AsEnumerable() to break "composition" against the back-end store:

var query2 = from row in q.AsEnumerable()
             select new
             {
                row.oUserId,
                row.oUserName,
                row.oEmailId,
                row.oEmailAccId,
                oPwd = objDecryptor.DecryptIt(row.oPwd),
                row.oServerName,
                row.oServerAdd,
                row.oPOPSettingId
            };