Windows Phone 7

1 view
Skip to first unread message

boomerbubba

unread,
Mar 19, 2010, 9:51:59 AM3/19/10
to Ward Tools Development
Just looking forward a bit, I spent some time this week reading the
reporting about Microsoft's rollout of the Windows Phone 7 OS to
developers. From what I can tell, it will not be possible to run
SQLite on that platform. The initial release will offer developers no
SQL engine for a persistent data store, and a future release is
expected to expose an embedded instance of SQL Server Compact Edition
(CE).

So LDSql as now consituted could not be implemented on this platform.
Theoretically it would be possible to port the schema to the MS SQL
Server CE dialect of SQL (or the dialects for MS Access, MySQL,
Oracle, etc.) But there is not now any plan for that.

Windows Phone 7 does not allow any native-code apps so I don't think a
third-party instance of the SQLite engine could be installed there, as
it can on the Windows Mobile platform. BTW, the legacy Windows Mobile
OS is being rebranded as Windows Phone Classic, and is expected to
coexist for some time. Personally, I have doubts about its long-term
viability.

Calvin Gaisford

unread,
Mar 19, 2010, 10:31:03 AM3/19/10
to ward-to...@googlegroups.com
It's almost comical. Back when Microsoft used to work on their mobile
platform they would break compatibility between every release. They
didn't do much much to it from 2003 until now and compatibility was
fine. Now they start working on it again and once again they are
breaking compatibility.

> To unsubscribe from this group, send email to ward-tools-dev+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
>

Andy Wilbourn

unread,
Mar 19, 2010, 11:29:54 AM3/19/10
to ward-to...@googlegroups.com
I have been looking at videos from MIX10, I do think we will be able to use it. I will do some testing when they release the emulator for VS 2010 (current release candidate does not have mobile emualator).
 
In essence, the presentation I saw was on doing silverlight 3 development that will work on the Windows Phone 7. I have not heard anything about not running other applications, but have interest as I have a couple of apps I sell for this platform. The main flow seems to be silverlight as there is no real boundry in typical forms type of apps, it just keeps flowing.
 
So one dev demo of silverlight I saw says that if the DB is completely .Net enabled (meaning can live in the sandbox), then it will be possible.
 
Again, more to be tested, but I can help with this as I have been doing Windows Mobile development already where I combine .Net and Native code together to produce our solution.

Andy Wilbourn

unread,
Mar 19, 2010, 11:34:55 AM3/19/10
to ward-to...@googlegroups.com
Looks like this week the released the emulator to go along with MIX10. I will download and give it a quick test tonight.
 

Andy Wilbourn

unread,
Mar 19, 2010, 11:37:29 AM3/19/10
to ward-to...@googlegroups.com
Here is the actual download and comes with VS2010 Express, so someone would not have to download the full VS2010 Ultimate I guess to play with it.
 

Andy Wilbourn

unread,
Mar 19, 2010, 11:48:55 AM3/19/10
to ward-to...@googlegroups.com
Last reply, promise for today.
 
Here is a link to a video I watched on doing DEV for Windows Phone 7 using silverlight and at the end is where he talks in the Q and A session that you can use DB as long as it is in the sandbox area.
 

boomerbubba

unread,
Mar 19, 2010, 4:52:37 PM3/19/10
to Ward Tools Development
Andy,

I viewed that video. Thanks for the link. I believe the presenter
can only have been referring to C#-SQLite, which is an unofficial and
somewhat experimental port of the SQLite C source into C#. And the
context of the Q&A was not about the Windows Phone 7 implementation of
Silverlight 3, but about Silverlight 4 in .NET. Perhaps that would
work on the phone, but I'm not sure. So perhaps that is a partiaI
solution for those who want to build such an engine from scratch. It
is pretty clear that native SQLite and its wrappers cannot be run on
the phone.

Meanwhile, this presenter seemed to contradict other speculation I had
seen about future support for SQL Server Compact Edition. At this
point, unlike the other major smartphone platforms that have SQLite
baked into the cake, WIndows Phone 7 does not have any embedded SQL
engine at all. Developers are reduced to finding ways to build their
own in some way that will not violate the security framework.

--Ross

On Mar 19, 10:48 am, Andy Wilbourn <awilbo...@gmail.com> wrote:
> Last reply, promise for today.
>
> Here is a link to a video I watched on doing DEV for Windows Phone 7 using
> silverlight and at the end is where he talks in the Q and A session that you
> can use DB as long as it is in the sandbox area.
>
> http://live.visitmix.com/MIX10/Sessions/CL15
>
>
>
> On Fri, Mar 19, 2010 at 10:37 AM, Andy Wilbourn <awilbo...@gmail.com> wrote:
> > Here is the actual download and comes with VS2010 Express, so someone would
> > not have to download the full VS2010 Ultimate I guess to play with it.
>

> >http://www.microsoft.com/downloads/details.aspx?FamilyID=2338b5d1-79d...


>
> >   On Fri, Mar 19, 2010 at 10:34 AM, Andy Wilbourn <awilbo...@gmail.com>wrote:
>
> >> Looks like this week the released the emulator to go along with MIX10. I
> >> will download and give it a quick test tonight.
>
> >>http://developer.windowsphone.com/windows-phone-7-series/
>

> >>   On Fri, Mar 19, 2010 at 10:29 AM, Andy Wilbourn <awilbo...@gmail.com>wrote:
>
> >>> I have been looking at videos from MIX10, I do think we will be able to
> >>> use it. I will do some testing when they release the emulator for VS 2010
> >>> (current release candidate does not have mobile emualator).
>
> >>> In essence, the presentation I saw was on doing silverlight 3 development
> >>> that will work on the Windows Phone 7. I have not heard anything about not
> >>> running other applications, but have interest as I have a couple of apps I
> >>> sell for this platform. The main flow seems to be silverlight as there is no
> >>> real boundry in typical forms type of apps, it just keeps flowing.
>
> >>> So one dev demo of silverlight I saw says that if the DB is completely
> >>> .Net enabled (meaning can live in the sandbox), then it will be possible.
>
> >>> Again, more to be tested, but I can help with this as I have been doing
> >>> Windows Mobile development already where I combine .Net and Native code
> >>> together to produce our solution.
>

> >>>   On Fri, Mar 19, 2010 at 9:31 AM, Calvin Gaisford <calvi...@gmail.com>wrote:
>
> >>>> It's almost comical.  Back when Microsoft used to work on their mobile
> >>>> platform they would break compatibility between every release.  They
> >>>> didn't do much much to it from 2003 until now and compatibility was
> >>>> fine.  Now they start working on it again and once again they are
> >>>> breaking compatibility.
>

> >>>> On Fri, Mar 19, 2010 at 7:51 AM, boomerbubba <boomerbu...@gmail.com>


> >>>> wrote:
> >>>> > Just looking forward a bit, I spent some time this week reading the
> >>>> > reporting about Microsoft's rollout of the Windows Phone 7 OS to
> >>>> > developers.  From what I can tell, it will not be possible to run
> >>>> > SQLite on that platform.  The initial release will offer developers no
> >>>> > SQL engine for a persistent data store, and a future release is
> >>>> > expected to expose an embedded instance of SQL Server Compact Edition
> >>>> > (CE).
>
> >>>> > So LDSql as now consituted could not be implemented on this platform.
> >>>> > Theoretically it would be possible to port the schema to the MS SQL
> >>>> > Server CE dialect of SQL (or the dialects for MS Access, MySQL,
> >>>> > Oracle, etc.)   But there is not now any plan for that.
>
> >>>> > Windows Phone 7 does not allow any native-code apps so I don't think a
> >>>> > third-party instance of the SQLite engine could be installed there, as
> >>>> > it can on the Windows Mobile platform.  BTW, the legacy Windows Mobile
> >>>> > OS is being rebranded as Windows Phone Classic, and is expected to
> >>>> > coexist for some time.  Personally, I have doubts about its long-term
> >>>> > viability.
>
> >>>> > To unsubscribe from this group, send email to ward-tools-dev+
> >>>> unsubscribegooglegroups.com or reply to this email with the words
> >>>> "REMOVE ME" as the subject.
>
> >>>> To unsubscribe from this group, send email to ward-tools-dev+
> >>>> unsubscribegooglegroups.com or reply to this email with the words

> >>>> "REMOVE ME" as the subject.- Hide quoted text -
>
> - Show quoted text -

Andy Wilbourn

unread,
Mar 19, 2010, 4:58:49 PM3/19/10
to ward-to...@googlegroups.com
I am playing right now to see if I can get connected to the SQLite using the
.Net wrapper out there.

Yes Silverlight 4 is how to break the bounds, but it does seem like this OS
is just the Zune OS as a phone, not sure why they did not call it Zune Phone
or something. XNA was available for Zune prior, but is also how developers
can write games for the Xbox.

There are obviously a lot more videos and more to learn about this OS, but
not looking promising for my existing application we sell as we need native
hooks and they don't seem to be exposed thus far.

I do think we could pull it off for this version, but will require more work
as things they have built in for other platforms are not there in this
Express Edition. I need to fire up my virtual machine where I have the full
VS2010 Ultimate installed.

Will keep you posted.

Andy,

--Ross

ward-tools-dev+unsubscribegooglegroups.com or reply to this email with the

Andy Wilbourn

unread,
Mar 20, 2010, 10:10:59 AM3/20/10
to Andy Wilbourn, ward-to...@googlegroups.com
There is enough missing in this release of Windows Phone 7 that I am not
going to spend more time on it. I found a new rewrite of C# SQLite that is
pure .net code and some features are removed to make it work,
http://www.itwriting.com/blog/1695-proof-of-concept-c-sqlite-running-in-silv
erlight.html. There is a lack of other base classes available, like
System.Data, so I will agree with you for now Ross Windows Phone 7 (to me
Zune Phone) will not be a candidate for Ward Tools for now.
Reply all
Reply to author
Forward
0 new messages