python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - nhibernate-mapping-by-code

NHibernate: How to insert C# [Guid] into MySQL [BINARY(16) DEFAULT (uuid_to_bin(uuid(),1))] column?

Environment: MySQL Server 8.0, .NET Core 3.1, MySql.Data 8.0.28, NHibernate 5.3.11 I have following table: CREATE TABLE `Master` ( `Row_Id` char(36) NOT NULL DEFAULT (uuid()), `Path` varchar(1000)...
test-img

PNG

mysql

nhibernate

uuid

nhibernate-mapping

nhibernate-mapping-by-code

Votes: 0

Answers: 2

Latest Answer

By default, MySql.Data will store a Guid as CHAR(36). You can use BINARY(16) instead by specifying Old Guids = True; in your connection string. From Connector/NET 8.0 Connection Options Reference: Th...
test-img

Bradley Grainger

Posts

Questions

Blogs

Jobs