I'm a sql guy, but in all these scenarios I think I would find it far easier to serialize / deserialize the object graph, given I would have most likely received the data across the wire in that format.
From: Miguel Madero [mailto:[email protected]] Sent: Monday, 13 July 2009 4:57 PM To: [email protected] Subject: Re: SQL 'in' Silverlight There're several scenarios, but some of the ones that come to my mind are: 1. The typicial not reliable connection like using your cellphone as a modem or a mobile broadband. I don't want my whole app to crash, I'd love to be able to click save and even start registering a new client, even close the browser go gome and submit my changes the next morning. RIA Services has a good solution for these problem. 2. The working offline scenarios. Google reader is a perfect example, it's using Gears to allow me to download the content and read offline, when I get back online it would replicate the state of my read items. 3. Caching data. Most LOB apps have a big amount of static data, mainly used for reference, like countries, zip codes and other specific to your busines domain. Having this data always available in the client can avoid round trips allowing you to scale, providing a better user experience, and also abstracting your devs from async calls. On Mon, Jul 13, 2009 at 4:38 PM, Barry Beattie <[email protected]> wrote: yeah, I'm a bit unsure of the usage. if it was a WPF or Adobe AIR app, with reconnect sync of data then I'd understand and appreciate. but in-browser Silverlight... still runs in a browser... which means being online .... the only thing I can think of is something I've done with Flex and LocalSharedObjects ... basically a "super cookie" for remembering data when next using the app. very, very curious of the use cases (methinks something interesting to learn here) On Mon, Jul 13, 2009 at 4:10 PM, Scott Barnes<[email protected]> wrote: > I do have one question, what specifically are you looking to store in > offline storage? In that poor man's LINQ to SQL via isolated storage can get > you by but it's got limitations as all would most likely know but as to what > you store and why, that's got our curiosity into over-drive. > > > > > > From: [email protected] > [mailto:[email protected]] On Behalf Of Miguel Madero > Sent: Sunday, July 12, 2009 10:49 PM > To: [email protected] > Subject: Re: SQL 'in' Silverlight > > > > Yesterday on twitter Miguel de Icaza and others were talking about this, > they were mentioning something about migrating SQL Lite line by line to > managed code. > > On Mon, Jul 13, 2009 at 1:47 PM, Joseph Cooney <[email protected]> wrote: > > I wouldn't be surprised if we saw a managed DB talking to isolated storage > in a future version of silverlight. > > Joseph > > On Mon, Jul 13, 2009 at 8:31 AM, Craig Dunn <[email protected]> wrote: > > Hey everyone - played around a bit with porting an old c# version of HSql > (from java) to Silverlight. I'm not sure of the utility but it was an > interesting exercise - still figuring out the kinks in isolatedstorage... > seems to work fine 'in memory' though. > > post: http://conceptdev.blogspot.com/2009/07/sql-in-silverlight.html > play: http://conceptdevelopment.net/Silverlight2/SharpSql02/default.html > > the 'default' SQL includes some basic data & queries - you can Execute the > entire block, or select text to execute just like MgmtStudio... (just don't > habitually hit F5 like was doing during testing!). the UI is pretty basic, > so you must scroll with the bars. > > ________________________________ > > Support procedure: https://www.codify.com/lists/support > List address: [email protected] > Subscribe: [email protected] > Unsubscribe: [email protected] > List FAQ: http://www.codify.com/lists/ozsilverlight > Other lists you might want to join: http://www.codify.com/lists > > > > ________________________________ > > Support procedure: https://www.codify.com/lists/support > List address: [email protected] > Subscribe: [email protected] > Unsubscribe: [email protected] > List FAQ: http://www.codify.com/lists/ozsilverlight > Other lists you might want to join: http://www.codify.com/lists > > > -- > Miguel A. Madero Reyes > www.miguelmadero.com <http://www.miguelmadero.com/> (blog) > [email protected] > > ________________________________ > > Support procedure: https://www.codify.com/lists/support > List address: [email protected] > Subscribe: [email protected] > Unsubscribe: [email protected] > List FAQ: http://www.codify.com/lists/ozsilverlight > Other lists you might want to join: http://www.codify.com/lists > > ________________________________ > Support procedure: https://www.codify.com/lists/support > List address: [email protected] > Subscribe: [email protected] > Unsubscribe: [email protected] > List FAQ: http://www.codify.com/lists/ozsilverlight > Other lists you might want to join: http://www.codify.com/lists ------------------------------------------------------------------------ -------- Support procedure: https://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/ozsilverlight Other lists you might want to join: http://www.codify.com/lists -- Miguel A. Madero Reyes www.miguelmadero.com (blog) [email protected] ________________________________ Support procedure: https://www.codify.com/lists/support List address: [email protected] <mailto:[email protected]> Subscribe: [email protected] <mailto:[email protected]> Unsubscribe: [email protected] <mailto:[email protected]> List FAQ: http://www.codify.com/lists/ozsilverlight <http://www.codify.com/lists/ozsilverlight> Other lists you might want to join: http://www.codify.com/lists <http://www.codify.com/lists> -------------------------------------------------------------------------------- Support procedure: https://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/ozsilverlight Other lists you might want to join: http://www.codify.com/lists
