-
-
Notifications
You must be signed in to change notification settings - Fork 498
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Multiple bindings with the same value #666
Comments
There is a hidden feature that allows you to define a variable and use it multiple times. using static SqlKata.Expressions;
var query = new Query("Users")
.Define("Today", DateTime.Today)
.Where("CreatedAt", Variable("Today"))
.Where("PublishedAt", ">", Variable("Today")); Check the example here. This is not publicly documented since it may be changed or removed later, so consider this if you decide to use it. |
Thanks for the answer. Would it be correct? var query = new Query("Users")
.Define("Today", DateTime.Today)
.OrderByRaw("CASE WHEN StartDate < ? and (EndDate is null or EndDate > ?) THEN 0 WHEN StartDate > ? THEN 1 ELSE 2 END",
bindings: new object[] { Variable("Today"), Variable("Today"), Variable("Today") }) It doesn't make sense to me. Would be nice to have named parameters, so I can use them in raw queries like this: var query = new Query("Users")
.Define("Today", DateTime.Today)
.WhereRaw("DATEPART('weekday', @Today) = 3")
.OrderByRaw("CASE WHEN StartDate < @Today and (EndDate is null or EndDate > @Today) THEN 0 WHEN StartDate > @Today THEN 1 ELSE 2 END") |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I am trying to get some query working which includes binding value multiple times:
eg.
Is there any way to modify query in a way, so the
DateTime.Today
declared only ones.Doc says nothing about that.
The text was updated successfully, but these errors were encountered: