What is the equivalent SQL Server type for the C# long type?

Question

I'd like to know what the equivalent SQL Server type is for a long in C#.

Answered here, along with the equivalent for other types: http://stackoverflow.com/questions/1440620/which-sql-server-data-type-best-represents-a-double-in-c/1440631#1440631 — David, Jan 07 '13 at 13:42
I don't see why this was worth a downvote. it's a legitimate question. — David, Jan 07 '13 at 14:30
yeh, I saw that thread but failed to see the simple fact that long is an int64 ... Anyways fair enough - its been asked and answered b4 ... — JanivZ, Jan 07 '13 at 14:34

score 135 · Accepted Answer · answered Jan 07 '13 at 13:43

135

The mapping table is clear - BIGINT is the equivalent of Int64 (which is long in C#).

answered Jan 07 '13 at 13:43

Oded

score 24 · Answer 2 · edited Jun 14 '19 at 20:50

24

The equivalent type is bigint which is a 64-bit numeric type.

It fits numbers in the range from -2^63 to 2^63-1 which is the same as the C# long type.

edited Jun 14 '19 at 20:50

plr108

answered Jan 07 '13 at 13:42

2 Answers2