title: EF Core SqLite in-memory no such table?
body: <p>I configured my ASP.NET Core 2.2 app using UseInMemoryDatabase() and it worked fine. Now I changed it to relational Sqlite in-memory. </p>
  
  <p>Startup.cs</p>
  
  <pre><code> services.AddDbContext&lt;ApplicationContext&gt;(options =&gt; options.UseSqlite("Datasource=file::memory:?cache=shared"));
  </code></pre>
  
  <p>I use this Sqlite in-memory approach in unit tests and it work good. So decided I want to use the same in-memory Sqlite in my app (to test some things, later when app will be ready I'll create sqlite file on disk). The problem is when I starting my app. I receive erros like <code>SqliteException: SQLite Error 1: 'no such table: USERS'</code>. I debug my repository class and I found that context has table Users. 
  So Sqlite in-memory works fine in unit tests but in real app throws error. Why is that? Thanks for any tips.</p>
  
  <p><a href="https://i.stack.imgur.com/rK6CZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rK6CZ.png" alt="enter image description here"></a></p>