[Blazor WASM] + MYSQL > C#/.Net/Blazor/IIS

 [Blazor WASM] + MYSQL  

http://sebom.com/gb/bbs/board.php?bo_table=web&wr_id=32 확인 선행

Create Mysql DB+userid+userpwd - projectdb

New Projcet

[Additional information]

- Framework -> .NET6.0

- Authentication type -> Individual Accounts

- [Check] Configure for HTTPS

- [Check] ASP.NET Core hosted

[project.Server]

appsettings.json 

"ConnectionStrings": {

    "DefaultConnection": "Server=localhost;Port=3306;database=projectdb;userid=projectdbuserid;password=projectpassword;charset=utf8"

  }

 Programs.cs

// Add services to the container.

var serverVersion = new MySqlServerVersion(new Version(8, 0, 23));

var connectionString = builder.Configuration.GetConnectionString("DefaultConnection");

builder.Services.AddDbContext<ApplicationDbContext>(options =>

    options.UseMySql(connectionString, serverVersion)

           .EnableDetailedErrors() 

           );

[Nuget]

pomelo.entityframeworkcore.mysql(6.0.0) 설치 -> project.Server

[Package Manager Console]

PM> Add-Migration projectdb <- failed 뜨면 재시도

PM> Update-Database