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?

score 444 · Accepted Answer · edited Jul 08 '15 at 16:37

444

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!

edited Jul 08 '15 at 16:37

Peter Mortensen

30,738
21
105
131

answered Jan 21 '10 at 22:44

Patrick Karcher

22,995
5
52
66

122

Sure it's not integer overflow? – luqui Aug 09 '12 at 16:38
11

Good reference for more data types: http://msdn.microsoft.com/en-us/library/system.data.sqldbtype.aspx – JustBeingHelpful Aug 17 '12 at 14:47
6

in C#, `long` is not capitalized. – Shawn Kovac Mar 16 '14 at 16:23

score 79 · Answer 2 · edited Apr 24 '14 at 20:05

79

Int64 maps directly to BigInt.

Source

edited Apr 24 '14 at 20:05

sshow

8,820
4
51
82

answered Jan 21 '10 at 22:44

ChaosPandion

77,506
18
119
157

4

is long other name for Int64 / – Asad Jan 21 '10 at 22:52
17

Yes. The `long` keyword is an alias for `System.Int64`. – Anon. Jan 21 '10 at 22:52

score 14 · Answer 3 · edited Jul 09 '20 at 04:47

14

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.

edited Jul 09 '20 at 04:47

Pang

9,564
146
81
122

answered Sep 20 '10 at 19:10

Robb Sadler

157
1
2

Thanks for the numeric tip.. just helped me out big time! – jpshook Oct 26 '11 at 20:41
10

You got a cast error because SCOPE_IDENTITY and @@IDENTITY return NUMERIC(38, 0), not because your BigInt PK does not fit into a C# Int64. In other words, BigInt _is_ the same as Int64, but BigInt values returned through SCOPE_IDENTITY or @@IDENTITY may be up-converted to NUMERIC(38, 0). – Dan Hermann Jan 05 '14 at 13:21
Thanks Dan. FYI, still happening with SQL Azure (RTM) - 12.0.2000.8 & .NET v 4.5 – Gunnar Sep 11 '15 at 17:31
1

Surprised to see no comment to Dan's correction about the type for SQL Server identity values to just use the following on the DB side: SELECT CAST(@@IDENTITY as BIGINT) as IdentityINT64 – dmarietta Dec 15 '22 at 18:34

score 9 · Answer 4 · answered Jan 21 '10 at 22:44

9

Use a long datatype.

answered Jan 21 '10 at 22:44

Otávio Décio

73,752
17
161
228

score 8 · Answer 5 · answered Jul 08 '15 at 17:59

8

You can use long type or Int64

answered Jul 08 '15 at 17:59

score 4 · Answer 6 · answered Jan 21 '10 at 22:44

4

I think the equivalent is Int64

answered Jan 21 '10 at 22:44

John Boker

82,559
17
97
130

score 2 · Answer 7 · edited Apr 12 '19 at 17:46

2

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

edited Apr 12 '19 at 17:46

Er Mayank

1,017
2
16
39

answered Jun 14 '16 at 07:18

Asim Khan

572
6
34

score -1 · Answer 8 · answered Sep 01 '21 at 15:28

-1

I managed to convert the (bigint) value returned from the DB using Convert.ToInt64.

ie

var Id = Convert.ToInt64(identityAsTable.Rows[0].Field<object>(0));

answered Sep 01 '21 at 15:28

Jeff Moretti

613
5
6

score -2 · Answer 9 · answered Feb 04 '20 at 10:01

-2

For most of the cases it is long(int64) in c#

answered Feb 04 '20 at 10:01

Rajeev Sirohi

75
1
3

1

This seems to be just a repeat of the existing answers. – Pang Dec 30 '20 at 03:52

score -3 · Answer 10 · answered May 18 '20 at 14:26

-3

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

answered May 18 '20 at 14:26

Abbasibh

15
1

1

This seems to be just a repeat of the existing answers. – Pang Dec 30 '20 at 03:52

score -3 · Answer 11 · answered Feb 22 '21 at 09:11

-3

int(64) or long Datatype is equivalent to BigInt.

answered Feb 22 '21 at 09:11

Tanvir Mahtab

1
1

This seems to be just a repeat of the existing answers. – Pang Oct 28 '21 at 08:52

score -5 · Answer 12 · edited Aug 11 '14 at 15:03

-5

I was handling a bigint datatype to be shown in a DataGridView and made it like this

something = (int)(Int64)data_reader[0];

edited Aug 11 '14 at 15:03

p.campbell

98,673
67
256
322

answered Aug 11 '14 at 14:57

Rúben

1

What is the equivalent of bigint in C#?

12 Answers12

Linked

Related