Replacing MSDE

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hello,

I have made a Windows Application in C#, with a database running under MSDE.

The application is quite simple, and there is only 3 tables, and only one
has maybe 200-250 records maximum (the 2 others have only 10-20 records).

I wanted to use XML files for datasets, but i am not sure if it is possible
to use SQL queries to sort my data (like SELECT * FROM myTable WHERE .....
ORDER BY ...).

Is there an other way to use database file without installing anything, like
the old DBF files for Foxpro ?
Because i think MSDE is a little bit to heavy for my purpose.

Thanks for your answers.

Michael
 
You should use an Access database file. Nothing to
install and not so much code to change from your current
work. Also as cheap as MSDE for the user.
 
Hi Michael,

I would go with XML.
And do the sorting through the DataView class.
If you don't need any other functionality, xml if more then enough.
However, if you need a database you might look into firebird database - no
installation required (other then copy&paste)
 
Sébastien Ros said:
You should use an Access database file. Nothing to
install and not so much code to change from your current
work. Also as cheap as MSDE for the user.
Click to expand...

Actually you have to install mdac (you have to install it anyway to use some
parts of ado.net) and jet drivers separately.
I am not 100% sure but i think you doesn't need either of those setups when
using xml/dataset.
 
Back
Top