title: Retrieving Data from sqlite table in windows 8 app
body: <p>I have a ready database in form of sqlite file from which I want to bind the data with the various controls like combo box, textbox and so on as per the requirement of my app.</p>
  
  <p>I have referred this link : <a href="http://wp.qmatteoq.com/using-sqlite-in-your-windows-8-metro-style-applications/" rel="nofollow">http://wp.qmatteoq.com/using-sqlite-in-your-windows-8-metro-style-applications/</a> and created a class as per the table of my database.</p>
  
  <p>I have a table auto_fares and so I have created a class auto_fare. As per mentioned in the link above I have followed the steps mentioned but still I am getting the following error:
  "no such table: auto_fares" although a table of this name does exist in my database.</p>
  
  <p>Please guide me. Any help is welcomed.
  Awaiting replies.</p>
  
  <p>The following the block of code:</p>
  
  <pre><code>StorageFile seedFile = await StorageFile.GetFileFromPathAsync(
      Path.Combine(
         Windows.ApplicationModel.Package.Current.InstalledLocation.Path,
         "fare.sqlite"));
  SQLiteAsyncConnection conn = new SQLiteAsyncConnection("fare.sqlite");
  var query = conn.Table&lt;auto_fares&gt;();
  var result = await query.ToListAsync();
  foreach (var item in result)
  {
     auto_fares obj = new auto_fares();
     cbCity.Items.Add(item.city);
  }
  </code></pre>