Entity Framework Core - Knowledge Base (KB)

Entity Framework - How to Insert to table with foreign keys without retrieving foreign table rows first

I'm having a hard time finding the exact answer to this question, so my apologies if this is redundant....So I have 3 tables defined such that:...Person :PersonId, FirstName, LastName...Company: CompanyId, CompanyName...Order: OrderId, PersonId, CompanyId...

How do I execute a bulk `INSERT IGNORE` with Entity Framework Extensions library

I'm trying to insert a large set of objects into the table but I don't have any efficient way to check if some records aren't already there. Every time I use this:...using Z.EntityFramework.Extensions.Core; ... await ac.BulkInsertAsync(query, (o) => { o.?...

Entity Framework just stopping with timeout during INSERT

I have a small c# application which using Entitiy Framework 6 to parse text files into some database structure. ...In general file content is parsed into 3 tables: ...Table1 --(1-n)-- Table2 --(1-n)-- Table3 ...the application worked for months withou...