What is the alternative of bigint in c#

Question

Hi, what I am suppose to use when handling a value in c#, which is bigint SQLSERVER DB ?

Thanks

Answer 1

Int64 maps directly to BigInt.

Source

Answer 2

Use a long datatype.

Answer 3

That corresponds to the Long (or Int64), a 64 bit integer.

Although if the number from the db happens to be small enough, and you accidentally use an Int32 etc., you'll be fine. But the Int64 will definitely hold it.

And the error you get if you use something smaller and the full size is needed? Stack Overflow!!! Yay!!!!!!!

Answer 4

I think the equivalent is Int64

Answer 5

I just had a script that returned the primary key of an insert and used a

SELECT @@identity

on my bigint PK and I get a cast error using long - that was why I started this search. The correct answer at least in my case is that the type returned by that select is a NUMERIC which equates to a decimal type. Using a long will cause a cast exception.

This is one reason to check your answers in more than one Google search (or even StackOverflow!).

To quote a DBA who helped me out: "... BigInt is not the same as INT64 no matter how much they look alike. Part of the reason is that SQL will frequently convert Int/BigInt to Numeric as part of the normal processing. So when it goes to OLE or .NET the required conversion is NUMERIC to INT.

We don't often notice since the printed value looks the same."

HTH someone...

Peace...