Skip to main content

MySQL

Store Guid as BINARY(16) in MySQL with NHibernate

Why use BINARY type to store a GUID ?

GUID is a 128-bit (16 bytes) integer number. 

In its canonical textual representation, GUID are represented as 32 hexadecimal digits, displayed in five groups separated by hyphens, in the form 8-4-4-4-12 for a total of 36 characters (32 hexadecimal characters and 4 hyphens).

For example: 79d266c1-ca54-4bc9-9b0e-4a988fa1b1dc

Backup MySQL Database by ASP.Net MVC Actions
You will discover how to add ASP.Net MVC Actions allowing to backup a MySQL database.
Handle MySQL data types with FluentMigrator
Extension methods to handle MySQL data types with FluentMigrator
Handle MySQL data types with NHibernate mapping by code
Some extension methods to handle MySQL data types with NHibernate mapping by code
Subscribe to MySQL