The SQLite entity designer always maps the Integer PrimaryKey AutoIncrement columns as int64. However, I would like to be able to re-use some POCO objects that are generated from a SQLServer database that uses simple integer primary keys (these map to int types in the POCO model). Is it possible to either get the ADO.Net adapter to convert the values of the ids from int64 back to standard int32s or do something similar in the EDMX file?
Thanks for any assistance.