I've been trying to use DbExtensions.SqlBuilder and have encountered a strange behaviour similar to the one in this question
Basically when I do
var query = SQL
.SELECT("ID")
.FROM("TABLE")
.WHERE("Column1 = {0}", 1);
Rather than getting the raw sql to be
SELECT ID FROM TABLE WHERE Column1 = 1
I get the following instead:
SELECT ID FROM TABLE WHERE Column1 = {0}
Which doesn't seem right. Even the answer to the question I referenced doesn't seem to make sense to me. Why is the WHERE
clause not formatting the string correctly?
Thanks