Replacing MSDE

30 Mar 2005 8:34 AM

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

30 Mar 2005 8:55 AM

Sébastien_Ros

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.

30 Mar 2005 6:29 PM

Miha Markic [MVP C#]

"Sébastien Ros" <anonym***@discussions.microsoft.com> wrote in message
news:03a701c53506$36cb5ba0$a401280a@phx.gbl...
> 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.

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.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info

30 Mar 2005 8:57 AM

Miha Markic [MVP C#]

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)

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info

Show quote

"Michael" <Michael.ca***@free.fr> wrote in message
news:424a6402$0$32248$79c14f64@nan-newsreader-06.noos.net...
> 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
>