UUID_TO_BIN(UUID()) as value when inserting a record

[ansarizafar]

Thanks for the amazing project . I wanted to know is it possible to use UUID_TO_BIN(UUID()) as value when inserting a record?

My second question is why AsInsert() is not Async and why it can't accept transaction?

[ahmad-moussawi]

Hello @ansarizafar, for the first question you can use the UnsafeLiteral expression, check this example on the playground
Unsafe Literal Example

The AsInsert does not execute the query, it just informs the compiler that this query is an INSERT query,
to execute the query you have to use the .Insert() method from the SqlKata.Execution package.

The Insert() method call the AsInsert() method under the hood.

[ansarizafar]

@ahmad-moussawi Thanks for the help. I think UnsafeLiteral is missing from the documentation.

I am coming from EF core, So far I really like SqlKata. Two features will make SqlKata a right choice for any project Multimapping #253 and CancelationToken https://www.c-sharpcorner.com/article/asp-net-mvc5-asynchronous-controllers-cancellation-token/

[ahmad-moussawi]

Thanks @ansarizafar I will take your feedback into consider.