EFCore.BulkExtensions
SqlSugar
| EFCore.BulkExtensions | SqlSugar | |
|---|---|---|
| 16 | - | |
| 3,504 | 5,067 | |
| - | - | |
| 9.0 | 10.0 | |
| 5 days ago | 2 days ago | |
| C# | C# | |
| GNU General Public License v3.0 or later | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
EFCore.BulkExtensions
-
Best way to do mass inserts with Entity Framework
EF Core Bulk Extensions has helped me out many a day.
-
Upserting complex data models from an API into EF Core entities
I have used this and found it to have everything I need. It has a dual license though but if it is for personal use you dont have to worry about that. https://github.com/borisdj/EFCore.BulkExtensions
-
Bulk inserts/update
EF Core works for me and inserting/updating several thousand records at a time. I also found this nuget that works great https://github.com/borisdj/EFCore.BulkExtensions
-
What do you use in a production application?
Using EF core with migrations. Anything that we can’t do out of the box, we can normally do with the bulk extensions (https://github.com/borisdj/EFCore.BulkExtensions). There were two specific places I had to drop back to raw SQL, one was for a specific SELECT query that needed to be optimised, the second was a stored proc doing a MERGE that we pass in a table type (upsert of 100k records)
- Does Anyone Know a FAST Way to Update Large Number of SQLite Records (LINQ or otherwise)?
-
How might one create custom Entity Framework translations for things like the "IN" clause?
There is however a free nuget for EF Core which supports OP's needs https://github.com/borisdj/EFCore.BulkExtensions
-
Updating multiple entities properties in EF Core
For EFCore v6, you're best using EFCore.BulkExtensions, to do something like this:
-
Entity Framework Pitfalls?
I've been using this library with great success: EFCore.BulkExtensions
-
EF Core Quiz #1
2nd option as you're basically doing batch save changes where batch size is 100. You should put a transaction on top of all of this though and commit at the end for data integrity reasons but that's about it. Alternatively use a NuGet that can do batch save changes (Z.EntotyFramework is paid, but https://github.com/borisdj/EFCore.BulkExtensions is free).
- C# LINQ Question
SqlSugar
We haven't tracked posts mentioning SqlSugar yet.
Tracking mentions began in Dec 2020.
What are some alternatives?
EntityFramework-Plus - Entity Framework Plus extends your DbContext with must-haves features: Include Filter, Auditing, Caching, Query Future, Batch Delete, Batch Update, and more
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
efcore.pg - Entity Framework Core provider for PostgreSQL
Dapper - Dapper - a simple object mapper for .Net [Moved to: https://github.com/DapperLib/Dapper]
EntityFramework.Exceptions - Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL, SQLite, Oracle and MySql.
FreeSql - 🦄 .NET aot orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, QuestDB orm, MsAccess orm.
ASP.NET Core - ASP.NET Core is a cross-platform .NET framework for building modern cloud-based web applications on Windows, Mac, or Linux.
LINQ to DB - Linq to database provider.
efcore-tests - Análise do funcionamento do método SaveChanges do Entity Framework Core
Dapper.MicroCRUD - CRUD Extensions for Dapper.Net
FlexLabs.Upsert - FlexLabs.Upsert is a library that brings UPSERT functionality to common database providers for Entity Framework in their respective native SQL syntax
Entity Framework 6 - This is the codebase for Entity Framework 6 (previously maintained at https://entityframework.codeplex.com). Entity Framework Core is maintained at https://github.com/dotnet/efcore.