kakss@hotmail.comRun SQL With IN clause
Hi,
string sql = "SELECT * FROM pmsBankType WHERE batBankTypeId IN @p1";
object[] parameters = { 1, 2, 3 };
var data = this.ExecuteQueryDynamic(sql, parameters);
data.Dump();
I'm getting the error.
Hi,
string sql = "SELECT * FROM pmsBankType WHERE batBankTypeId IN @p1";
object[] parameters = { 1, 2, 3 };
var data = this.ExecuteQueryDynamic(sql, parameters);
data.Dump();
I'm getting the error.
Comments
That's not a valid SQL, I'm actually not aware of any major database that allow use of IN against array parameter