VB.NET - Storing data locally?

Jarrod · 11 Nov 2013 at 06:19

I've not written any data driven applications other than with MySQL before.. what is the best way to store record data using .NET? In VB6 there is the Record module where you can use fixed length records in a text file however I haven't found such a thing in .NET

cHEERS

Pho · 11 Nov 2013 at 09:32

Look into noSQL stuff like Redit, RavenDB, SQLite etc. They'll let you store complex data without the need for a SQL server.

*I mostly always use MSSQL for things I work on, so there's probably better ways than the above.

kkelly · 11 Nov 2013 at 10:13

MS SQL Compact databases, I don't know much sorry however it's used on mobile devices.

Deathwish · 18 Nov 2013 at 21:21

I've used SQLlite in my VB.Net apps, seems to work well for me, easy data access etc.

Trucamo · 19 Nov 2013 at 13:08

The solution you go for is going to be dependent upon the problem you are trying to solve.

If you only have a small amount of data, serializing a collection to a file may be enough.

If you have lots of data, you should look into MS SQL Compact or SQLite.

Trucamo · 19 Nov 2013 at 13:09

Pho, I don't think SQLite is noSQL

Pho · 19 Nov 2013 at 20:25

Trucamo said:
Pho, I don't think SQLite is noSQL

I know what I meant, my dodgy grammar did not

.

blacblu · 21 Nov 2013 at 00:32

Since you are using .NET SQLCE is the most convenient approach.