Basics of Storage in Windows 8 Dev

Question

I'm new in using storage/containers in Win 8 Dev.
I also don't know how to use SQL Database

Can someone teach me or give me a link that teach how to use storage in Win 8 Applications,
A Simple storage of strings will do for the app I am making :D

There are no tutorials for storage in Doc Map :(

Thanks for those who can help

Answer 1

You should be looking for samples on SQLLite.

---

Matt Small - Microsoft Escalation Engineer - Forum Moderator
If my reply answers your question, please mark this post as answered.

NOTE: If I ask for code, please provide something that I can drop directly into a project and run (including XAML), or an actual application project. I'm trying to help a lot of people, so I don't have time to figure out weird snippets with undefined objects and unknown namespaces.

Answer 2

Where can I find SQL Lite and it's sample?
Is it a CodePlex?

Sorry I'm really new in programming C#

Answer 3

Have you seen the following blog post: SQLite with Windows 8 apps - http://timheuer.com/blog/archive/2012/08/07/updated-how-to-using-sqlite-from-windows-store-apps.aspx ?

Answer 4

I'm just reading it right now, so I get it how to install the SQLLite but now I don't know how to program it :(
 
Is there a site that can provide some syntax or sample codes that I can get so that I can
fully implement my SQLLite?

Answer 5

Now that may be seen beside the topic but there is some time that Tim has been working on this but I always thought Microsoft won't kind of suggest to incorporate local DB given Azure but the above two responses make me think otherwise.

Is this a suggested approach especially when Local DB is intrinsically supported in WP7 and no way in Metro. What am I missing?

Answer 6

I am not sure about the complete sample, but you should also check sqlite-net project repository: https://github.com/praeclarum/sqlite-net

It provides more documentation on using the library and includes a sample application.

Answer 7

You are not able to use Azure in all the scenarios - we still have disconnected devices. You have several options to store your data locally and SQLite is on of them. And don't forget about ESENT database - it's a part of Windows and it is available for use from Metro apps.

Answer 8

Andrei - What is ESENT Database? What is it's difference with SQLLite and which is better to implement ? :D

Answer 9

Here is an info about ESENT - http://en.wikipedia.org/wiki/ESENT

There is an ESENT library fro .NET - http://managedesent.codeplex.com/

SQLite is easier to understand and use.

Answer 10

Thanks Andrei :D I'm studying SQLite, Hmm I'm getting how it works but I don't know how to use it
I mean the syntax is already there but I have a hard time implementing it
 
I think you already used SQLite right? Do you have a simple project that uses SQLite so that I can understand
when I trace the project you will give.

but if you can't for confidentiality it's also fine :D

Answer 11

I research more on storage API for Windows 8 RTM and I stumbled upon "Working with data files"
It's not in the RoadMap but in another section, I'm thinking if I should just use

http://msdn.microsoft.com/en-us/library/windows/apps/xaml/hh700361.aspx

rather than SQLite for I don't have a background on using SQL.

or there is also SkyDrive API where my user can store the data output of the program I'm working on
but I believe it's harder to implement.

What do you think? 

for I just need to store string data files.

Answer 12

I guess that depends upon what sort of data you need to save. You'll get loads of samples on using XML out of the box in Metro app. But again rich in data your application is what's the footprint of that?

Answer 13

by footprint you mean purpose?

I'm trying first the basic stuff like saving multiple strings, it's like an diary app
where I can put stuff there then Edit/Delete/etc. if I want and it will be save.

Answer 14

Try to look http://winrtdatabase.codeplex.com/

This is a very simple XML-based data storage, you might find this more convenient to use.