public static IEnumerable <dynamic> GetList(this IDbConnection connection, SelectConfiguration selectConfiguration, object parameterValues) { var selectQuery = new QueryBuilder.SelectQueryBuilder.QueryBuilder().GetSelectQuery(selectConfiguration); return(connection.Query <dynamic>(selectQuery, parameterValues)); }
public static T FindById <T>(this IDbConnection connection, SelectConfiguration configuration, object id, Tenant tenant = null) { var selectQuery = new QueryBuilder.SelectQueryBuilder.QueryBuilder().GetSelectQuery(configuration); if (!selectQuery.ToUpper().Contains("WHERE")) { selectQuery = selectQuery + "Where Id=@Id"; } return(FindById <T>(connection, selectQuery, id, tenant: tenant)); }
public static Result <SpTransactionMessage> UpdateExtentionTable <T>(this IDbConnection connection, IDictionary <string, object> parameterValues, IDbTransaction transaction = null) { if (parameterValues == null) { throw new ArgumentException("Invalid extention table values"); } var updateConfiguration = GetUpdateConfiguration <T>(parameterValues); var updateQuery = new QueryBuilder.SelectQueryBuilder.QueryBuilder().GetUpdateQuery(updateConfiguration); return(ExecuteQuery(connection, updateQuery, parameterValues, CommandType.Text, transaction)); }
public static dynamic FindById(this IDbConnection connection, SelectConfiguration selectConfiguration, object id) { var selectQuery = new QueryBuilder.SelectQueryBuilder.QueryBuilder().GetSelectQuery(selectConfiguration); return(FindById(connection, selectQuery, id)); }