title: Xamarin Android Sqlite Db browser
body: <p>I have my first smartphone since one week and try make a App with Xamarin.</p>
  
  <p>I use SQLite with EntityFrameworkCore to store data.</p>
  
  <p>It is work fine, but to debug easier I want use a SQLite browser.
  The database file path is 'data/data/{AppName}/Database.db'.</p>
  
  <p>I debug from a physic device by USB, but when I explore the device with Windows Explorer I cannot find the SQLite DB file. The 'data/data' folder is not available. Then I can not use a SQLite browser to see the data.</p>
  
  <p>In this post, the author use a Android emulator and can see 'data/data' folder :
  <a href="https://blog.xamarin.com/building-android-apps-with-entity-framework/" rel="nofollow noreferrer">https://blog.xamarin.com/building-android-apps-with-entity-framework/</a></p>
  
  <p>But I prefer use a real device.</p>
  
  <p>Have you a solution?</p>
  
  <p>A solution from the MikeT, in development store the db file in available folder like this :</p>
  
  <pre><code>    public static string DatabasePath
      {
          get
          {
              var dbFolder = Android.OS.Environment.GetExternalStoragePublicDirectory(Android.OS.Environment.DirectoryDownloads).AbsolutePath;
              var fileName = "database.db";
              var dbFullPath = Path.Combine(dbFolder, fileName);
              return dbFullPath;
          }
      }
  </code></pre>
  
  <p>In production, copy the db file to a available folder.</p>