I have a SP with a parameter as BigInt Datatype. I am trying to pass the value as “BigInteger.Parse(StringValue)” and end up with error as “Execute Non Query: No mapping exists from object type System.Numerics.BigInteger to a known managed provider native type”. Can anyone help me to resolve this error?
Try passing int64 type please.
I tried using Int64 and got “Execute Non Query: Error converting data type varchar to bigint.” error
Could you please let me know what are all the types you tried pls ?
we would suggest following:
- Share with us which DBMS is in use
- which datatype is configured within the data table schema for this column