Guest User

Untitled

a guest
Jan 18th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. var q = this.Session.CreateQuery(@"update Contact set Selection = REPLACE(';' + Selection + ';', :fromPara, :toPara) where ';' + Selection + ';' like :fromWhere");
  2. q.SetParameter("fromPara", ";" + from + ";");
  3. q.SetParameter("toPara", ";" + to + ";");
  4. q.SetParameter("fromWhere", "%;" + from + ";%");
  5. q.ExecuteUpdate();
Add Comment
Please, Sign In to add comment