flat file database in compact framework

[Bappaditya]

Hi,
I am new to .NET compact framework. I was using evc3.0 where there was
flat file databases like CCeDBDatabase. Is there are any flat file
databases in .NET compact framework? (if i don't use sql server CE)

Bappaditya

 

[Ginny Caughey [MVP]]

Bappaditya,

One approach is to use a CSV file: http://www.opennetcf.org/Csv.asp
If the file will be very small, XML is another option you might consider.

Thee are also commercial database products for .NetCF.

 

[Bappaditya]

Ginny,
If i don't use any third party database products or SQL Server CE,
then is there any other databases(like CCeDBDatabase as present in
evc3.0) which is supported inside .NET Compact Framework?

Bappaditya

 

[Boris Nienke]

You can use the PocketAccess-Wrapper from InTheHand (www.inthehand.com) to
be able to use the pocket-Access-Database from within .Net. It's about 40
pound i think.

I've seen .Net-Implementations for Paradox or DBase Files. But not yet for
CompactFramework. Currently i cannot remember the URL :-/ ...

With Sybase SQLAnywhere (version 9) you can access desktop-database-files
on the pocketPC. And you can use special pocket-databases (smaller) and let
them sync with the desktop-database. Don't know the price of this solution.

Advantage Database (www.advantagedatabase.com) offers a .Net solution too.
I think it's working on CompactFramework too. In the past the local-server
(5 Users) was free. Don't know about the price for .Net / CF solution.

Very interesting is the object-database from www.db4o.com. They offer a
free demo version (running for a month). It costs $100. But this one is not
a classical database with tables and columns. You are storing/loading
objects directly.

Boris

 

[Ginny Caughey [MVP]]

Bappaditya,

As Boris said, you can use Peter Foot's wrapper for the Pocket Access
database. But if you don't want to use any 3rd party code, the CSV approach
from OpenNetCF includes source and allows you to create your own solution.
It's really up to you since there are a number of good solutions.