public void Run() { var whereStatementQuery = m_statementBuilder.BuildWhereStatementsQuery(m_whereStatements, m_whereStatementRelations); m_connection.Execute( m_statementBuilder.ConcatSqlStatements(CreateDeleteStatement(), whereStatementQuery), whereStatementQuery.Parameters, m_transaction); }
public void Run() { var whereStatementQuery = CreateWhereStatement(); var setStatementQuery = CreateSetStatement(); var parameters = m_statementBuilder.ConcatStatementsParameters(setStatementQuery, whereStatementQuery); m_connection.Execute( m_statementBuilder.ConcatSqlStatements(CreateUpdateStatement(), setStatementQuery, whereStatementQuery), parameters, m_transaction); }
public IEnumerable <T> Run() { string escapedSelect; if (m_selectColumnName == null) { escapedSelect = "*"; } else { escapedSelect = $@"""{m_selectColumnName}"""; } var selectStatementSql = string.Format(@"SELECT {0} FROM ""{1}""", escapedSelect, m_tableName); var whereStatementQuery = m_statementBuilder.BuildWhereStatementsQuery(m_whereStatements, m_whereStatementRelations); return(m_connection.Query <T>( m_statementBuilder.ConcatSqlStatements(selectStatementSql, whereStatementQuery.Sql), whereStatementQuery.Parameters, m_transaction)); }