title: ASP.NET Core 2.0 Web Application fails with a SQLite error when deploying the project to Azure Web Service but runs fine in local environment
body: <p>The ASP.NET Core 2.0 web application fails when I deploy it to Azure App Service.</p>
  
  <p>This is what is being used in the project.</p>
  
  <ul>
  <li>ASP.NET Core 2.0 MVC Web Application</li>
  <li>Visual Studio 2017 Enterprise</li>
  <li>SQLite databases</li>
  <li>Code First Entity Framework</li>
  <li>Azure App Service</li>
  </ul>
  
  <p>The web application works fine when I run it locally in Visual Studio. The problem results when I publish it to an Azure Web Service it cannot connect to the database. It states the following error when navigating to the deployed web application URL: </p>
  
  <p><strong>SqliteException: SQLite Error 1: 'no such table: Inventory'.</strong></p>
  
  <p>I've tried several times to apply an <strong>Update-Migration</strong> or an <strong>Add-Migration</strong> to the database but it will still result in the table not found when deployed to the Azure server.</p>
  
  <p>Here are my SQLite connections defined in the Startup.cs file.</p>
  
  <pre><code>     // Add Inventory DB
          services.AddDbContext&lt;InventoryContext&gt;(options =&gt;
          options.UseSqlite("Data Source=Inventory.db"));
  
          // Add User DB
          services.AddDbContext&lt;UserContext&gt;(options =&gt;
          options.UseSqlite("Data Source=User.db"));
  
          // Add Purchase Order DB
          services.AddDbContext&lt;PurchaseOrderContext&gt;(options =&gt;
          options.UseSqlite("Data Source=PurchaseOrder.db"));
  </code></pre>