Advice on databases

  • Thread starter Thread starter Ann Marinas
  • Start date Start date
A

Ann Marinas

Hello All!

I need to seek your advice on databases.

I was wondering if you guys have any suggestions on a databases that is
lighter than SQL Server but much more efficient than MS Access.

I am currently designing a C# program that would be deployed on computers
that have no SQL Server nor MS Access installed and is not connected to a
network.

Thank you so much and have a Happy New Year! :D

Ann
 
So each app is a stand alone island and won't need to change in the
forseeable future? SQL Server MSDE is a great database, gives you most of
the bang of it's big brother, but it's free and a heck of a lot better than
access for too many reasons to list. If you can't do this though... I'd use
XML, it's very easy and you can serialize your DataSets using
DataSet.WriteXML(fileName) and deserialize it with DataSet.ReadXML(filename)

You can set the diffgram option as well so you can maintain state.
Howeever, I hope that you aren't going to have a huge number of records and
are sure these files won't need to talk to each other in a few months b/c if
you are, you'll probably need a central repository and a mechanism for
concurrency which is doable with a ton of xml files, but it probably won't
be much fun.

HTH,

Bill
 
* "Ann Marinas said:
I need to seek your advice on databases.
Click to expand...

Please do not include groups to your X-posts which are not related to
the topic.
 
Hi Ann,

In addition to William:
You might consider Firebird
http://firebird.sourceforge.net/

It is an open source free database.
It has a .net managed provider.
And soon .net provider will support embedded database (no *installation*,
only few dlls).
 
What issues are you having with Access? It is typically fine in a
standalone single user environment such as this and there is no requirement
for the system to have a copy of MS Access installed in order to access the
DB from your application.
 
Hi, Schooner!

Thank you for your response.

I agree that MS Access is very fine in a stand-alone environment. But then
again, there are some features in my application that I need to implement.
For instance, migrating from a stand-alone application to a network
application (like Mr. William Ryan suggested). I need to anticipate change
in the future, and I think that MS SQL MSDE is the only way to go.

Once again, thank you for your response. I really do appreciate it!

God Bless!

Ann :)
 
have you thought about MySql? i heard its a great
database and its free. ive not really seen it in action
though, but some people say its comparable to ms sql
server. you can get it at mysql.com. you can access it
with .net using odbc or ado.net
 
Back
Top