var q = from s in dbContext.T1 join j in dbContext.T2 on s.Userid equals j.Userid join k in dbContext.T3 on j.Userid equals k.Userid join l in dbContext.T4 on k.Userid equals l.Userid select new { l.Userid,l.City, s.Firstname, k.Company, l.College, j.State, s.Lastname, j.Country }; if (!string.IsNullOrEmpty(FirstName)) query = query.Where(s => s.Firstname == FirstName); if (!string.IsNullOrEmpty(City)) query = query.Where(l => l.City == City); if (!string.IsNullOrEmpty(State)) query = query.Where(j => j.State == State); if (!string.IsNullOrEmpty(Country)) query = query.Where(j => j.Country == Country); if (!string.IsNullOrEmpty(LastName)) query = query.Where(s => s.Lastname == LastName); if (!string.IsNullOrEmpty(Company)) query = query.Where(k => k.Company == Company); if (!string.IsNullOrEmpty(College)) query = query.Where(l => l.College == College); var results = (from r in query.ToList() select new { Ft = r.Firstname, Lt = r.Lastname, Ct = r.City, Co = r.Country, Com = r.Company, Col = r.College, St = r.State, Id=r.Userid }).ToArray();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)