Linq查询不起作用 [英] Linq Query not working

问题描述

大家好，
我正在使用linq查询使用Joins从多个表中检索数据
在视图页面中，当用户在任何字段上输入数据时，则必须显示该特定的所有resp数据
到这里为止，它运作良好而且很好
但是我的问题是
例如，当用户输入一个属于userid = 1的字段数据而第二个属于userid = 2的字段数据时，属于userid = 2的数据就会显示
确实应该显示无效的匹配
请任何人为我提供解决方案.
我在下面发布我的查询.不了解我在哪里出错以及在哪里修复

hi all,
I am using a linq query to retrieve data from multiple tables using joins
In the view page when the user enters data on any of the field then all the resp data of that particular must be displayed
Upto here,its working well and good
But my problem is
for e.g, when the user inputs one field data that belongs to userid=1 and second field data belonging to userid=2 then data belonging to userid=2 is getting displayed
Actully it should show invalid match
Please anyone provide me solution to this.
Am posting my query below.Not understanding where i went wrong and where to fix

var query = from s in dbContext.User_details
                               join j in dbContext.User_addresses on s.Userid equals j.Userid
                               join k in dbContext.Userworkdetails on j.Userid equals k.Userid
                               join l in dbContext.Useredudetails 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 query = from s in dbContext.User_details
                   join j in dbContext.User_addresses on s.Userid equals j.Userid
                   join k in dbContext.Userworkdetails on s.Userid equals k.Userid
                   join l in dbContext.Useredudetails on s.Userid equals l.Userid

这可能是您遇到的问题

THis may sole your problem

这篇关于Linq查询不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！