Convert.ToData.Linq.Binary

[ivanlemus]

Do you know how to fix this error?

Error Compiling Expression: Error Compiling Expression: 'System.Convert' does not contain a definition for 'ToData'

It gets generated when trying to compile a query that uses a binary(8) field. Something like this:

join od1 in ASGWebDBContext.vCRM_Order__Details
on new { o1.Order__Id, op.Product_Id }
equals new { Order__Id = Convert.ToData.Linq.Binary(od1.Order_Id), od1.Product_Id } into od1_join

Thanks for all your help. Have a great day.
Ivan

[Mikhail Oumantsev]

Please send me dbml and designer.cs files.
Then I will be able to debug it.
[e-mail]

[dbml and designer files]

Mikhail,
Couldn't find a way to attach files to the case. Sent them files via email to [e-mail].
Thanks for all your help.
Ivan

[Mikhail Oumantsev]

There is a bug in Linqer.
It doesn't process Binary data type correctly.
In your sample conversion is not required I believe.
Try to replace the last line to
equals new {od1.Order_Id, od1.Product_Id }

[Thanks]

Thanks a lot.
That's what I've been doing. Any ideas when will it be fixed? (our db has a lot of those binary fields).
Thanks a lot again.
Cheers,
Ivan

[Mikhail Oumantsev]

I plan to fix in October.