I have this project for developing an drug interaction aplication for a pda
under a windows o.s .

The aplication is being developed on visual basic .net (using visual studio
.net 2003), and I needed to create an local datastore, the problem is that
most of the database access controls and etc available on the full .net
framework aren´t available for the .net compact framework, so, so much for
using an MS access database file, as for SQL, I kinda dislike the ideia of
having to install the CE server on the pda just to run a lame database that
only uses SELECT and WHERE (=?) queries (the aplication only reads a
specific value from a field on the database and compares it to another value
from another field).

So after all this, here's my questions: Is there any way to use an sql
database file as an local datastore without the SQL server running? Just by
reading from the file that is? And how about an serialized xml file from the
object model, could it do the trick or does it run in to the missing class
prob in compact framework?

Thanks for reading and for your time, help is most welcome.

Re: Local datastore for visual basic .net aplication on a pda by Chris

Chris
Wed Nov 10 20:33:07 CST 2004

Sure. SqlServerCe is what you want. You don't need a backend server to use
it, it works fine as a local data store.

--
<ctacke/>
www.OpenNETCF.org
Your CF searches start and end here


"Rui Guedes" <RuiGuedes@discussions.microsoft.com> wrote in message
news:3630BB66-3E4D-4535-AF4F-68849ADFCAE0@microsoft.com...
>I have this project for developing an drug interaction aplication for a
>pda
> under a windows o.s .
>
> The aplication is being developed on visual basic .net (using visual
> studio
> .net 2003), and I needed to create an local datastore, the problem is that
> most of the database access controls and etc available on the full .net
> framework aren´t available for the .net compact framework, so, so much for
> using an MS access database file, as for SQL, I kinda dislike the ideia of
> having to install the CE server on the pda just to run a lame database
> that
> only uses SELECT and WHERE (=?) queries (the aplication only reads a
> specific value from a field on the database and compares it to another
> value
> from another field).
>
> So after all this, here's my questions: Is there any way to use an sql
> database file as an local datastore without the SQL server running? Just
> by
> reading from the file that is? And how about an serialized xml file from
> the
> object model, could it do the trick or does it run in to the missing
> class
> prob in compact framework?
>
> Thanks for reading and for your time, help is most welcome.



Re: Local datastore for visual basic .net aplication on a pda by Aaron

Aaron
Wed Nov 10 23:11:02 CST 2004

In other words, if you don't need to sync your datastore with the desktop,
or back your data up on the desktop in any way, SqlServerCe can be used
without having SQL Server on the desktop?

"Chris Tacke, eMVP" <ctacke@spamfree-opennetcf.org> wrote in message
news:eujzIb5xEHA.4028@TK2MSFTNGP15.phx.gbl...
> Sure. SqlServerCe is what you want. You don't need a backend server to
use
> it, it works fine as a local data store.
>
> --
> <ctacke/>
> www.OpenNETCF.org
> Your CF searches start and end here
>
>
> "Rui Guedes" <RuiGuedes@discussions.microsoft.com> wrote in message
> news:3630BB66-3E4D-4535-AF4F-68849ADFCAE0@microsoft.com...
> >I have this project for developing an drug interaction aplication for a
> >pda
> > under a windows o.s .
> >
> > The aplication is being developed on visual basic .net (using visual
> > studio
> > .net 2003), and I needed to create an local datastore, the problem is
that
> > most of the database access controls and etc available on the full .net
> > framework aren´t available for the .net compact framework, so, so much
for
> > using an MS access database file, as for SQL, I kinda dislike the ideia
of
> > having to install the CE server on the pda just to run a lame database
> > that
> > only uses SELECT and WHERE (=?) queries (the aplication only reads a
> > specific value from a field on the database and compares it to another
> > value
> > from another field).
> >
> > So after all this, here's my questions: Is there any way to use an sql
> > database file as an local datastore without the SQL server running? Just
> > by
> > reading from the file that is? And how about an serialized xml file from
> > the
> > object model, could it do the trick or does it run in to the missing
> > class
> > prob in compact framework?
> >
> > Thanks for reading and for your time, help is most welcome.
>
>



Re: Local datastore for visual basic .net aplication on a pda by Chris

Chris
Thu Nov 11 07:00:02 CST 2004

Yes. And in that case it's also free.

--
<ctacke/>
www.OpenNETCF.org
Your CF searches start and end here


"Aaron" <ABieberitz@charter.net> wrote in message
news:10p5t36s8u3g5e1@corp.supernews.com...
> In other words, if you don't need to sync your datastore with the desktop,
> or back your data up on the desktop in any way, SqlServerCe can be used
> without having SQL Server on the desktop?
>
> "Chris Tacke, eMVP" <ctacke@spamfree-opennetcf.org> wrote in message
> news:eujzIb5xEHA.4028@TK2MSFTNGP15.phx.gbl...
>> Sure. SqlServerCe is what you want. You don't need a backend server to
> use
>> it, it works fine as a local data store.
>>
>> --
>> <ctacke/>
>> www.OpenNETCF.org
>> Your CF searches start and end here
>>
>>
>> "Rui Guedes" <RuiGuedes@discussions.microsoft.com> wrote in message
>> news:3630BB66-3E4D-4535-AF4F-68849ADFCAE0@microsoft.com...
>> >I have this project for developing an drug interaction aplication for a
>> >pda
>> > under a windows o.s .
>> >
>> > The aplication is being developed on visual basic .net (using visual
>> > studio
>> > .net 2003), and I needed to create an local datastore, the problem is
> that
>> > most of the database access controls and etc available on the full .net
>> > framework aren´t available for the .net compact framework, so, so much
> for
>> > using an MS access database file, as for SQL, I kinda dislike the ideia
> of
>> > having to install the CE server on the pda just to run a lame database
>> > that
>> > only uses SELECT and WHERE (=?) queries (the aplication only reads a
>> > specific value from a field on the database and compares it to another
>> > value
>> > from another field).
>> >
>> > So after all this, here's my questions: Is there any way to use an sql
>> > database file as an local datastore without the SQL server running?
>> > Just
>> > by
>> > reading from the file that is? And how about an serialized xml file
>> > from
>> > the
>> > object model, could it do the trick or does it run in to the missing
>> > class
>> > prob in compact framework?
>> >
>> > Thanks for reading and for your time, help is most welcome.
>>
>>
>
>