C# (CSharp) DbShell.Driver.Common.AbstractDb FulltextSearchParams Beispiele

Beispiel #1

 public virtual string GetFulltextSearchExpr(string expr, string substring, FulltextSearchParams pars)
 {
     substring = substring.Replace("@", "@@").Replace("%", "@%").Replace("_", "@_");
     return String.Format("({0} LIKE {1} ESCAPE '@')", expr, this.GetSqlLiteral(pars.LikePrefix + substring + pars.LikePostfix, new DbTypeString()));
 }

Beispiel #2

Datei: DialectDataAdapterBase.cs Projekt: dbshell/dbshell

 public virtual string GetFulltextSearchExpr(string expr, string substring, FulltextSearchParams pars)
 {
     substring = substring.Replace("@", "@@").Replace("%", "@%").Replace("_", "@_");
     return String.Format("({0} LIKE {1} ESCAPE '@')", expr, this.GetSqlLiteral(pars.LikePrefix + substring + pars.LikePostfix, new DbTypeString()));
 }