search

dotnet / efcore

EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
https://docs.microsoft.com/ef/
MIT License
13.8k stars 3.2k forks source link

Sqlite Spatial RevEng: Column SRID and Dimension not configured #13765

Open bricelam opened 6 years ago

bricelam commented 6 years ago

We need to query the SpatiaLite metadata tables in SqliteDatabaseModelFactory and add the annotations to DatabaseColumn objects.

bricelam commented 6 years ago 
SELECT c.*, g.coord_dimension, g.srid
FROM pragma_table_info($table) c
    LEFT JOIN geometry_columns g
        ON g.f_table_name = $table COLLATE NOCASE
            AND g.f_geometry_column = c.name COLLATE NOCASE;