ASP.Net Core开发电商后端API 吃透RESTful风格

基于 docker 完成数据库的启动

• 创建 mssql 数据库服务

docker run -d --name asp-mssql -p 1433:1433 -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Sa123456" microsoft/mssql-server-linux

docker ps

docker logs asp-mssql

• 完成基于注解的属性配置

    public class TouristRoutePicture
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }

        [MaxLength(100)]
        public string Url { get; set; }

        [ForeignKey(nameof(TouristRouteId))]
        public Guid TouristRouteId { get; set; }

        public virtual TouristRoute TouristRoute { get; set; }
    }

• 添加依赖项

  <ItemGroup>
    <PackageReference Include="Microsoft.EntityFrameworkCore" Version="3.1.10" />
    <PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="3.1.10" />
    <PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="3.1.10">
      <PrivateAssets>all</PrivateAssets>
      <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
    </PackageReference>
  </ItemGroup>

• 在 Package Manage Console 执行数据库迁移命令

add-migration Init

update-database

• 或者在 Command Line 中输入命令：

  • 全局安装ef工具：dotnet tool install --global dotnet-ef

dotnet ef migrations add Init

dotnet ef database update

• 添加种子数据

add-migration SeedData

update-database

• 完成数据库结构的更新

add-migration updateTouristRoute

update-database

启用 MySQL 数据库

• 创建 mysql 数据库服务

docker run -itd --name asp-mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql

• 安装依赖

<ItemGroup>
    <PackageReference Include="Microsoft.EntityFrameworkCore" Version="3.1.10" />
    <PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="3.1.10">
      <PrivateAssets>all</PrivateAssets>
      <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
    </PackageReference>
    <PackageReference Include="Pomelo.EntityFrameworkCore.MySql" Version="3.2.4" />
  </ItemGroup>

• 删除 Migrations 文件夹全部内容，并重新开始数据库迁移

add-migration mysqlInit

update-database

容器化部署 .NET Core API

• Dockerfile

#See https://aka.ms/containerfastmode to understand how Visual Studio uses this Dockerfile to build your images for faster debugging.

FROM mcr.microsoft.com/dotnet/core/aspnet:3.1-buster-slim AS base
WORKDIR /app
EXPOSE 80
# EXPOSE 443

FROM mcr.microsoft.com/dotnet/core/sdk:3.1-buster AS build
WORKDIR /src
COPY ["FakeXiecheng.Api.csproj", "./"]
RUN dotnet restore "./FakeXiecheng.Api.csproj"
COPY . .
WORKDIR "/src/."
RUN dotnet build "FakeXiecheng.Api.csproj" -c Release -o /app/build

FROM build AS publish
RUN dotnet publish "FakeXiecheng.Api.csproj" -c Release -o /app/publish

FROM base AS final
WORKDIR /app
COPY --from=publish /app/publish .
ENTRYPOINT ["dotnet", "FakeXiecheng.Api.dll"]

• 创建并启动

docker build -t fakexiechengapi .
docker run -d --name fakexiechengapi -p8080:80 fakexiechengapi
docker ps

• 找到 docker 容器中的数据库 IP 地址

docker inspect bridge

• 修改数据库连接字符串中的 localhost 为 172.17.0.2

• 删除镜像，重新构建镜像并启动容器

docker stop fakexiechengapi
docker rm fakexiechengapi
docker build -t fakexiechengapi .
docker run -d --name fakexiechengapi -p8080:80 fakexiechengapi
docker ps