LINQ查询中的编译错误 [英] Compilation Error in the linq query

问题描述

大家好，
当我在代码中使用以下查询时，出现编译错误，指出查询主体必须以select子句或group子句结尾"
有人可以帮我解决我语法上出错的地方吗?

这是我的查询

Hi all,
When i am using the following query in my code i am getting compilation error stating that "a query body must end with a select clause or group clause"
Could any one please help me out where i went wrong syntactically

This is my query

var query = from i in dbContext.User_details
                                join j in dbContext.User_addresses on i.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
                            

        if (!string.IsNullOrEmpty(FirstName))
             query = query.Where(u => u.FirstName == FirstName);

             if (!string.IsNullOrEmpty(LastName))
             query = query.Where(u => u.LastName == LastName); 

        

        var results = from r in query.ToList()
                      select new
                                  {
                                      
                                     
                                      Firstname = i.Firstname,
                                      lastname = i.Lastname
                                  }.ToArray();

谢谢

Thanks

推荐答案

请尝试这个

Please try this

var results = from i in dbContext.User_details
        join j in dbContext.User_addresses on i.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
        where(u => u.FirstName == 
                !string.IsNullOrEmpty(FirstName) ? Firstname : LastName)
        select new {
                 Firstname = i.Firstname,
                 Lastname = i.Lastname
        }.ToArray();

可能会有帮助

It may be helpful

这篇关于LINQ查询中的编译错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！