Database options

[Ebbe Kristensen]

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 Rosenberger]

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

 

[Keld Laursen [eMVP]]

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 Rosenberger]

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

 

[Valentin Iliescu]

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