Currently, MusicStore assumes that SQL is available when running on full Windows (it uses the in-memory store on non-Windows, Mono, and Nano Server). This causes problems when running MusicStore on full Windows without SQL, since it hangs for many seconds before finally displaying a SQL error. A common scenario is running MusicStore on a Windows Server container without SQL.
We should make one of the following improvements:
Platform.UseInMemoryStore should check for what it actually needs (SQL Server), rather than assume SQL is installed on Windows. This way, MusicStore would "just work" on Windows without SQL.
Add an environment variable to control whether MusicStore uses SQL or in-memory. This would be easy to set in a Windows Container dockerfile.
Currently, MusicStore assumes that SQL is available when running on full Windows (it uses the in-memory store on non-Windows, Mono, and Nano Server). This causes problems when running MusicStore on full Windows without SQL, since it hangs for many seconds before finally displaying a SQL error. A common scenario is running MusicStore on a Windows Server container without SQL.
We should make one of the following improvements:
Platform.UseInMemoryStore
should check for what it actually needs (SQL Server), rather than assume SQL is installed on Windows. This way, MusicStore would "just work" on Windows without SQL.