public void EqHybridQueryWithParamTest()
{
IRemoteCache <int, User> userCache = remoteManager.GetCache <int, User>(NAMED_CACHE);
QueryRequest.Types.NamedParameter param = new QueryRequest.Types.NamedParameter();
WrappedMessage wm = new WrappedMessage();
wm.WrappedString = "Doe";
param.Name = "surnameParam";
param.Value = wm;
QueryRequest qr = new QueryRequest();
// JpqlString will be deprecated please use QueryString
// qr.JpqlString = "from sample_bank_account.User u where (u.notes = \"Lorem ipsum dolor sit amet\") and (u.surname = :surnameParam)";
qr.QueryString = "from sample_bank_account.User u where (u.notes = \"Lorem ipsum dolor sit amet\") and (u.surname = :surnameParam)";
qr.NamedParameters.Add(param);
QueryResponse result = userCache.Query(qr);
List <User> listOfUsers = RemoteQueryUtils.unwrapResults <User>(result);
Assert.AreEqual(1, listOfUsers.Count);
Assert.AreEqual(1, listOfUsers.ElementAt(0).Id);
}
public void EqHybridQueryWithParamTest()
{
IRemoteCache<int, User> userCache = remoteManager.GetCache<int, User>(NAMED_CACHE);
QueryRequest.Types.NamedParameter param = new QueryRequest.Types.NamedParameter();
WrappedMessage wm = new WrappedMessage();
wm.WrappedString = "Doe";
param.Name = "surnameParam";
param.Value = wm;
QueryRequest qr = new QueryRequest();
// JpqlString will be deprecated please use QueryString
// qr.JpqlString = "from sample_bank_account.User u where (u.notes = \"Lorem ipsum dolor sit amet\") and (u.surname = :surnameParam)";
qr.QueryString = "from sample_bank_account.User u where (u.notes = \"Lorem ipsum dolor sit amet\") and (u.surname = :surnameParam)";
qr.NamedParameters.Add(param);
QueryResponse result = userCache.Query(qr);
List<User> listOfUsers = RemoteQueryUtils.unwrapResults<User>(result);
Assert.AreEqual(1, listOfUsers.Count);
Assert.AreEqual(1, listOfUsers.ElementAt(0).Id);
}
