This is a migrated thread and some comments may be shown as answers.

OCA Silvelight App and SQL/SQLite DB

1 Answer 46 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Garry
Top achievements
Rank 1
Garry asked on 06 Sep 2011, 01:30 AM
Hey support guys,
I'm starting work on a new Silverlight 4/5 app that will need an offline DB store. I'm going to use OpenAccess as my ORM, but I have some questions first. 

I've played with the offline demo, http://demos.telerik.com/orm/objectContainer/objContainerDemo.aspx, and I have watched the video on the ObjectContainer, http://demos.telerik.com/orm/objectContainer/objContainerVideos/Using-Object-Container-with-Web-Services.aspx, but instead of using a stream to serialize out to a XML file can you come up with a sample that uses SL, WCF, and a local database store such as SQLLite, SterlingDB, or RavenDB?

I'm trying to figure out how on loss of network connectivity with the live WCF service I can switch connection strings at runtime to store and retrieve from the local database store and then synch those changes with the live DB when it comes back on line using the Changeset capabilities of OpenAccess.

Thanks in advance,
Garry

1 Answer, 1 is accepted

Sort by
0
Ivailo
Telerik team
answered on 08 Sep 2011, 04:05 PM
Hi Garry,

Generally, I recommend you to use our SDK samples since they are showing the latest features and changes in OpenAccess ORM, along with the best practices for it's usage.

Based on your scenario, I think the best samples you can refer to are those within the category "WCF" in the SDK. They are end-to-end typical applications that expose data through a WCF Data Services or Plain Services, along with the UI layers consuming them.

As per the database, although all the examples in our SDK are SQL Server based, they would be applicable for SQLite as well. However, SterlingDB and RavenDB are not supported by OpenAccess ORM.

Do not hesitate to let us know if you have further questions.


Best wishes,
Ivailo
the Telerik team

Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>

Tags
General Discussions
Asked by
Garry
Top achievements
Rank 1
Answers by
Ivailo
Telerik team
Share this question
or