kakss@hotmail.comRun SQL With IN clause

kakss

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.

Dluk

That's not a valid SQL, I'm actually not aware of any major database that allow use of IN against array parameter