Immediate availability of data in SQLCE RRS feed

  • Question

  • I have a download only sync table called tblCustomers for which the PK is integer. I have an application that allows users to insert data into tblCustomers. Since it is download only, i have to wait for the sync to dowload the changes to my CE store. But i need the data immediately in the UI to be able to edit and process further. How can i achieve it ?

    Design restriction is that i cannot change the syncdirection for the table. I tried to insert the record using the PK that gets saved in the central store but the data gets duplicated in the local CE store and the next time i query, i get duplicates.

    Any help is appreciated.

    Saturday, February 11, 2012 10:31 AM