Databases
StackOverflow2013
Postsdbo
POHow to use SQLite on new Windows 8.1 Store app (Visual Studio 2013)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to use SQLite on new Windows 8.1 Store app (Visual Studio 2013)
    primarykey
    data
    text
    <p>So, I installed Visual Studio 2013 on my Windows 8.1 box. I want to experiment with it and created a new <strong>Windows Store Grid App</strong>. I want to persist data on a SQLite database, apparently the database of choice for WinRT apps.</p> <p>Quickly found links to the vsix needed in order to be able to use the SDK: <a href="http://sqlite.org/download.html">SQLite download page</a>, and downloaded sqlite-winrt81-3080002.vsix.</p> <p>Installed it, then in my project, added the reference to the newly installed SDK (right click references, add reference, navigate to Windows, select extensions and tick SQLite for Windows Runtime (Windows 8.1) checkbox.</p> <p>Also quickly found that it won't compile on Any CPU. On Configuration Manager, selected Debug, x64 active platform, that made me able to compile the application.</p> <p>Finally, while attempting to use the namespace <code>SQLite</code> I noticed VS 2013 isn't recognizing it. Attempted many things like adding reference to the .dll directly, exploring the component to see which namespaces were available (which doesn't show anything), and I'm quickly running out of ideas. Because it's kinda new thing, and with limited interest, google, the saviour, doesn't want to save me today.</p> <p>So, how one would be able to use the SQLite SDK in their Visual Studio 2013 projects, targeting Windows Runtime 8.1?</p> <p><a href="http://pastebin.com/pGHHerHq">These are the contents of my csproj file</a></p> <p><strong>UPDATE</strong> Stupid me, thought there was no managed land (.net) in Metro style land. Sorry for causing any confusion.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJoao Milasch
    1. USJoao Milasch
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to use SQLite on new Windows 8.1 Store app (Visual Studio 2013)
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow to use SQLite on new Windows 8.1 Store app (Visual Studio 2013)
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. POHow to use SQLite on new Windows 8.1 Store app (Visual Studio 2013)
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload