Page 1 of 1

Unsiged Big Int Mapped To Decimal

Posted: Tue 21 Jun 2016 20:03
by remonlucassen
Hi,

Why is a MYSQL Unsigned Big Int which should be unsigned 64 bit integer mapped to a .NET Decimal (128 Bits) instead of a .NET Unsigned Long (UINT64) which indicates it's the same datatype.

I have to use a type converter to go from MySQL 64Bit Unsigned integer to a .NET 64 Bit Unsigned Integer.

It makes no sense to me

Can you explain ?

Re: Unsiged Big Int Mapped To Decimal

Posted: Wed 22 Jun 2016 07:54
by Shalex
1. Are you using a plain ADO.NET (MySqlDataReader / MySqlDataTable) or an ORM framework (Entity Framework / NHibernate / LinqConnect / Telerik)?
2. If it is ORM, what is your ORM designer (e.g.: Entity Developer)?

Re: Unsiged Big Int Mapped To Decimal

Posted: Wed 22 Jun 2016 20:06
by remonlucassen

Re: Unsiged Big Int Mapped To Decimal

Posted: Mon 27 Jun 2016 18:06
by Shalex
There is no unsigned .NET data types support in EF1 / EF4 / EF5 / EF6.

In case of plain ADO.NET, the usage of unsigned data types is avoided to make code be CLS compliant.

Re: Unsiged Big Int Mapped To Decimal

Posted: Wed 29 Jun 2016 08:07
by remonlucassen
Ok

sounds reasonable thanx for clarifying.