Database options

In order to learn a bit of C#, I am looking at developing a PC/Pocket
PC application combo that will need a database of some sort. I want to
be able synchronize the Pocket PC database with its PC counterpart. So
far, I have found these options:

- CE SQL server. I am not really keen on this as I would like the PC
app to be a stand-alone app not needing an MS SQL server.

- MS Access/Pocket Access using ADOCE from www.inthehand.com. I'll
probably go with this one.

XML is out as I need to do some queries that will be easy in SQL and
fairly difficult without.

What have I overlooked?

Ebbe

Carl
Wed Feb 25 06:53:46 CST 2004

Ebbe Kristensen wrote:
> In order to learn a bit of C#, I am looking at developing a PC/Pocket
> PC application combo that will need a database of some sort. I want to
> be able synchronize the Pocket PC database with its PC counterpart. So
> far, I have found these options:
>
> - CE SQL server. I am not really keen on this as I would like the PC
> app to be a stand-alone app not needing an MS SQL server.
>
> - MS Access/Pocket Access using ADOCE from www.inthehand.com. I'll
> probably go with this one.
>
> XML is out as I need to do some queries that will be easy in SQL and
> fairly difficult without.
>
> What have I overlooked?


Hi Ebbe,

we supply an object database engine that allows you to store C#
(and VB) objects directly: db4o.

db4o is written in C#. It's available for the CompactFramework,
for Mono and of course for regular .NET.

Features include:
- ACID transactions
- S.O.D.A. object query interface
- Client/Server mode over TCP.
- Automatic class schema recognition and adoption

Our engine is very simple to use:
- Add db4o.dll to your project references.
- One method call stores any object.

A trial version of our current 2.8 release is available for
download from our website:
http://www.db4o.com

Enjoy!

Kind regards,
Carl
--
Carl Rosenberger
db4o - database for objects - http://www.db4o.com

Keld
Wed Feb 25 07:49:46 CST 2004

"Carl Rosenberger" <carl@db4o.com> wrote in message
news:c1i5i2$lhj$05$1@news.t-online.com...
> we supply an object database engine that allows you to store C#
> (and VB) objects directly: db4o.
>
> db4o is written in C#. It's available for the CompactFramework,
> for Mono and of course for regular .NET.
>
> Features include:
> - ACID transactions
> - S.O.D.A. object query interface
> - Client/Server mode over TCP.
> - Automatic class schema recognition and adoption
>
> Our engine is very simple to use:
> - Add db4o.dll to your project references.
> - One method call stores any object.
>
> A trial version of our current 2.8 release is available for
> download from our website:
> http://www.db4o.com

And it is easy to transfer data to/from a host system as well?

SQL CE has a system to synchronise/replicate data via some web service.

ADOCE can be transferred quite easily using DEVICETODESKTOP and
DEKSTOPTODEVICE.

What is the route for db4o?

/Keld Laursen

Carl
Wed Feb 25 08:58:54 CST 2004

Keld Laursen [eMVP] wrote:
> > A trial version of our current 2.8 release is available for
> > download from our website:
> > http://www.db4o.com
>
> And it is easy to transfer data to/from a host system as well?

Yes.

You can run a local db4o session on the CF device and connect
to a db4o server on the network.

Objects can be moved and copied between db4o ObjectContainers
and they can bound to other database identities.

Here is a small code sample how you would copy all Employee
objects (and all attached objects) from a server to a local
database on the client:

ObjectContainer localContainer =
Db4o.openFile("local.yap");
ObjectContainer serverContainer =
Db4o.openClient(HOSTNAME, PORT, USER, PASS);
Query q = serverContainer.query();
q.constrain(typeof(Employee));
ObjectSet objectSet = q.execute();
while(objectSet.hasNext()){
localContainer.set(objectSet.next());
}
localContainer.commit();
localContainer.close();
serverContainer.close();


Kind regards,
Carl
--
Carl Rosenberger
db4o - database for objects - http://www.db4o.com

Valentin
Wed Feb 25 10:12:14 CST 2004

You can use SQL CE Server with MSDE 2000 (Microsoft SQL
Server 2000 Desktop Engine ) on the desktop PC.
MSDE 2000 has the same functionality like SQL Server 2000
and is suitable for low-volume Web applications and
desktops applications.
MSDE 2000 is free and you can redistribute it with your
desktop application.
And the synchronization of SQL CE Server with MSDE is very
easy in .NET Compact Framework.

Regards,
Valentin Iliescu

>-----Original Message-----
>In order to learn a bit of C#, I am looking at developing
a PC/Pocket
>PC application combo that will need a database of some
sort. I want to
>be able synchronize the Pocket PC database with its PC
counterpart. So
>far, I have found these options:
>
>- CE SQL server. I am not really keen on this as I would
like the PC
>app to be a stand-alone app not needing an MS SQL server.
>
>- MS Access/Pocket Access using ADOCE from
www.inthehand.com. I'll
>probably go with this one.
>
>XML is out as I need to do some queries that will be easy
in SQL and
>fairly difficult without.
>
>What have I overlooked?
>
>Ebbe
>.
>