弄清楚了。就是这样 …
数据库架构
CREATE TABLE `test` (
`id` BINARY(16) NOT NULL,
PRIMARY KEY (`id`)
)
码
string connectionString = string.Format("Server={0};Database={1};Uid={2};pwd={3}", "server", "database", "user", "password");
Guid orgId = Guid.NewGuid();
Guid fromDb = Guid.Empty;
using (MysqLConnection conn = new MysqLConnection(connectionString))
{
conn.open();
using (MysqLCommand cmd = new MysqLCommand("INSERT INTO test (id) VALUES (?id)", conn))
{
cmd.Parameters.Add("id", MysqLDbType.Binary).Value = orgId.ToByteArray();
cmd.ExecuteNonQuery();
}
using (MysqLCommand cmd = new MysqLCommand("SELECT id FROM test", conn))
{
using (MysqLDataReader r = cmd.ExecuteReader())
{
r.Read();
fromDb = new Guid((byte[])r.GetValue(0));
}
}
}