Comments (3)
There was no support for SQLite initially, but latter it was added.
Here are some links about improving performance when using SQLite:
http://procbits.com/2009/09/08/sqlite-bulk-insert
http://blog.quibb.org/2010/08/fast-bulk-inserts-into-sqlite/
https://www.jokecamp.com/blog/make-your-sqlite-bulk-inserts-very-fast-in-c/
from efcore.bulkextensions.
SQLite is now also supported, from version 2.6.0
from efcore.bulkextensions.
I was looking for SqliteBulkCopy and found some source in the following link thanks to doughjoe77:
aspnet/Microsoft.Data.Sqlite#289, which is now closed.
I had to fix the following issues, then it worked fine (a bit on the slow side). I would like to share my corrections:
- [] had to be added to column names, since special names like "Order" do not work with INSERT, so this would become "[Order]".
- For REAL numbers ',' had to be replaced by '.' since values like 0,1 (in my country representation) were inserted as "0","1" with one value too much.
- The string generated for the INSERT containes \r\n (CR LR) characters, presumably inserted by the StringBuilder. These had to be extracted.
from efcore.bulkextensions.
Related Issues (20)
- When using PostgreSQL to batch insert DateTime.Now data, there might be a time offset.
- BulkExtensions determines target DbContext incorrectly when calls to different database servers in parallel HOT 1
- VULN: CVE-2024-32655 in Npgsql dependency HOT 3
- BulkInsertOrUpdate doesn't return Identity when no insert or update happen
- not present in the dictionary.
- can BulkInsert support my custom ValueGenerator for Id column HOT 1
- BulkSaveChangesAsync leaves tracked entities in state of "Added" even after successful save. HOT 2
- Spatial support in SQLite for Point
- BulkRead: System.NotSupportedException: 'Specified method is not supported.'
- BulkInsert produces sytanx error on PostgreSQL (version 6.x) HOT 1
- Bulk operation fails when owned type has enum member on PostgreSQL
- `SharedTypeEntity` don't work with bulk operations HOT 1
- [MySql/MariaDb] Insert an boolean type has invalid result (Always insert true in a bit column) HOT 3
- Question : Set value on shadow properties "on save" HOT 1
- Unable to cast object of type 'System.Int64' to type 'System.Nullable`1[System.Int32]' HOT 1
- PostgreSQL Table-Per-Hierarchy Inheritance Is Not Working HOT 1
- Truncate method with custom table name HOT 1
- BulkInsertAsync is assigning negative values to inserted entries' primary keys HOT 9
- MySQL Failure when using Reserved Words for Table name
- BulkUpdateAsync throws KeyNotFoundException on OwnsMany with JSONB column
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from efcore.bulkextensions.