How to use unsigned int / long types with Entity Framework?

by

Update Feb 2021

Apparently EF Core now supports ulong — see @JimbobTheSailor’s answer below.

Older Entity Framework versions:

Turns out that Entity Framework does not support unsigned data types. For uint columns, one could just store the value in a signed data type with a larger range (that is, a long). What about ulong columns? The common solution couldn’t work for me because there is no EF-supported signed data type that can hold a ulong without overflowing.

After a bit of thinking, I figured out a simple solution to this problem: just store the data in the supported long type and cast it to ulong when accessed. You might be thinking: “But wait, ulong’s max value > long’s max value!” You can still store the bytes of a ulong in a long and then cast it back to ulong when you need it, since both have 8 bytes. This will allow you to save a ulong variable to a database through EF.

// Avoid modifying the following directly.
// Used as a database column only.
public long __MyVariable { get; set; }

// Access/modify this variable instead.
// Tell EF not to map this field to a Db table
[NotMapped]
public ulong MyVariable
{
    get
    {
        unchecked
        {
            return (ulong)__MyVariable;
        }
    }

    set
    {
        unchecked
        {
            __MyVariable = (long)value;
        }
    }
}

The casting is unchecked to prevent overflow exceptions.

Hope this helps someone.

More Related Contents:

  1. Using MySQL with Entity Framework [closed]
  2. Can’t Create Entity Data Model – using MySql and EF6
  3. Entity Framework wizard crashes on MySQL
  4. Can’t use a MySQL connection for entity framework 6
  5. Dynamic MySQL database connection for Entity Framework 6
  6. mySQL DataSource on Visual Studio 2012
  7. No Entity Framework provider found for ‘MySql.Data.MySqlClient’ ADO.NET provider
  8. How to store Emoji Character in MySQL Database
  9. MySQL: Quick breakdown of the types of joins [duplicate]
  10. Any way to select without causing locking in MySQL?
  11. Log all queries in mysql
  12. Truncate all tables in a MySQL database in one command?
  13. Cast from VARCHAR to INT – MySQL
  14. How to convert result table to JSON array in MySQL
  15. Adding multiple columns AFTER a specific column in MySQL
  16. MySQL varchar index length
  17. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  18. Ruby on Rails 3 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ on OSX
  19. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  20. Terminating idle mysql connections
  21. MySQL – Fetching lowest value
  22. How to alias a field or column in MySQL?
  23. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  24. Where does MySQL store database files on Windows and what are the names of the files?
  25. When is a timestamp (auto) updated?
  26. Should I normalize my DB or not?
  27. ALTER TABLE ADD COLUMN takes a long time
  28. Creating MYSQL Procedure in Laravel 4 Migrations
  29. MySQL: Computed Column
  30. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

Leave a Comment