public void AddCondition(bool notIn, string tableName, string fieldName, SqlLamBase sqlQuery) { var innerQuery = sqlQuery.SqlString; foreach (var name in sqlQuery.Parameters) { //var param = name.Key; //var innerParamKey = "Inner" + param; //innerQuery = Regex.Replace(innerQuery, param, innerParamKey); //AddParameter(innerParamKey, name.Value); this.AddParameter(name.Key, name.Value); } string op = notIn ? "NOT IN" : "IN"; var newCondition = string.Format("{0} {2} ({1})", _adapter.Field(tableName, fieldName), innerQuery, op); _conditions.Add(newCondition); }
public SqlLam <T> WhereNotIn(Expression <Func <T, object> > expression, SqlLamBase sqlQuery) { _builder.And(); _resolver.QueryByIsIn(true, expression, sqlQuery); return(this); }