self contained database?

  • Thread starter Thread starter guoqi zheng
  • Start date Start date
G

guoqi zheng

I am writting a Asp.NET custom control in which I need to use some data
storage where people can add/modify. I am using SQL database, but it sounds
like not very nice because if I want to move that control to other location,
I have to move the SQL database as well.

Is there a self contained database which can I compile into the .dll file?
XML is alternative but not nice enough.

regards,

Guoqi Zheng
http://www.ureader.com
 
You wouldn't be able to compile any database into a DLL and then write to
it. That would you mean you would have to recompile a loaded DLL on the
fly, replace it on disk, and reload it? That is not going to happen.

You can use Access as a portable file system based database, but you
wouldn't embed it as a resource in the DLL.
 
A DataSet works like a little relational database, and you can serialize it
to disk. See the documentation for more details.

Gabriele
 
I disagree with that. You can't do joins, grouping, nested queries, etc.
Unless the database operations required are absolutely trivial, a dataset is
no substitute for a database engine.
 
I think a join is a pretty basic feature to need. Unless the program is
trivial, those other features are generally required.
 
I doubt he needs all of these features.
Thanks for all reply. I think I know what to do it. I will just write the
dataset to disk as a binary.

Join is nice to have but not that necessary.

regards,

Guoqi Zheng
http://www.ureader.com
 
Back
Top