Stack Overflow
Stack Overflow

Questions tagged [entity-framework-extensions]

37 questions
6
votes
1 answer

Differense between EF Extensions UpdateFromQuery() and EF Plus Update()

The library Entity.Framework.Extensions (paid) has a method for doing entity updates: context.Customers .Where(c=>c.XXX = "") .UpdateFromQuery(c=>new Customer{ Timestamp = DateTime.UtcNow }) The library Entity.Framework.Plus (free) has a similar…
Freddy
  • 329
  • 1
  • 4
  • 10
3
votes
1 answer

Entity Framework extension's batch operations vs EFE's bulk operations

I was looking into Entity Framework extensions for bulk operations and I found from the same developers EF Plus. Now EFE has bulk operations which are payed and EF PLus has Batch operations, which claim to perform bulk update and delete only, but…
Radoslav.Ivanov
  • 413
  • 3
  • 16
2
votes
1 answer

Entity Framework Extensions Recursive Query

There is a hierarchical query support in a popular EF extensions library: https://entityframework-extensions.net/to-self-hierarchy-list. I'm curious how does it work under the hood? Is it getting handled by SQL server, meaning that the query is…
Grigoryants Artem
  • 1,401
  • 2
  • 15
  • 32
1
vote
0 answers

Fluent API: Define both "many to many" as relationship and as relationship object too

I've always defined my many-to-many relationships like this: modelBuilder.Entity() .HasMany(i => i.Brands) .WithMany(p => p.PriceLists) .Map(m => { m.ToTable("PriceListsBrands"); …
sports
  • 7,851
  • 14
  • 72
  • 129
1
vote
2 answers

C# Entity Framework: Bulk Extensions Input Memory Issue

I am currently using EF Extensions. One thing I don't understand, "its supposed to help with performance" however placing a million+ records into List variable, is a Memory Issue itself. So If wanting to update million records, without holding…
user12425844
1
vote
2 answers

Bulk Insert with child entities using EF6 extensions

I'm getting an error everytime I try to bulk insert using EF6 Extensions library When using IncludeGraph, some options must be set in the IncludeGraphBuilder (See: https://entityframework-extensions.net/include-graph). The following options…
Mohamed Said
  • 524
  • 7
  • 27
1
vote
0 answers

FreeText in Entity Framework Core

I am trying to implement search and I am using entity framework core. I tried using the following query- var users = await context.Users.Where(u => EF.Functions.FreeText(u.UserName, searchString)).ToListAsync(); This query is throwing the following…
Nemesis
  • 135
  • 1
  • 1
  • 13
1
vote
1 answer

Specified type is not registered on the target server EF Core for spatial point bulk insert

I am using .NET Core MVC, Entity Framework Core, Entity Framework Extensions. I am trying to insert bulk addresspoint in EF Core through BulkInsertAsync method, but I am getting an error Specified type is not registered on the target server As…
Dnyaneshwar Shivbhakta
  • 21
  • 4
1
vote
1 answer

EFPlus BulkInsert - How to get DB-generated IDs

Using MSSQL with IDENTITY column for IDs, how can I get entity IDs synchronized with table IDs after calling BulkInsert? context.BulkInsert(entities); Neither of both achieves the requested…
stackOnRails
  • 13
  • 4
1
vote
1 answer

BulkSynchronize remove subset data VB.NET

I am using Entity Framework Extensions (EFE) in VB.Net project and I wanna to know how to write below mentioned C# Syntax in VB.Any help is appreciated ctx.BulkSynchronize(list, options => options.ColumnSynchronizeDeleteKeySubsetExpression = c =>…
user3543888
  • 85
  • 1
  • 8
1
vote
1 answer

Clarification on what exactly is cached by EF Plus

If I have a table of service requests and I run the following code on it: var serviceRequest = await _ctx.ServiceRequests.DeferredAny(t => t.Id == h.Id).FromCacheAsync("ServiceRequestByID"); Would that be the same as saying save this query: SELECT…
BinaryNexus
  • 875
  • 3
  • 15
  • 30
1
vote
1 answer

Last Modified properties when using Entity Framework Extensions bulk methods

I'm trying out EFE for a large data syncing operation, and since it will involve either mass amounts of inserts or mass amounts of updates I've gone with the BulkMerge method. Our old way involved shoving everything into a giant complex data graph…
Yoten
  • 33
  • 5
1
vote
1 answer

bulk insert using EntityFramework-Plus

I was planning to use EntityFramework-Plus for bulk operations however i am not sure if it supports bulk insert. So for example, i have Parent entities and i want to insert Child entities in bulk how do i dot that using EF Plus In code below number…
LP13
  • 30,567
  • 53
  • 217
  • 400
0
votes
0 answers

Entity Framework Extension Mismatch Error with Oracle DB (EDMX model)

I'm currently using Entity Framework Extensions (version 7.22.4) on .NET Framework 4.8, with Entity Framework (version 6.4.4). My database is Oracle and I'm using Devart (version 9.11). I am trying to replace all my SaveChanges() calls with…
spad'
  • 79
  • 4
0
votes
0 answers

Entity Framework extensions - BulkInsert not working when specifying unique index properties

I have an entity that has an ID field, as well as few other properties who are set on unique index. await _context.Declarations.BulkInsertAsync(declarations, o => { o.IncludeGraph = true; …
Mefhisto1
  • 2,188
  • 7
  • 34
  • 73
1
2 3