search

waleskim / linqtoexcel

Automatically exported from code.google.com/p/linqtoexcel
0 stars 0 forks source link

Where clause not supported #13

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Using your getting started example, I am not able to execute this query:

var people = from p in repo.Worksheet<Person>()
             where p.LastName == "Doe"
             select p;

I would have expected to be able to filter and join on these columns the 
person class.

I am usign the most current version.

I get this error:
Syntax error in query expression '[-1].LastNam]'.
 -524553244
 Microsoft JET Database Engine
 3075

Original issue reported on code.google.com by CourtJes...@gmail.com on 8 Feb 2010 at 4:53

GoogleCodeExporter commented 9 years ago 
CourtJesterBob,

Can you attach a zip file of your solution including the spreadsheet you are 
using so i 
can take a look at it.

Thanks,
Paul

Original comment by paulyo...@gmail.com on 9 Feb 2010 at 1:45

GoogleCodeExporter commented 9 years ago 
No reply within a month so closing the ticket

Original comment by paulyo...@gmail.com on 2 Mar 2010 at 3:30