static void Main(string[] args)
{
//SQLitePCL.raw.SetProvider(new SQLitePCL.SQLite3Provider_e_sqlite3());
//SqliteConnection conn = new SqliteConnection("Data Source=e:\\Cadastre\\Cadastre33.sqlite");
//conn.Open();
//SqliteCommand comm = new SqliteCommand("select * from geo_parcelle", conn);
//var reader = comm.ExecuteReader();
//while(reader.Read())
//{
// var test = string.Empty;
// Console.WriteLine(reader.GetString(0));
//}
//using (GISContext ctx = new GISContext())
//{
// var list = ctx.GeoParcelle.Take(100).ToList();
// foreach (var item in list)
// {
// Console.WriteLine(item.Tex);
// }
//}
using (GISContext ctx = new GISContext())
{
Point referenceLocation = new Point(966598.0, 446583.0);
var polygon = (Geometry)referenceLocation.Buffer(100);
var entities = ctx.GeoParcelle.Where(c => c.Geom.Intersects(polygon));
foreach (var item in entities)
{
Console.WriteLine(item.Tex);
}
}
}
