Detached-Mapper
EFCore.BulkExtensions
Our great sponsors
Detached-Mapper | EFCore.BulkExtensions | |
---|---|---|
1 | 16 | |
126 | 3,472 | |
- | - | |
8.6 | 9.0 | |
3 months ago | 3 days ago | |
C# | C# | |
MIT License | 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.
Detached-Mapper
-
How do you add complex objects in EF Core - A new object containing a collection of new and existing items.
You can configure this mapper to do it for you: https://github.com/leonardoporro/Detached-Mapper
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
What are some alternatives?
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
EntityFramework-Plus - Entity Framework Plus extends your DbContext with must-haves features: Include Filter, Auditing, Caching, Query Future, Batch Delete, Batch Update, and more
MockQueryable - Mocking Entity Framework Core operations such ToListAsync, FirstOrDefaultAsync etc
efcore.pg - Entity Framework Core provider for PostgreSQL
Pomelo.EntityFrameworkCore.MySql - Entity Framework Core provider for MySQL and MariaDB built on top of MySqlConnector
EntityFramework.Exceptions - Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL, SQLite, Oracle and MySql.
TimeZoneMapper - Library for mapping *N*X TimeZone ID's (e.g. Europe/Amsterdam) to .Net's TimeZoneInfo classes.
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
dotnet-api-minimal - Minimal API example in .NET 6
FlexLabs.Upsert - FlexLabs.Upsert is a library that brings UPSERT functionality to common database providers for Entity Framework in their respective native SQL syntax