Instead Test options are SqlServer(Developer or Express), LocalDb( if alongside Developer v.), or for other adapters PostgreSQL/MySQL/SQLite. SQLite has no Copy tool, instead library uses plain SQL combined with UPSERT.īulk Tests can not have UseInMemoryDb because InMemoryProvider does not support Relational-specific methods. MySQL (8+) is using MySqlBulkCopy combined with ON DUPLICATE for Update. PostgreSQL (9.5+) is using COPY BINARY combined with ON CONFLICT for Update. SQLServer (or SqlAzure) under the hood uses SqlBulkCopy for Insert, Update/Delete = BulkInsert + raw Sql MERGE. When opening issues do write detailed explanation of the problem or feature with reproducible example. Please read CONTRIBUTING for details on code of conduct, and the process for submitting pull requests. OpenSource needs funding, so even for free usage if you can please consider making a DONATION: If you find this project useful you can mark it by leaving a Github Star ⭐. BulkExtensions are licensed under the Dual License v1.0 which you must Buy if do not meet criteria for free usage (license also includes active support).Supports all 4 mayor databases: SQLServer, PostgreSQL, MySQL, SQLite License Was selected in top 20 EF Core Extensions recommended by Microsoft. Library is Lightweight and very Efficient, having all mostly used CRUD operation. Batch ops: Delete, Update - will be Deprecated since EF7 has native Execute-Up/Del and Truncate. Bulk operations: Insert, Update, Delete, Read, Upsert, Sync, SaveChanges (extremely fast)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |