In memory or sql–part 27

When I want to perform tests , the SqlServer in memory is enough good. But , when in production, should have a proper connection string.

So I figured a simple way to understand this: if no connection string in appsettings.json, then use InMemory Sql Server . If there is, it should be a read connection string.

First, I have tried with


– but this is the old XML way – does not work with appsettings.json

I did not want to have DI in the constructor to read the file – so I realized that I can do this:

configuration = new ConfigurationBuilder()

This is not so good – because the code for retrieving looks like this:

DbContextOptionsBuilder<InfoValutarContext> opt;
var ConnectionString = InMemoryDB.sing.GetConRead(“DBRead”);

if (string.IsNullOrWhiteSpace(ConnectionString ))
opt = InMemoryDB.sing.MemoryOptions();
opt = new DbContextOptionsBuilder<InfoValutarContext>();

However,adding save and retrieve code ( with interfaces) , adding tests , adding controllers and DI on the WebAPI takes 1 hour

The commit is and has 11 files .


And one hour passes...
(This is the result of 1 hour per day auto-challenge as a full cycle developer for an exchange rates application)
( You can see the sources at )
2Reading NBR from internet
3Source control and build
4Badge and test
5CI and action
6Artifacts and dotnet try
7Docker with .NET Try
9Intermezzo - Various implementations for programmers
10Intermezzo - similar code - options
11Plugin implementation
12GUI for console
14Plugin in .NET Core 3
15Build and Versioning
16Add swagger
17Docker - first part
18Docker - second part
19Docker - build Azure
20Pipeline send to Docker Hub
21Play with Docker - online
22Run VSCode and Docker
23Deploy Azure
24VSCode see tests and powershell
25Code Coverage
26Database in Azure
27Sql In Memory or Azure
28Azure ConString, RSS
29Middleware for backward compatibility
30Identical Tables in EFCore
31Multiple Data in EFCore
32Dot net try again
33Start Azure Function
34Azure function - deploy
35Solving my problems
36IAsyncEnumerable transformed to IEnumerable and making Azure Functions works
37Azure functions - final
38Review of 37 hours
39Last Commit in AzureDevOps
40Create Angular WebSite
41Add static Angular to WebAPI .NET Core
42Docker for Angular
43Angular and CORS
44SSL , VSCode, Docker
45Routing in Angular
46RxJS for Routing
47RxJs Unsubscribe