locked
Synching Geometry data using Local Database cache RRS feed

  • Question

  • Hello,

    I am trying to create a local database cache for a table with sql geography column. However the designer in VS 2008 doesnt give me option to add this table for local database cache.

    I would really appreciate if someone can help me with in setting this up. I would also like to know how to synchronize this table in both directions.

    Thanks

    Apurva
    • Moved by Max Wang_1983 Wednesday, April 20, 2011 10:17 PM Forum consolidation (From:SyncFx - Technical Discussion [ReadOnly])
    Friday, October 23, 2009 3:52 PM

Answers

  • the geo data is not supported on the SQL CE db and this is the reason you cannot add tables as such in.

    what you can do is to write your own code to take care of them. in the selectIncmentaleInsert/update queries, you can convert it to binary (max ) to get the data sync-ed to the SqlCe DB.

    thanks
    Yunwen
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, November 25, 2009 9:56 PM
    Moderator