从C＃将GUID存储在MySQL中

从C＃将GUID存储在MySQL中

弄清楚了。就是这样 …

数据库架构

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