EFCore迁移整理

• Z时代
• 2024-01-10
• 分类：综合

创建迁移

PowerShell
Add-Migration InitialCreate
多数据源
Add-Migration InitialCreate -Context MyDbContext -OutputDir Migrations\SqlServerMigrations
Add-Migration InitialCreate -Context MySqliteDbContext -OutputDir Migrations\SqliteMigrations
Console
dotnet ef migrations add InitialCreate
dotnet ef migrations add InitialCreate --context MyDbContext --output-dir Migrations/SqlServerMigrations
dotnet ef migrations add InitialCreate --context MySqliteDbContext --output-dir Migrations/SqliteMigrations

更新数据库

PowerShell
Update-Database
Console
dotnet ef database update

删除迁移

PowerShell
Remove-Migration
Console
dotnet ef migrations remove

还原迁移

PowerShell
Update-Database LastGoodMigration
Console
dotnet ef database update LastGoodMigration

生成迁移Sql

PowerShell
Script-Migration
Script-Migration -From migrationName1 -To migrationName2  -Context ContextName
Console
dotnet ef migrations script
dotnet ef migrations script -From migrationName1 -To migrationName2  -Context ContextName

            var __data = _service.IQueryable(expression)
                .GroupJoin(_sysUserService.IQueryable(), sub => sub.UserId, user => user.UserId, (x, y) => new { sub = x, user = y })
                .SelectMany(xy => xy.user.DefaultIfEmpty(), (x, y) => new { sub = x.sub, user = y })
                .Select(x => new SysSubjectViewModel
                {
                    SubId = x.sub.SubId,
                    SubName = x.sub.SubName,
                    CreatePerson = x.sub.CreatePerson,
                    CreateTime = x.sub.CreateTime,
                    IsPrivate = x.sub.IsPrivate,
                    UserCode = x.user.UserCode,
                    UserName = x.user.UserName
                });

以上是 EFCore迁移整理 的全部内容， 来源链接： utcz.com/z/509548.html