Well;
- I am using Unsigned BigInt(40) Auto Increment column as primary key.
Whenever I try to query the table I am getting following exception:
"Object of type 'System.UInt64' cannot be converted to type 'System.Int64'."
When I dissected the code generated by Subsonic, it has declared the PK column as "long" instead of "ulong".
When I checked the Subsonic code for class:
SubSonic.SqlGeneration.Schema.MySqlSchema
following function has:
public override DbType GetDbType(string mySqlType)
case "bigint":
return DbType.Int64;
I think I will have to Here, is there any way to check for unsigned behavior?
Or should I make my PK signed?