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

From: Aaron (ABieberitz_at_charter.net)
Date: 11/11/04 

Date: Wed, 10 Nov 2004 23:11:02 -0600

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.
>
>

Relevant Pages

  • Re: Upgraded to Visual C# Express 2005 SP1, can no longer persist data in SQL Server Express
    ... none of my apps will persist data to ... SQL Server Express (have not yet applied the Service ... Just off the top of my head, could it be that your database file is copied to the bin directory each time you build/run, so that you always start with the same version? ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Getting 5105 error when I try to attach database
    ... check SQL Server does to detect if I'm accessing a database file through a ... database file over a network share anyway. ... >> activation error), it gives the same path that I gave it, and says that the ...
    (microsoft.public.sqlserver.server)
  • Re: Local datastore for visual basic .net aplication on a pda
    ... >>> 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 ... >>> database file as an local datastore without the SQL server running? ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: How can I check..
    ... from sysindexes s inner join sysfilegroups fg ... Wayne Snyder, MCDBA, SQL Server MVP ... community of SQL Server professionals. ... > How can I check which table is a part of this database file? ...
    (microsoft.public.sqlserver.server)
  • Re: MS Access function in SQL Server?
    ... SQL Server pre-allocates storage, for performance reasons. ... would require the database file to grow and growing files is an expensive operation. ... "rodchar" wrote in message ...
    (microsoft.public.sqlserver.server)