praeclarum / praeclarum/sqlite-net
InsertOrReplaceAll method is not available in this library
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 4.5k
- Forks
- 1.4k
- PR merge metrics
- No merged PRs in 30d
Description
I am using SQLite.NET-PCL but as it is now no longer being maintained I want to use this package.
But a very strange thing I found is that, this package does not have InsertOrReplaceAll method which is available in SQLite.NET-PCL
I can not use InsertAll or UpdateAll because, prior to using it, I don't know which records are new and which are existing, considering I have pre-set all primarykey values in the List object.
I have posted this issue and sample code on https://stackoverflow.com/questions/47124476/insertall-updateall-in-sqlite-net-pcl-vs-insertorreplaceall-in-sqlite-net-pcl/
If you have a plan adding this feature in upcoming versions, would be awesome!!
If not, please add this feature if possible. This is a very useful method to Insert or Replace lot of records all at once.
Thanks
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing this library's existing InsertAll and UpdateAll behavior, then compare it with SQLite.NET-PCL's InsertOrReplaceAll method and the sample linked in the issue. Done means the package supports inserting or replacing a list when primary keys may identify either new or existing records, with behavior covered by appropriate tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, sqlite
- Domain
- database
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100