473,396 Members | 2,011 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

XML as general-purpose database?

Hi! I'm coming from building desktop applications using Borland Delphi
(Win32) with embedded databases (compiled into the executable). While I find
this a very powerfull combo, I'm looking into how I would want to make those
kind of applications using C#. As I can't offer potential customers any
direct support (it's just a sidekick), I don't want to have them dealing
with real database-servers like MSDE.

Now, let's say that the number of tables will be between 5 - 25, and the
largest tables will hold no more than 10 000 records. The data should be
held in a dataSet, so that data can easily be displayed and edited in a
dataGrid. If it can be done so that porting to MSDE later will be relatively
easy, then all the better.

Would XML-files be fitting storage for this kind of application, or would it
be more like "doable but very cumbersome to work with"?

Any recomendations on examples, projects at sourceforge.net, articles,
books, 3rd-party products etc. appreciated!
Nov 12 '05 #1
2 1179
I have done this with a simple db with 1000 records and 2 tables. It worked
fine. It was a bit slow to load the dataset from the XML file, especially
so on the .NET Compact Framework.

"Ottar Smidesang Holstad" <no@no.no> wrote in message
news:%2******************@TK2MSFTNGP09.phx.gbl...
Hi! I'm coming from building desktop applications using Borland Delphi
(Win32) with embedded databases (compiled into the executable). While I find this a very powerfull combo, I'm looking into how I would want to make those kind of applications using C#. As I can't offer potential customers any
direct support (it's just a sidekick), I don't want to have them dealing
with real database-servers like MSDE.

Now, let's say that the number of tables will be between 5 - 25, and the
largest tables will hold no more than 10 000 records. The data should be
held in a dataSet, so that data can easily be displayed and edited in a
dataGrid. If it can be done so that porting to MSDE later will be relatively easy, then all the better.

Would XML-files be fitting storage for this kind of application, or would it be more like "doable but very cumbersome to work with"?

Any recomendations on examples, projects at sourceforge.net, articles,
books, 3rd-party products etc. appreciated!

Nov 12 '05 #2
I have done this with a simple db with 1000 records and 2 tables. It worked
fine. It was a bit slow to load the dataset from the XML file, especially
so on the .NET Compact Framework.

"Ottar Smidesang Holstad" <no@no.no> wrote in message
news:%2******************@TK2MSFTNGP09.phx.gbl...
Hi! I'm coming from building desktop applications using Borland Delphi
(Win32) with embedded databases (compiled into the executable). While I find this a very powerfull combo, I'm looking into how I would want to make those kind of applications using C#. As I can't offer potential customers any
direct support (it's just a sidekick), I don't want to have them dealing
with real database-servers like MSDE.

Now, let's say that the number of tables will be between 5 - 25, and the
largest tables will hold no more than 10 000 records. The data should be
held in a dataSet, so that data can easily be displayed and edited in a
dataGrid. If it can be done so that porting to MSDE later will be relatively easy, then all the better.

Would XML-files be fitting storage for this kind of application, or would it be more like "doable but very cumbersome to work with"?

Any recomendations on examples, projects at sourceforge.net, articles,
books, 3rd-party products etc. appreciated!

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Christopher | last post by:
I am trying to find out if there is similar functionality as Perls Config::General module in PHP. I would like to do this project in PHP and need to read in a conf file that the Perl module uses. ...
6
by: Andreas Pauley | last post by:
Hi All, Our company is currently evaluating Python as a language for writing financial/accounting type software (among others). What libraries or packages are available in this domain for use?...
1
by: gcook | last post by:
Hi, I've got an old perl program running on my webserver - so old that I haven't used a perl programmer in about two years :) (we've gone all php for a variety of reasons). Anyway, I'm...
1
by: Home User | last post by:
Hello, I am trying to find an application (if it exists) that actually creates .gent files (General Entity). Also, I am wondering if I can import .gent files into Dreamweaver? Perhaps with...
1
by: GChong | last post by:
Hi, Im looking for some general 'marketing' info on dotnet: how long it has been in use (i.e first release date), how many companies are using it, number of .NET developers in the world,...
3
by: JezB | last post by:
What's the generally accepted approach for using Styles and Stylesheets in a web application based on .aspx files, Web Controls, User Controls, and code-behind modules (c# in my case)? Most style...
3
by: Yong | last post by:
I get a general network error when I try to make asynchronously call ExecuteNonQuery on long sql statements that run in parallel. Here is the background info on what I'm trying to accomplish: I...
0
by: Yong | last post by:
I'm not getting any reply to my previous thread so I'm stating a new one. I get a General Network Error due to my SqlCommand object not having a big enough CommandTimeout to complete very long...
10
by: Dixie | last post by:
I am appending some new fields to a table in vba and when I append a number field with is a byte, it does not inherit any format. I want it to be the General Number format, but it is blank. I...
3
by: =?Utf-8?B?Ymxi?= | last post by:
I am posting to the general discussion group - but I cannot find my postings... or replies...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.