Efcore: Improve the experience for using SQLite in-memory databases

[ajcvickers]

For example, some sugar to make it easier to keep a connection open across multiple context instances.

@divega @bricelam I believe you guys have some additional thoughts here--maybe link some of the information from Brice's blog?

[ArthurHNL]

Maybe also document which features need to be implemented "manually", for example I had to specify a standard default value for concurrency tokens, a converter for concurrency tokens, a comparer for concurrency tokens and a converter for datetimeoffssets

[musicm122]

Documentation on Registering with Dependency Injection and maintaining re-hydrating state across multiple tests would be useful as well.

[Timovzl]

I only just spotted this and haven't tried it, but perhaps it's made for this scenario:
Sharable in-memory

Data Source=Sharable;Mode=Memory;Cache=Shared

[Ninjanaut]

It's probably obvious, but there is no mention which Nuget package to install if someone want to use EF Sqlite in-memory feature.

[ajcvickers]

@Ninjanaut It doesn't require a different NuGet package; it's a feature built in to SQLite.