Hey chris I will post to the Bug tracker as well but this is causing more of an issue than it should as having the Guids set as VARCHAR makes it so that we cannot save them as guids as Entity framework will mess up and the work around of creating a backend property while helping the save work with Entity Framework makes it so we cannot access the Guids directly in our LINQ calls making us have to change a lot of our code when the best change would be to replicate the GUID columns as UNIQUEIDENTIFIER....
I have found a workaround with a large amount of work in the entity framework object generation. I would still like to have a fix that involved the UNIQUEIDENTIFIERs being set as UNIQUEIDENTIFIERs in the SQLite db but as for now it is working. If someone is having this same issue and wants to see actual fix for this then please feel free to add a post to this and I will try to get you the information if I can still access it
So I have looked some things up and looked into the Symmetricds Project using Github, and it seems as though this limitation is from Java jdbc types and the fact that the sql type UNIQUEIDENTIFIER comes back as CHAR if that is the case would there be a possible way to get data to sync down with Symmetric but not create the table with that column? I need to have the GUID columns in the project but cannot get the SQLite DB to work with entity framework. if this is a known limitation that will never...
When my database is replicating from SQL to SQLite the GUID columns are getting changed to varchar, which is perfectly fine for SQLite as it does not really care what you have your columns set up to be. However Entity Framework does care about what your column is called and will only work if the GUID columns in the SQLite DB are set to be "UNIQUEIDENTIFIER"s is there some way to do this with symmetricds' replication? I thought about looking at the transforms but sadly it seems to be for data transforms...
When my database is replicating from SQL to SQLite the GUID columns are getting changed to varchar, which is perfectly fine for SQLite as it does not really care what you have your columns set up to be. However Entity Framework does care about what your column is called and will only work if the GUID columns in the SQLite DB are set to be "UNIQUEIDENTIFIER"s is there some way to do this with symmetricds' replication? I thought about looking at the transforms but sadly it seems to be for data transforms...