bulk-writer
EFCore.BulkExtensions
bulk-writer | EFCore.BulkExtensions | |
---|---|---|
2 | 16 | |
237 | 3,472 | |
0.0% | - | |
0.0 | 9.0 | |
4 months ago | 7 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.
bulk-writer
-
Bulk inserts/update
You can check out my BulkWriter library: https://github.com/jbogard/bulk-writer it’s basically “LINQ-2-SqlBulkInsert”.
- 1.3 GB CSV imported via EF Core in 6 min with EFCore.BulkExtensions
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?
Reactive ETL - Reactive ETL is a rewrite of Rhino ETL using the reactive extensions for .Net.
EntityFramework-Plus - Entity Framework Plus extends your DbContext with must-haves features: Include Filter, Auditing, Caching, Query Future, Batch Delete, Batch Update, and more
kraken-trades-database
efcore.pg - Entity Framework Core provider for PostgreSQL
LINQ to DB - Linq to database provider.
EntityFramework.Exceptions - Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL, SQLite, Oracle and MySql.
versatile-data-kit - One framework to develop, deploy and operate data workflows with Python and SQL.
ASP.NET Core - ASP.NET Core is a cross-platform .NET framework for building modern cloud-based web applications on Windows, Mac, or Linux.
postgresql-to-mssql - Migrate postgresql data to sql server on the fly!
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]