Using the following method, with returnId = true produces invalid SQL
public Query AsInsert(IEnumerable<string> columns, IEnumerable<IEnumerable<object>> valuesCollection, bool returnId = false)
INSERT INTO [expensive_cars] ([name], [brand], [year]) VALUES (?, ?, ?);SELECT scope_identity() as Id, (?, ?, ?), (?, ?, ?)
The parameter returnId should likely be removed from this method. Attempting to select id's back from a multiple insert requires platform-specific technique
Using the following method, with returnId = true produces invalid SQL
The parameter returnId should likely be removed from this method. Attempting to select id's back from a multiple insert requires platform-specific technique