mysql 存guid类型_从C#在MySQL中存储GUID

弄清楚了.这是如何做 …

数据库架构

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));

}

}

}