search

codeice / linqtoexcel

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

Error on Where clause in VB.NET only #21

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
When there's a where clause in a VB.Net Linq expression, an unexpected 
exception is thrown.

To reproduce, you only have to add a where clause in your VB example's 
project.

        Dim users = From x In book.Worksheet(Of User)()
                    Where x.FirstName = "John"
                    Select x

Thank you

Original issue reported on code.google.com by jesuissur@gmail.com on 3 May 2010 at 9:09

GoogleCodeExporter commented 8 years ago 
I think this is why:

http://www.re-motion.org/blogs/mix/archive/2010/02/18/.net-4.0-expression-trees-
extension-expressions.aspx

:(

Original comment by jesuissur@gmail.com on 4 May 2010 at 3:14

GoogleCodeExporter commented 8 years ago 
...and 
http://www.re-motion.org/blogs/mix/archive/2009/10/16/vb.net-specific-text-compa
rison-
in-linq-queries.aspx

Original comment by jesuissur@gmail.com on 4 May 2010 at 3:18

GoogleCodeExporter commented 8 years ago 
This is the temporary patch we've applied to support this case.

Original comment by jesuissur@gmail.com on 4 May 2010 at 4:36

Attachments:

GoogleCodeExporter commented 8 years ago 
Thanks for pointing out the issue and providing a patch. I will work on adding 
it to 
the source code within a week or two.

Original comment by paulyo...@gmail.com on 4 May 2010 at 6:22

GoogleCodeExporter commented 8 years ago 
I applied the patch in revision 67 
(http://code.google.com/p/linqtoexcel/source/detail?
r=67)

I also updated the vb example to include the fix. The latest download 
(LinqToExcel_1.3.70) has this patch applied.

Original comment by paulyo...@gmail.com on 12 May 2010 at 5:21