DbExtensions SqlBuilder raw query does not make sense

183 Views Asked by At

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

0

There are 0 best solutions below