This is a migrated thread and some comments may be shown as answers.

LINQ statement shows as error

2 Answers 52 Views

Code Analysis

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Kevin F asked on 27 Apr 2010, 10:22 PM

I get a "C#: This expression is not a valid statement" with the attached code. The first error that shows up is "C#: Missing ';'" The red line starts right after the join keyword.

                    var leinAssocResults =         
                            from l         
                            in (leinDb.tblLEIN_LEINs)         
                            join lar in (leinDb.tblLEIN_Associates.Where(leinAssocPredicate))         
                            on l.LEINNUM equals lar.LEINNUM         
                            orderby l.Sort_Num descending         
                            select new         
                            {         
                                lar.LNAME,         
                                lar.FNAME,         
                                lar.LEINNUM,         
                                lar.DOB,         
                                l.DISSEMINAT,         
                                lar.TYPE,         
                                lar.SEX,         
                                lar.RACE         
                            };         

Any ideas?

Thanks!

2 Answers, 1 is accepted

answered on 27 Apr 2010, 11:26 PM

Found the problem. JustCode did not like the parens; below works fine.

                    var leinAssocResults =          
                            from l          
                            in leinDb.tblLEIN_LEINs         
                            join lar in leinDb.tblLEIN_Associates.Where(leinAssocPredicate)         
                            on l.LEINNUM equals lar.LEINNUM          
                            orderby l.Sort_Num descending          
                            select new          
                            {          
                                lar.LNAME,          
                                lar.FNAME,          
                                lar.LEINNUM,          
                                lar.DOB,          
                                l.DISSEMINAT,          
                                lar.TYPE,          
                                lar.SEX,          
                                lar.RACE          
                            };          