平台网站建设费用,wordpress 必选插件,做网站有兼职的吗,广东个人网站备案这是Entity Framework Core的一个轻量的扩展#xff0c;提供批量更新和删除操作的支持。而且这个库出自中国一位MVP之手#xff0c;虽然内容是英文#xff0c;也很简单#xff0c;相信你也能看懂。 This is a light-weight extension which provides bulk update and delet… 这是Entity Framework Core的一个轻量的扩展提供批量更新和删除操作的支持。而且这个库出自中国一位MVP之手虽然内容是英文也很简单相信你也能看懂。 This is a light-weight extension which provides bulk update and delete operations for Entity Framework Core. View source on GitHubDownload from NuGet Getting Started ① Add Pomelo.EntityFrameworkCore.Lolita package into your project.json. There are many different special versions for different EF database provider: Pomelo.EntityFrameworkCore.Lolita.MySqlPomelo.EntityFrameworkCore.Lolita.SqlServerPomelo.EntityFrameworkCore.Lolita.PostgreSQLPomelo.EntityFrameworkCore.Lolita.Sqlite ② Configure your DbContext For ASP.NET Core developers, you can Use lolita extensions when adding the DbContext into services collection: services.AddDbContextModels.SampleContext(x
{x.UseMySql( serverlocalhost;databaselolita;uidroot;pwdyourpwd;);x.UseMySqlLolita();
}); For .NET Core developers, you can override the OnConfiguring of DbContext to use lolita: protected override void OnConfiguring( DbContextOptionsBuilder optionsBuilder){optionsBuilder.UseMySql( serverlocalhost;databaselolita;uidroot;pwdyourpwd;);optionsBuilder.UseMySqlLolita(); base.OnConfiguring(optionsBuilder);
} ③ There are many different extended methods for updating a column or bulk deleting. Updating: db.Posts.Where(x x.Time DateTime.Now).SetField(x x.IsPinned).WithValue(false).Update(); You can also use the following methods to update a field: MethodSQLHintWithValueSET [x] valuePlusSET [x] [x] valueNumeric onlySubtractSET [x] [x] - valueNumeric onlyMultiplySET [x] [x] * valueNumeric onlyDivideSET [x] [x] / valueNumeric onlyModSET [x] [x] % valueNumeric onlyPrependSET [x] value [x]String onlyAppendSET [x] [x] valueString onlyAddMillisecondsSET [x] DATEADD(ms, value, [x])DateTime onlyAddSecondsSET [x] DATEADD(ss, value, [x])DateTime onlyAddMinutesSET [x] DATEADD(mi, value, [x])DateTime onlyAddHoursSET [x] DATEADD(hh, value, [x])DateTime onlyAddDaysSET [x] DATEADD(dd, value, [x])DateTime onlyAddMonthsSET [x] DATEADD(mm, value, [x])DateTime onlyAddYearsSET [x] DATEADD(yy, value, [x])DateTime only Deleting: db.Users.Where(x db.Posts.Count(y y.UserId x.Id) 0).Where(x x.Role UserRole.Member).Delete(); Contribute One of the easiest ways to contribute is to participate in discussions and discuss issues. You can also contribute by submitting pull requests with code changes. License MIT 相关文章 全球首发免费的MySql for Entity Framework Core.NET Core 使用Dapper 操作MySQL在.NET Core中使用MySQL5.7的JSON类型字段 原文地址http://www.1234.sh/post/ef-core-lolita .NET社区新闻深度好文微信中搜索dotNET跨平台或扫描二维码关注
