Bug Description
Trying to insert a list of entities using InsertAll() or InsertAllAsync() ends up throwing exception. I am using SQLite. Since this is a playground project, feel free to poke around it:
bug sample repository.
Simply run the project, and open in browser http://localhost:5157/seed endpoint (or curl postman, whatever). This should reproduce the exception.
Interestingly MergeAll and MergeAllAsync work correctly. I'm yet to test transactional behavior. Maybe I'm just missing some detail here.
P.S.
Very cool project :)
Exception Message:
System.Data.SQLite.SQLiteException: 'SQL logic error
near "(": syntax error'
-- generated SQL
INSERT INTO [Author] ( [Name], [Id] ) SELECT [Name], [Id] FROM ( VALUES ( @Name, @Id , @__RepoDb_OrderColumn_0 ) , ( @Name_1, @Id_1 , @__RepoDb_OrderColumn_1 ) ) AS T ( [Name], [Id] , [__RepoDb_OrderColumn] ) ORDER BY [__RepoDb_OrderColumn] ; SELECT CAST(@Id AS TEXT) AS [Result], @__RepoDb_OrderColumn_0 AS [OrderColumn] ;
Library Version:
RepoDb v1.13.2-alpha1
Bug Description
Trying to insert a list of entities using
InsertAll()orInsertAllAsync()ends up throwing exception. I am using SQLite. Since this is a playground project, feel free to poke around it:bug sample repository.
Simply run the project, and open in browser
http://localhost:5157/seedendpoint (or curl postman, whatever). This should reproduce the exception.Interestingly
MergeAllandMergeAllAsyncwork correctly. I'm yet to test transactional behavior. Maybe I'm just missing some detail here.P.S.
Very cool project :)
Exception Message:
Library Version:
RepoDb v1.13.2-alpha1