在Sqlite DB中存储System.Drawing.PointF的代码优先方法

using System.Data.SQLite;

// 创建Sqlite数据库连接
using (var connection = new SQLiteConnection("Data Source=mydatabase.db"))
{
    connection.Open();

    // 创建表
    using (var command = new SQLiteCommand("CREATE TABLE IF NOT EXISTS Points (X REAL, Y REAL)", connection))
    {
        command.ExecuteNonQuery();
    }

    // 存储PointF对象
    PointF point = new PointF(1.5f, 2.5f);
    using (var command = new SQLiteCommand("INSERT INTO Points (X, Y) VALUES (@x, @y)", connection))
    {
        command.Parameters.AddWithValue("@x", point.X);
        command.Parameters.AddWithValue("@y", point.Y);
        command.ExecuteNonQuery();
    }

    // 读取PointF对象
    using (var command = new SQLiteCommand("SELECT X, Y FROM Points", connection))
    {
        using (var reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                float x = reader.GetFloat(0);
                float y = reader.GetFloat(1);
                PointF storedPoint = new PointF(x, y);
                // 使用存储的PointF对象进行后续操作
            }
        }
    }
}