EFCore.BulkExtensions
DapperEFCoreQueryPerformance2019
| EFCore.BulkExtensions | DapperEFCoreQueryPerformance2019 | |
|---|---|---|
| 16 | 1 | |
| 3,472 | 21 | |
| - | - | |
| 9.0 | 0.0 | |
| 6 days ago | 4 months ago | |
| C# | C# | |
| GNU General Public License v3.0 or later | - |
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
DapperEFCoreQueryPerformance2019
-
Entity Framework efficiency
So I've downloaded this guy's code from github. The database code looks okay, EF and Dapper are used in a straightforward fashion, as you would expect them to be used. I've changed the runtime to .NET 5 and updated the references to Dapper and EF to their latest version; I've also replaced MS SQL Server (don't have an access to a running instance right now) with PostgreSQL and Npgsql connector, and added a EF-calling variant more closely resembling the Dapper one, projecting the entities into special DTO classes and doing joins on the server, not in the database:
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
efcore.pg - Entity Framework Core provider for PostgreSQL
EntityFramework.Exceptions - Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL, SQLite, Oracle and MySql.
ASP.NET Core - ASP.NET Core is a cross-platform .NET framework for building modern cloud-based web applications on Windows, Mac, or Linux.
efcore-tests - Análise do funcionamento do método SaveChanges do Entity Framework Core
FlexLabs.Upsert - FlexLabs.Upsert is a library that brings UPSERT functionality to common database providers for Entity Framework in their respective native SQL syntax
Dapper - Dapper - a simple object mapper for .Net [Moved to: https://github.com/DapperLib/Dapper]
Detached-Mapper - An ORM friendly mapper. Allows saving entire entity graphs. Heavily inspired in GraphDiff and AutoMapper.
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
sample-httpclientfactory-polly - Example of using HttpClientFactory in .NET Core 3.1 with Swagger, MediatR and Serilog
testcontainers-dotnet - A library to support tests with throwaway instances of Docker containers for all compatible .NET Standard versions.
SqlSugar - .Net aot ORM Fastest ORM Simple Easy Sqlite orm Oracle ORM Mysql Orm postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping