As join as I add in a Lambda .Join I am getting problem with my linq lambda .Where(..
.Where(z => z.Inact_ind == "N" && z.Wwid != null)
That is fine UNTIL I add in .Join above it.
eg
.Join(Rpm_scrty_emp_info, z => z.Wwid, ei => ei.Wwid, (z, ei) => new{z,ei})
linq query
(Linqpad , so Rpm_scrty_rpm_usrs is essentially the same as dbcontext dbset)
var queryAllUsers = Rpm_scrty_rpm_usrs
.Join(Rpm_scrty_emp_info, z => z.Wwid, ei => ei.Wwid, (z, ei) => new{z,ei})
.Where(z => z.Inact_ind == "N" && z.Wwid != null)
.AsEnumerable()
.Select(z => new rpm_scrty_rpm_usr()
{
usr_id = z.Usr_id,
usr_lnm = z.Usr_lnm,
usr_pwd = z.Usr_pwd,
usr_fnm = z.Usr_fnm,
wwid = z.Wwid,
apprvr_wwid = z.Apprvr_wwid,
chg_dtm = z.Chg_dtm,
chg_usr_id = z.Chg_usr_id,
dflt_ste_id = z.Dflt_ste_id,
cre_dtm = z.Cre_dtm,
cre_usr_id = z.Cre_usr_id,
lst_pwd_chg_dtm = z.Lst_pwd_chg_dtm,
lst_accs_dtm = z.Lst_accs_dtm,
email_id = z.Email_id,
inact_ind = z.Inact_ind,
salt = z.Salt,
tel = z.Tel
//});
})
.ToList();
Poco class
public class rpm_scrty_rpm_usr
{
public string usr_id { get; set; }
public string usr_fnm { get; set; }
public string usr_lnm { get; set; }
public string usr_pwd { get; set; }
public string email_id { get; set; }
public string wwid { get; set; }
public string tel { get; set; }
public int dflt_ste_id { get; set; }
public DateTime? lst_pwd_chg_dtm { get; set; }
public DateTime? lst_accs_dtm { get; set; }
public string apprvr_wwid { get; set; }
public string inact_ind { get; set; }
public string cre_usr_id { get; set; }
public DateTime? cre_dtm { get; set; }
public string chg_usr_id { get; set; }
public DateTime? chg_dtm { get; set; }
public string salt { get; set; }
}
