Database independent application using C# 2003

  • Thread starter Thread starter Hari Shankar
  • Start date Start date
H

Hari Shankar

Dear all
I have to develop a database independent application in c# 2003. It means
the underlying database should be anything like ACCESS, Oracle or SQL and my
application should not get affected if i change between databases. i also
have a requirement of storing 10,000 user records in my database. This
database can also be created by our customers and weshould be able to use
it.
After reading ADO.NET i felt convinced that it is the solution for my
requirement. But later i was thinking when i want to create a database
independent application why i should use a database first of all, instead i
can use XML.

The following are the points supporting it.
1. XML universally accepted/standardized.
2. No hassle of connection to a database server, changing the DB adapters,
customers having different databases facing problems in entering the data
3. Easily transferable and portable. Anybody can edit an XML file as there
are lot of freeware available.

The following are the points opposing it
1. Performance of parser while supporting 10,000 user records
2. Is it wise to think XML can be used in this way?

Please help me out. Also from where can i get a sample c# applications
storing the large user data (10,000 records) in XML file

Ciao
Hari
 
There are alot of reasons why XML cannot replace a database even one as
simple as MS Access. The performance slowdown would be enormous when working
with large results .

If you are looking for a database to license you mihgt want to look at
something like MSDE. It is a stripped down Microsoft SQL Server and if you
have already purchased a VS.NET license then you are entitlted to a
deployment license. You should read up

http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp - Appropriate Uses of
MSDE FAQ
http://www.microsoft.com/sql/msde/default.asp - MSDE 2000 Home
There are also other free databaes equivalents that you may wish to explore
 
Hy Hari,

I don't think it is wise to try to use XML as a replacement for a DBMS when
large volumes of data are involved. It may seem to work at first but
eventually it simply won't do.
That is why XML, being a universally accepted/standardized format, is often
used for communication (which requires a standard format) rather than
storage or transaction processing applications.

Hope this helps...
 
If I had to do this, I would not replace a DBMS with XML. If I truely had to
be database independant I would write a translation tier to isolate data
source changes from my business / UI stuff.

My objects / UI <------> Data translation tier <--------> Database

So your main app guts are isolated from your database. And if you ever need
to support a new database, it is not free (nothing is free) but all you have
to do is work on the translation tier to add the new database support.

Just a thought.

Hari Shankar said:
Dear all
I have to develop a database independent application in c# 2003. It means
the underlying database should be anything like ACCESS, Oracle or SQL and my
application should not get affected if i change between databases. i also
have a requirement of storing 10,000 user records in my database. This
database can also be created by our customers and weshould be able to use
it.
After reading ADO.NET i felt convinced that it is the solution for my
requirement. But later i was thinking when i want to create a database
independent application why i should use a database first of all, instead i
can use XML.
Click to expand...

.....
 
Back
Top