Which Database to use?

[Zahid]

Hi,

I am new to Pocket PC development so please forgive me if
i ask silly questions. Im also new to Databases too. I
want to use a database with my VB.Net CF application. I
have MSDN Enterprise subscription from which I can
download SQL Server 200 Windows CE Version 2. I have a
couple of questions:

My application will need to run on PocketPC 2002 and
greater. Will the SQL Server 200 Windows CE database work
on it?

If I create the database on my Desktop PC will i just
need to copy the database file onto the PocketPC for the
app to use it? Or is it not as simple as that?

Im told we cant access MS Access from .Net CF without
purchasing a Wrapper from companies like InTheHand.com ?
I would like to use MS Access if its the easiest method.

Will I need to install the SQL Server 200 Windows CE on
the PocketPC for the database to work with my
Application? This is not the case if you have a MS Access
database.


Thanks in advance.

 

[BadMrFrosty]

You probably should take a class first or go pick up some books. You seem
new to a lot. This is not to be critical but you do need to have some base
level skills.

Microsoft .Net Compact Framework book is great. Using SQL and VS is pretty
easy and works great with sqlCe and RDA.

Good luck

 

[James]

Depending on the app, you may just want to use XML instead
of a full blown DB.