[Edited 19 July 2010]
Example is now build with Siaqodb 2.0 for latest WindowsPhone7 BETA release
[End Edit]
A few days ago Microsoft launched Development Platform for WindowsPhone 7. Development can be done on 2 main Frameworks:
-Silverlight
-XNA Framework
Main interest for Siaqodb is Silverlight ofcourse and I start reading to see what version of Silverlight and if support LINQ etc. So what I find first thing that make me said Siaqodb will not gonna work is: “LINQ query providers for custom data sources are not supported in Silverlight for Windows Phone.” Damn…I was thinking is because on .NET Compact Framework that is not supported too, and especially because System.Linq.Expressions namespace is not supported. But further reading surprise: System.Linq.Expressions I don’t see in unsupported list, but I see that IQueryable, Queryable and IQueryProvider not supported. Since nothing about Expressions namespace is said and since Siaqodb use to make LINQ provider redefining technique of Where, Join, Select extension methods of IEnumerable, I start download all developer tools for WindowsPhone and after installation and running and with small adjustments , voila:
Some things to notice about Silverlight on Windows Phone 7 platform:
-Isolated storage on Windows Phone does not enforce quotas to restrict the size of isolated storage for Silverlight-based applications. The default quota size of 1 MB does not apply. (source MSDN)
-SiaqodbSilver.dll can be used/shared by both types of Applications Silverlight based(in browser or out of browser) and Silverlight for Windows Phone 7
Happy storing data!
Great job on getting siaqodb to work on wp7.
quick question, Since WP7 doesn’t support custom Linq providers, I’m guessing that Linq provider over there is the normal CLR collection LINQ provider? So once I query a table the siaqodb loads the whole table to memory and flips it?
– Justin Angel
Posted by Justin Angel
Link | March 19th, 2010 at 10:10 pm
Thanks Justin for comment,:IEnumerable like is described here: http://www.devsource.com/c/a/Languages/Extension-Methods-LINQ/ it uses internal ISqoQuery Where extension method. So Siaqodb not use LINQ to Objects collection, it really read only necessary objects values and create instances only if necessary…
As I said inside post Siaqodb not use IQueryable and IQueryProvider to make LINQ provider. But it use another technique, redefining Where,Select etc extension methods of ISqoQuery
So when you do a Where in LINQ instead of call of Where method from IEnumerable
Posted by siaqodb_admin
Link | March 20th, 2010 at 4:56 am
To mention also that not all LINQ statements can be optimized that is known, I specified this in previous posts. When Siaqodb cannot optimize LINQ query, it flows into LINQ to Objects collection.
Posted by siaqodb_admin
Link | March 20th, 2010 at 7:06 am
[...] yaitu Siaqodb. Apa itu Siaqodb dan bagaimana cara mengembangkannya anda dapat menuju ke TKP berikut ini. Berikut ini gambar contoh Siaqodb di Windows Phone 7. Bagi ada solusi lainnya mohon kiranya di [...]
Posted by Siaqodb sebagai Alternatif “Storing Data” di Windows Phone 7 - Ferry Kurniawan
Link | March 21st, 2010 at 2:48 am
[...] http://siaqodb.com/?p=202 [...]
Posted by Lista de recursos para desarrolladores de Windows Phone 7 - Windows Phone 7 Puerto Rico
Link | April 26th, 2010 at 12:10 am
[...] http://siaqodb.com/?p=202 [...]
Posted by Links to sample code for the Windows Phone 7 « Bruce Barrera
Link | June 11th, 2010 at 6:36 pm
[...] http://siaqodb.com/?p=202 [...]
Posted by CoreSharp.NET - รวม Resource ดีๆ สำหรับ WP7 - frontpage
Link | June 27th, 2010 at 11:04 am
[...] Siaqodb on WindowsPhone 7 [...]
Posted by Local Database Support for Windows Phone 7 | Senthil Kumar's Blog
Link | August 3rd, 2010 at 12:43 pm
[...] http://siaqodb.com/?p=202 [...]
Posted by Những ví dụ mẫu WP7 | Windows Phone Programming
Link | November 21st, 2011 at 9:17 pm