Jordan FYI - we are in the process of porting and implementing the NetTopologySuite to Silverlight which will give all the OGC Geo functions and data serialisation for communication with SQL 2008 geography types. Will be released as part of DeepEarth in about 2 months or hopefully quicker. Maybe TechEdAU is a good date to aim for....
From: [email protected] [mailto:[email protected]] On Behalf Of Jordan Knight Sent: Tuesday, 14 July 2009 10:54 AM To: [email protected] Subject: RE: SQL 'in' Silverlight ISO storage is quite easy to use in Silverlight. Once you have a little read and write class that takes a filename then the rest is history. You can request more space etc (default is 10mb in browser and 25 oob - might have changed in RTW?) I've saved entire movies in to ISO storage in tests and played them back when offline and OOB - it works a treat. And for the SQL debate, Like I use SQL on the server even anymore, its all about linq baby. For starters, its sooo easy to build linq to xml using the semi fluent XDocument (fully supported in SL). Secondly Silverlight has the DataContractSerializer class - meaning you can pretty much dump any graph in to ISO storage rather easily. You can almost bet the data you want to serialise came from some form of service request, so the classes are usually quite susceptible to serialisation. REST services are even better (like Flickr)... cache the XML results straight to ISO. All that said, SQL servers are obviously useful and I would never say no to having one available to me direct from client code. Oh and I'd reaaaaaaalllly love to see SQL Spatial available on the client too :P From: [email protected] [mailto:[email protected]] On Behalf Of Darren Neimke Sent: Monday, 13 July 2009 7:22 PM To: [email protected] Subject: Re: SQL 'in' Silverlight >> I still have a query as to why Isolated Storage + LINQ couldn't do all of the below Disclaimer: I haven't used Isolated Storage commercially since NET 2... Last I remember, Isolated Storage was a pig to work with in a reliable manner. It was limited by the amount of storage space that you had; it was difficult to properly ascertain the scope that you needed to work within; and it was unreliable that the data would be there next time your app started up. Question: Has all of this been addressed/fixed in subsequent NET releases? Kind Regards, Darren Neimke [email protected] mob: 0439 855 046 From: Scott <mailto:[email protected]> Barnes Sent: Monday, July 13, 2009 4:33 PM To: [email protected] Subject: RE: SQL 'in' Silverlight 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]> 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-silverlighthtml <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: <mailto:[email protected]> [email protected] Subscribe: <mailto:[email protected]> [email protected] Unsubscribe: <mailto:[email protected]> [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: <mailto:[email protected]> [email protected] Subscribe: <mailto:[email protected]> [email protected] Unsubscribe: <mailto:[email protected]> [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: <mailto:[email protected]> [email protected] Subscribe: <mailto:[email protected]> [email protected] Unsubscribe: <mailto:[email protected]> [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: <mailto:[email protected]> [email protected] Subscribe: <mailto:[email protected]> [email protected] Unsubscribe: <mailto:[email protected]> [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
