Use SQLite In-Memory Database in ASP.NET Core
In the previous article you learned to use Entity Framework Core InMemory provider to store and retrieve your application data for testing and demoing purposes. An alternative (and a recommended option) is to use SQLite database in in-memory mode. To that end this article discusses just that.
http://www.binaryintellect.net/articles/9b77fa88-dffe-4efe-a37d-781787a28bcf.aspx