I noticed SqlKata was able to insert multiple records with one query by providing an IEnumerable<string> as columns IEnumerable<IEnumerable<object>> as values; which works great, however it feels a bit awkward to use. Especially since there is an implementation of AsInsert() that can take an object. So, I think it would make sense to have an overload of AsInsert() (and therefore of Insert() and InsertAsync()) which takes an IEnumerable<object> and compile the relevant query.
If you feel like this could be a nice addition to the library, I could try myself at a PR.
JakeAlmer
commented
1 year ago
Hi !
I noticed SqlKata was able to insert multiple records with one query by providing an
IEnumerable<string>as columnsIEnumerable<IEnumerable<object>>as values; which works great, however it feels a bit awkward to use. Especially since there is an implementation ofAsInsert()that can take an object. So, I think it would make sense to have an overload ofAsInsert()(and therefore ofInsert()andInsertAsync()) which takes anIEnumerable<object>and compile the relevant query.If you feel like this could be a nice addition to the library, I could try myself at a PR.
Cheers :)