title: "Entity framework SQL Script generation failed" error occurs while publishing on azure using SQLite Database
body: <p>I found a lot of questions similar to my problem on MSDN and SF but none of them helped me or maybe I didn't understand them. I'm getting the following error while I'm trying to publish my app on Azure.</p>
  <blockquote>
  <p>Entity framework SQL Script generation failed</p>
  </blockquote>
  <p>I'm using the SQLite database here. Point to be noted that everything is ok in my local machine. The app runs fine.</p>
  <p>I already ran these commands on package manager console - <code>Add-Migration -Initial</code> and <code>Update-Database</code></p>
  <p><strong>Publishing setting</strong></p>
  <p><a href="https://i.stack.imgur.com/y4IVi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/y4IVi.png" alt="enter image description here" /></a></p>
  <blockquote>
  <p>In this photo, I entered &quot;Initial&quot; as the connection string in the EF Migrations field. The result is the same. Maybe the problem causing here I guess.</p>
  </blockquote>
  <p><strong>appsetting.json</strong></p>
  <pre><code>{
    &quot;Logging&quot;: {
      &quot;LogLevel&quot;: {
        &quot;Default&quot;: &quot;Information&quot;,
        &quot;Microsoft&quot;: &quot;Warning&quot;,
        &quot;Microsoft.Hosting.Lifetime&quot;: &quot;Information&quot;
      }
    },
    &quot;AllowedHosts&quot;: &quot;*&quot;,
    &quot;ConnectionStrings&quot;: {
      &quot;EmployeeDB&quot;: &quot;Data Source=employeedb.db;&quot;
    }
  }
  </code></pre>