protected static void RegisterQuery(string name, Func <IMatchQuery, q.TransactionHistoryArchiveAlias, IWhereQuery> query) { q.TransactionHistoryArchiveAlias alias; IMatchQuery matchQuery = Blueprint41.Transaction.CompiledQuery.Match(q.Node.TransactionHistoryArchive.Alias(out alias)); IWhereQuery partial = query.Invoke(matchQuery, alias); ICompiled compiled = partial.Return(alias).Compile(); RegisterQuery(name, compiled); }
SqlQuery ParseWhereQuery(IWhereQuery whereQuery, out SqlSubQueryResult parentResult) { var result = ParseQuery(whereQuery.Parent, out parentResult); var parameters = new Dictionary <string, SqlSubQueryResult>(SubqueryParameters); parameters[whereQuery.WhereExpression.Parameters[0].Name] = parentResult; result.Wheres.Add(ParseExpression(whereQuery.WhereExpression.Body, parameters)); return(result); }
/// <summary> /// Updates the. /// </summary> /// <param name="type"></param> /// <param name="obj">The obj.</param> /// <param name="whereQuery">The where query.</param> /// <param name="database"></param> /// <returns>An ISql.</returns> public static ISql UpdateSql(Type type, object obj, IWhereQuery whereQuery, string database = "") { return(new UpdateSql(type, obj, whereQuery, database)); }
/// <summary> /// Updates the. /// </summary> /// <param name="obj">The obj.</param> /// <param name="whereQuery">The where query.</param> /// <param name="database"></param> /// <returns>An ISql.</returns> public static ISql UpdateSql <T>(object obj, IWhereQuery whereQuery, string database = "") { return(UpdateSql(typeof(T), obj, whereQuery, database)); }
/// <summary> /// Deletes the. /// </summary> /// <param name="whereQuery">The where query.</param> /// <param name="database"></param> /// <returns>An ISql.</returns> public static ISql DeleteSql <T>(IWhereQuery whereQuery = null, string database = "") { return(new DeleteSql(typeof(T), whereQuery, database)); }
/// <summary> /// Initializes a new instance of the <see cref="DeleteSql"/> class. /// </summary> /// <param name="table">The table.</param> /// <param name="whereQuery">The where query.</param> /// <param name="database"></param> public DeleteSql(Type table, IWhereQuery whereQuery, string database) { Table = table; WhereQuery = whereQuery; Database = database; }
public virtual Task <int> UpdateAsync <T>(object obj, IWhereQuery query) { return(Update <T>(obj, query)); }
/// <summary> /// Deletes the. /// </summary> /// <param name="query">The query.</param> /// <returns>A Task.</returns> private Task <int> Delete <T>(IWhereQuery query) { var sql = Sql.DeleteSql <T>(query); return(_dbContext.ExcuteNoQueryAsync(sql)); }
public virtual Task <int> DeleteAsync <T>(IWhereQuery query) { return(Delete <T>(query)); }
/// <summary> /// Updates the. /// </summary> /// <param name="obj">The obj.</param> /// <param name="query">The query.</param> /// <returns>A Task.</returns> private Task <int> Update <T>(object obj, IWhereQuery query) { var sql = Sql.UpdateSql <T>(obj, query); return(_dbContext.ExcuteNoQueryAsync(sql)); }
/// <summary> /// Deletes the. /// </summary> /// <param name="query">The query.</param> /// <returns>A Task.</returns> public Task <int> DeleteAsync(IWhereQuery query) { return(_dbData.DeleteAsync <T>(query)); }