Monday, September 17, 2012 1:45 PM
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
- Changed Type Matt SmallMicrosoft Employee, Moderator Monday, September 17, 2012 2:01 PM Not a specific API question
Monday, September 17, 2012 2:22 PMModerator
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.
Monday, September 17, 2012 2:35 PM
Where can I find SQL Lite and it's sample?
Is it a CodePlex?
Sorry I'm really new in programming C#
Monday, September 17, 2012 2:42 PM
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 ?
Monday, September 17, 2012 3:29 PMI'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?
Monday, September 17, 2012 3:30 PM
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?
- Edited by Usman Ur Rehman AhmedMicrosoft Contingent Staff Monday, September 17, 2012 3:31 PM
Monday, September 17, 2012 3:52 PM
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.
Monday, September 17, 2012 3:58 PMYou 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.
Monday, September 17, 2012 11:48 PMAndrei - What is ESENT Database? What is it's difference with SQLLite and which is better to implement ? :D
Tuesday, September 18, 2012 12:07 AM
Tuesday, September 18, 2012 2:17 AMThanks 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
Tuesday, September 18, 2012 9:08 AM
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
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.
- Edited by XxxJxxX Tuesday, September 18, 2012 9:10 AM
Tuesday, September 18, 2012 11:32 AM
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?
Tuesday, September 18, 2012 12:00 PM
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.
Tuesday, September 18, 2012 12:05 PM
Try to look http://winrtdatabase.codeplex.com/