Where to store my data?

Question

Am developing software in VB.NET that needs to store related information of Contacts etc. I can't use MS-SQL or MySQL as Database because if I do that, then if I've to install on another PC, I'll also need to install MS-SQL on that PC. Isn't there any "built-in Database" in VB.NET?

Rikki B · Answer 1 · 2013-03-24T05:01:37.557

0

You can use DataSets. Have a look here.

edited Mar 24 '13 at 05:01

answered Mar 24 '13 at 04:49

Rikki B

636
8
23

score 0 · Answer 2 · edited May 23 '17 at 12:31

0

Based off your use case about needing to store relational data but not being able to install a full-fledged database server product, it sounds like your application benefit from using an embedded database.

There was a previous question about this here

edited May 23 '17 at 12:31

Community

1
1

answered Mar 24 '13 at 04:51

nkvu

5,551
2
16
12

score 0 · Answer 3 · answered Mar 24 '13 at 05:05

I would recommend XML with Datasets. You need not to install any software, and there are tons of guides on how to read/write from/to XML files.

Another solution would be SQL Compact; it's kinda like SQLite (doesn't require installation)

SQL Compact: http://msdn.microsoft.com/en-us/data/ff687142.aspx

XML Solutions Samples: http://www.codeproject.com/Articles/13854/Using-XML-as-Database-with-Dataset http://www.daniweb.com/software-development/csharp/threads/343670/use-of-xml-file-in-c-instead-of-database

score 0 · Answer 4 · answered Mar 24 '13 at 20:54

0

If your are dealing with a significant amount of data, a database is the appropriate solution. SQL Express is free, works well with VB and is, well, moderately easy to package as a pre-requisite with your msi file when you build the installer.

answered Mar 24 '13 at 20:54

peterG

1,651
3
14
23

Where to store my data?

4 Answers4