EF Core Migrations
创建一个WebAPI.Migrations
| dotnet new webapi -n WebAPI.Migrations |
Program.cs
| using System.Reflection; |
| using Microsoft.Extensions.DependencyInjection; |
| using Microsoft.EntityFrameworkCore; |
| using Microsoft.Extensions.Configuration; |
| using DataAccess; |
| |
| var builder = WebApplication.CreateBuilder(args); |
| |
| |
| builder.Services.AddDbContext<MusicCollectionDb>( |
| options =>options.UseSqlServer(builder.Configuration.GetConnectionString("MusicDbConnection"),b => b.MigrationsAssembly(Assembly.GetExecutingAssembly().FullName))); |
| |
| var app = builder.Build(); |
| app.UseAuthorization(); |
| app.MapControllers(); |
| app.Run(); |
其他数据库
| var msSqlConnection = builder.Configuration.GetConnectionString("MsSqlConnection"); |
| options.UseSqlServer(msSqlConnection, b => b.MigrationsAssembly(Assembly.GetExecutingAssembly().FullName)); |
| |
| var sqliteConnection = builder.Configuration.GetConnectionString("SqliteConnection"); |
| options.UseSqlite(sqliteConnection, b => b.MigrationsAssembly(Assembly.GetExecutingAssembly().FullName)); |
| |
| var mySqlConnection = builder.Configuration.GetConnectionString("MySqlConnection"); |
| |
| options.UseMySql(mySqlConnection, ServerVersion.AutoDetect(mySqlConnection), b => b.MigrationsAssembly(Assembly.GetExecutingAssembly().FullName)); |
appsettings.json
| { |
| "Logging": { |
| "LogLevel": { |
| "Default": "Information", |
| "Microsoft.AspNetCore": "Warning" |
| } |
| }, |
| "AllowedHosts": "*", |
| "ConnectionStrings": { |
| "MusicDbConnection": "Data Source=localhost;Initial Catalog=musicdb2;User ID=sa;Password=song2030..;Trust Server Certificate=True" |
| } |
| } |
添加迁移文件
| dotnet ef migraitons add init |
| dotnet ef database update |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· 没有源码,如何修改代码逻辑?
· PowerShell开发游戏 · 打蜜蜂
· 在鹅厂做java开发是什么体验
· WPF到Web的无缝过渡:英雄联盟客户端的OpenSilver迁移实战
2022-10-17 idea的vim配置
2022-10-17 vscode的vim设置