EF Core 迁移整理
2024-08-31 15:22:24
创建迁移
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
});
最新文章
- CSS实现的手风琴特效
- 错误信息:attempt to create saveOrUpdate event with null entity
- iOS开发——高级篇——UIDynamic 物理引擎
- python_day2
- tyvj4221 货车漂移
- BAT文件执行完成后如何删除自身的解决办法
- 黑色遮罩引导蒙版 CSS实现方式
- 【新手--android日记】实现IOS风格电话界面
- linux之SQL语句简明教程---COUNT
- HBASE完全分布式模式的安装
- 百度,google的地理编码
- CJOJ 2255 【NOIP2016】组合数问题 / Luogu 2822 组合数问题 (递推)
- 【译】10分钟学会Pandas
- LocalBroadcastManager—创建更高效、更安全的广播
- Python--day03(变量、数据类型、运算符)
- c#中委托和事件(转)
- Hello 2019 (D~G)
- android打印日志封装
- 【ActiveMQ入门-5】ActiveMQ学习-消息持久性
- 2018软工实践—Beta冲刺(4)