Hi ,
The below query not working . Its not accepting the list . No results returned.
private SqlQuerySpec getQuery(List namesList) {
ArrayList paramList = new ArrayList();
paramList.add(new SqlParameter("@names", namesList));
SqlQuerySpec querySpec = new SqlQuerySpec(
"SELECT * FROM Test t WHERE t.name in(@names)",
paramList);
return querySpec;
}
Hi , The below query not working . Its not accepting the list . No results returned.
private SqlQuerySpec getQuery(List namesList) {
ArrayList paramList = new ArrayList();
paramList.add(new SqlParameter("@names", namesList));
SqlQuerySpec querySpec = new SqlQuerySpec(
"SELECT * FROM Test t WHERE t.name in(@names)",
paramList);
return querySpec;
}