efcore.pg
EFCore.BulkExtensions
Our great sponsors
| efcore.pg | EFCore.BulkExtensions | |
|---|---|---|
| 5 | 16 | |
| 1,456 | 3,472 | |
| 1.9% | - | |
| 8.7 | 9.0 | |
| 17 days ago | 4 days ago | |
| C# | C# | |
| PostgreSQL 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.
efcore.pg
-
Relational is more than SQL
LINQ in EntityFramework (EF) supports querying JSON columns as objects [1].
unnest support is on the roadmap for EF core for PG [2], but already supported for Couchbase [3].
[1] https://learn.microsoft.com/en-ca/ef/core/what-is-new/ef-cor...
[2] https://github.com/npgsql/efcore.pg/issues/1525
[3] https://github.com/couchbaselabs/Linq2Couchbase/blob/master/...
-
Table partitioning in Postgres from Migration
Sure. I readed https://event-driven.io/en/postgres_superpowers/ and i was curious about implementing partitioning in pg so i searched but i found there are not much results, except this open issue https://github.com/npgsql/efcore.pg/issues/1035. Also there is a pull request from April 2021 to handle this but it fail some tests https://github.com/npgsql/efcore.pg/pull/1789.
-
Poll results, repository pattern over Entity Framework?
Place I joined is using InMemoryProvider for tests. I tried upgrading to .net 6 and the .net 6 npgsql driver. Certain things bit us like no more support for EF.Functions.Like.
-
Are all popular APIs moving to Cursor based pagination?
EF core with PostgreSQL now supports it
https://github.com/npgsql/efcore.pg/pull/2350
- Announcing Entity Framework Core 6.0 Preview 4: Performance Edition
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?
Marten - .NET Transactional Document DB and Event Store on PostgreSQL
EntityFramework-Plus - Entity Framework Plus extends your DbContext with must-haves features: Include Filter, Auditing, Caching, Query Future, Batch Delete, Batch Update, and more
FluentMigrator - Fluent migrations framework for .NET
EntityFramework.Exceptions - Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL, SQLite, Oracle and MySql.
pdd-demo - PostgreSQL Driven Development Demo Web Application With PgRoutiner, .NET and Svelte
ASP.NET Core - ASP.NET Core is a cross-platform .NET framework for building modern cloud-based web applications on Windows, Mac, or Linux.
EntityFramework-Reverse-POCO-Code-First-Generator - EntityFramework Reverse POCO Code First Generator - Beautifully generated code that is fully customisable. This generator creates code as if you reverse engineered a database and lovingly created the code by hand. It is free to academics (you need a .edu or a .ac email address), not free for commercial use. Obtain your licence from
efcore-tests - Análise do funcionamento do método SaveChanges do Entity Framework Core
EntityFramework.Docs - Documentation for Entity Framework Core and Entity Framework 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
Hashids.java - Hashids algorithm v1.0.0 implementation in Java
Dapper - Dapper - a simple object mapper for .Net [Moved to: https://github.com/DapperLib/Dapper]