Miguel, We should chat more when I'm in Melbourne on this. I still have a query as to why Isolated Storage + LINQ couldn't do all of the below? The only thing I can think of is maybe the way LINQ handles WHERE statements is from memory limited to one filter instead of multiple. Still multiple ISO's could solve the problem below?
The only reason I ask is I'm trying to separate the difference between a basic CRUD storage cookie vs an indexable mini SQL database which you can really begin to do some offline aggregated views on. From: [email protected] [mailto:[email protected]] On Behalf Of Miguel Madero Sent: Sunday, July 12, 2009 11: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]<mailto:[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]<mailto:[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]> > [mailto:[email protected]<mailto:[email protected]>] > On Behalf Of Miguel Madero > Sent: Sunday, July 12, 2009 10:49 PM > To: [email protected]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[email protected]> > Subscribe: > [email protected]<mailto:[email protected]> > Unsubscribe: > [email protected]<mailto:[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]<mailto:[email protected]> > Subscribe: > [email protected]<mailto:[email protected]> > Unsubscribe: > [email protected]<mailto:[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]<mailto:[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 > Other lists you might want to join: http://www.codify.com/lists > > ________________________________ > 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 > Other lists you might want to join: http://www.codify.com/lists -------------------------------------------------------------------------------- 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 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]<mailto:[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 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
