Method 'System.Object CompareObjectEqual(System.Object, System.Object, Boolean)' has no supported translation to SQL.

http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/72d3dc56-ad25-439e-a7cc-22d6dcf94f0a

http://66.129.67.4/p/1309841/2576463.aspx

I was getting the above error on calling db.TableName.Single(Function(p) p.ColumnName= valueObj)

Turned out that I had to Convert the valueObj to the respective datatype because valueObj was retrieved as a result of a similar linq expression and was declared as

Dim valueObj= db.TableName0.Single(Function(p) p.ColumnName= valueObj0)