locked
odata + sync framework ctp 4.0 RRS feed

  • Question

  • I had to implement odata+sync but my data not connect to ms sql. instead getting data from ms sql, it had to use the existing system to get data by call some function such as GetData(string querystring).

    how I implement the odata + sync on top of my existing system?

    Is there any sample code for custom data providers?

    Wednesday, February 9, 2011 10:20 PM

Answers

  • Hi Khanh Luan,

    To use the components that are in the 4.0 CTP, you need to have a SQL Server backend. We don't have the ability to plug in custom providers at this point. To use a non-sql server backend, you will have to implement the full server side logic and emit odata+sync protocol responses to client requests. This would be non-trivial to implement.

    Hope this answers your question.


    SDE, Sync Framework - http://www.giyer.com
    • Proposed as answer by Ganeshan Wednesday, February 16, 2011 10:07 PM
    • Marked as answer by Nina H Thursday, June 23, 2011 6:00 PM
    Wednesday, February 16, 2011 10:07 PM

All replies

  • I am no authority on this framework, as you, i am trying to learn the best i can, but if i am not mistaken the idea of this particular incarnation of the framework was to take all the sync logic and heavy lifting needed to perform sync operations and make all of that reside on the service.

    Removing this burden from  the clients makes  for very think clients, and enabling sync on a variety of scenarios, this video from Nina Hu explains it all http://videoaz.microsoftpdc.com/vod/downloads/vod/CS57_NinaHu/CS57_NinaHu_PDC_MP4_High_1280x720_2500k.mp4

    So knowing that, your service must have a Sql Server Database behind and those need to be provisioned for sync, as for permitting the clients NOT to have any smarts about sync.

    Those "smarts are stored procedures triggers on sql server and DLL on the service" so your proxy scenario is probably not possible or quite difficult but take it with a grain o salt.

    cheers.

     

    Wednesday, February 16, 2011 8:45 AM
  • Hi Khanh Luan,

    To use the components that are in the 4.0 CTP, you need to have a SQL Server backend. We don't have the ability to plug in custom providers at this point. To use a non-sql server backend, you will have to implement the full server side logic and emit odata+sync protocol responses to client requests. This would be non-trivial to implement.

    Hope this answers your question.


    SDE, Sync Framework - http://www.giyer.com
    • Proposed as answer by Ganeshan Wednesday, February 16, 2011 10:07 PM
    • Marked as answer by Nina H Thursday, June 23, 2011 6:00 PM
    Wednesday, February 16, 2011 10:07 PM
  •  Hi Khanh Luan,

    I am also experimetning with Microsoft Sync Framework 4.0. I came accross one site where a guy as implimented a custom provider for Sync framework which works with PostGreSql. I hope it helps you get some idea.

    Title: Making Microsoft Sync Framework work with PostgreSql

    Link: http://www.infoq.com/articles/Microsoft-Sync-Framework-PostgreSql

     

    Regards,

    rashidnoorani.blogspot.com

    Monday, March 21, 2011 1:39 PM