I am encountering an error in an ES program on Mono 1.9.1. I receive a cast exception when I attempted to use a property derived from a bigint column (from SQL 2005). After significant research and some pointers from Mike Griffin (in another forum), I believe the problem is related to the TDS version. I found an old, related bug report on the mono forums... Do you know how to set the TDS version or of a workaround for this issue?
"[Mono-devel-list] Patch for Mono returns bigint as decimal in SqlClient
Kornél Pál kornelpal at hotmail.com
Fri May 13 18:30:39 EDT 2005
Hi,
The bug is reported very often:
http://bugzilla.ximian.com/show_bug.cgi?id=53169
http://bugzilla.ximian.com/show_bug.cgi?id=62390
http://bugzilla.ximian.com/show_bug.cgi?id=69768
http://bugzilla.ximian.com/show_bug.cgi?id=74856
This means that this should be corrected.
The problem is that Mono uses TDS 7.0 and it returns bigint as
decimal(19,0).
This could be solved by implementing a TDS 8.0 client but it requires
time...:)"