コード例 #1
0
        private static void DoTest(Action <SQLiteConnection> action)
        {
            Assert.IsNotNull(action);

            string fileName = $"{Guid.NewGuid().ToString()}.gpkg";

            File.Copy("empty.gpkg", fileName);
            string cs = $"Data Source={fileName};Version=3;";

            using (var conn = new SQLiteConnection(cs))
            {
                conn.Open();

                conn.EnableExtensions(true);
                conn.LoadExtension(SpatialiteLoader.FindExtension());
                Debug.WriteLine("'mod_spatialite' extension loaded");

                action(conn);
            }
        }
コード例 #2
0
        protected override void CreateTestStore()
        {
            if (File.Exists(Name))
            {
                File.Delete(Name);
            }

            using (var conn = new SQLiteConnection($"Data Source=\"{Name}\""))
            {
                conn.Open();
                conn.EnableExtensions(true);
                conn.LoadExtension(SpatialiteLoader.FindExtension());
                using (var cmd = conn.CreateCommand())
                {
                    cmd.CommandText =
                        "CREATE TABLE \"nts_io_geopackage\" (id int primary key, wkt text, the_geom blob);";
                    cmd.ExecuteNonQuery();
                }
            }
        }