After a bit of research, I think I may have found a bug. Not sure if it's in the IQ driver, or in LINQPad itself, but any comments or suggestions would be appreciated.
I have a script which will open up an Excel doc (using LinqtoExcel from NuGet), read it line by line and apply the data to a MySQL database. I have even reduced the script down to only update the one string field/value, so there are no issues with the object I'm reading/updating from the DB.
For some records, when my script runs SubmitChanges() I get:
"The binary operator Equal is not defined for the types 'System.Int32' and 'System.Object'.".
After a bit of research, it looks like this might be an error / bug in the IQ driver, possibly to do with nullable foreign keys or the way it tries to cast?