示例#1
0
        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 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));
        }
示例#3
0
 private StatementQuery CreateWhereStatement()
 {
     return(m_statementBuilder.BuildWhereStatementsQuery(m_whereStatements, m_whereStatementRelations));
 }