What is the equivalent of bigint in C

Question

What am I supposed to use when handling a value in C   which is bigint for an SQL  Server database

User · Answer

I think the equivalent is Int64

User · Answer

int in sql maps directly to int32 also know as a primitive type i e int in C  whereas   bigint in Sql Server maps directly to int64 also know as a primitive type i e long in C    An explicit conversion if biginteger to integer has been defined here

User · Answer

You can use long type or Int64

User · Answer

That corresponds to the long  or Int64   a 64-bit integer   Although if the number from the database 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  A stack overflow  Yay

User · Answer

int 64  or long Datatype is equivalent to BigInt

User · Answer

Int64 maps directly to BigInt   Source

User · Answer

I was handling a bigint datatype to be shown in a DataGridView and made it like this   something    int  Int64 data reader 0

User · Answer

I just had a script that returned the primary key of an insert and used a SELECT   identity  on my bigint primary key  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 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 on Stack Overflow    To quote a database administrator 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

User · Answer

For most of the cases it is long int64  in c

User · Answer

Use a long datatype

User · Answer

if you are using bigint in your database table  you can use Long in C

[c#] What is the equivalent of bigint in C#?

Examples related to c#

Examples related to .net

Examples related to sql-server

Examples related to bigint