sql-server - Docker-compose 覆盖不覆盖连接字符串

Question

我有一个连接到 SQL 数据库的 ASP.NET Web 应用程序。

在 appsettings.Development.json 中，连接字符串定义为

"ConnectionStrings": {
    "DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=WebRecipes-LocalDev;Trusted_Connection=True;ConnectRetryCount=0"
  }

在我的 docker-compose.yml 文件中，我得到了最新的 mssql-server-linux

services:
  sql.data:
      image: microsoft/mssql-server-linux:2017-latest

  webrecipes.api:
     image: ${DOCKER_REGISTRY-}webrecipesapi
     build:
       context: .
       dockerfile: src/WebRecipes.Api/Dockerfile

在 docker-compose.override.yml 中，我为 sql.data 设置了用户名和密码，并覆盖了我的 asp.net 核心应用程序的连接字符串

services:
  sql.data:
    environment:
      - SA_PASSWORD=Pass@word
      - ACCEPT_EULA=Y
    ports:
      - "5533:1433"

  webrecipes.api:
    environment:
      - ASPNETCORE_ENVIRONMENT=Development
      - ASPNETCORE_URLS=https://+:443;http://+:80
      - ASPNETCORE_HTTPS_PORT=44302
      - ConnectionString=Server=sql.data;database=WebRecipes-LocalDev;User Id=sa;Password=Pass@word
    ports:
      - "2282:80"
      - "44302:443"
    volumes:
      - ${APPDATA}/ASP.NET/Https:/root/.aspnet/https:ro
      - ${APPDATA}/Microsoft/UserSecrets:/root/.microsoft/usersecrets:ro
    depends_on:
      - sql.data

编辑: 我也尝试将连接字符串设置为:

- ConnectionStrings:DefaultConnection=sql.data;database=WebRecipes-LocalDev;User Id=sa;Password=Pass@word

When I run the app and it first tries to hit the db I get error saying LocalDb is not supported as it is using the connection string defined in appsettings.Development.json

有人能帮忙吗？我不明白我做错了什么......

Answer 1

使用双下划线对我有用

ConnectionStrings__DefaultConnection=sql.data;database=WebRecipes-LocalDev;User Id=sa;Password=Pass@word