0

I need a tool that will allow the user to create small databases(lookup tables, formulas, constants) and extract information from them later. the information(value's) i get from the database will be inserted to an xml file i need for my work. the size of the database will be small but its not known to me now so i need a way for the user to enter it. what simple tool do i have in c# to do that?

Avi.S.
  • 163
  • 2
  • 3
  • 12
  • Maybe the in-memory [`DataSet`](http://msdn.microsoft.com/en-us/library/esbykkzb(v=vs.110).aspx) or do you need to store the data physically? – Tim Schmelter Oct 05 '12 at 13:34
  • I've got a list of small databases for .NET [here](http://stackoverflow.com/questions/6749556/what-is-a-good-choice-of-database-for-a-small-net-application/6749583#6749583), it has one or two links for management tools. – Adam Houldsworth Oct 05 '12 at 13:39
  • Tim i need to store the data for future use. – Avi.S. Oct 05 '12 at 15:56

4 Answers4

3

Use SQLite.
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world.

Saurabh R S
  • 3,037
  • 1
  • 34
  • 44
  • Keep in mind that SQLite only supports a subset of SQL queries and datatypes, but is a very good start if you want to store data physically. – Christian Ivicevic Oct 05 '12 at 13:35
0

I would suggest looking at a NoSQL database.. perhaps something like MongoDB or for the embedded kind perhaps RavenDB. NoSQL might be useful for you if you're unsure what structure your users' data may take.

Simon Whitehead
  • 63,300
  • 9
  • 114
  • 138
0

I think you'd like to have some kind of Database Manager? If you do so then it depends on the database system.

For example if you would like to manage MySQL databases you should have a look at the .Net Connector for MySQL databases As far as I know there is a support for SQLite in .Net so you wouldn't need any external libs for this.

TorbenJ
  • 4,462
  • 11
  • 47
  • 84
0

Use SqlServerCe. It is an In-App database which can be accessed only from one application at a time.

Oliver
  • 43,366
  • 8
  • 94
  • 151