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
Marina - 29 Dec 2005 17:07 GMT
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.
>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
[quoted text clipped - 10 lines]
> Guoqi Zheng
> http://www.ureader.com
Gabriele G. Ponti - 29 Dec 2005 19:59 GMT
A DataSet works like a little relational database, and you can serialize it
to disk. See the documentation for more details.
Gabriele
Marina - 29 Dec 2005 20:36 GMT
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.
>A DataSet works like a little relational database, and you can serialize it
>to disk. See the documentation for more details.
>
> Gabriele
Gabriele G. Ponti - 30 Dec 2005 12:50 GMT
I doubt he needs all of these features.
Marina - 30 Dec 2005 13:39 GMT
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.
guoqi zheng - 31 Dec 2005 10:29 GMT
> 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