tags:

views:

95

answers:

0

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?