예제 #1
0
        /// <summary>
        /// Execute a DELETE query.
        /// </summary>
        /// <param name="tableName">The table in which you wish to DELETE.</param>
        /// <param name="filter">The expression containing the DELETE filter (i.e. WHERE clause data).</param>
        /// <returns>A DataTable containing the results.</returns>
        public DataTable Delete(string tableName, Expression filter)
        {
            if (String.IsNullOrEmpty(tableName))
            {
                throw new ArgumentNullException(nameof(tableName));
            }
            if (filter == null)
            {
                throw new ArgumentNullException(nameof(filter));
            }

            #region Variables

            string        query = "";
            DataTable     result;
            List <Column> tableDetails     = DescribeTable(tableName);
            List <string> columnNames      = GetColumnNames(tableName);
            string        primaryKeyColumn = GetPrimaryKeyColumn(tableName);

            #endregion

            #region Build-DELETE-Query-and-Submit

            switch (DbType)
            {
            case DbTypes.MsSql:
                query = MssqlHelper.DeleteQuery(tableName, filter);
                break;

            case DbTypes.MySql:
                query = MysqlHelper.DeleteQuery(tableName, filter);
                break;

            case DbTypes.PgSql:
                query = PgsqlHelper.DeleteQuery(tableName, filter);
                break;
            }

            result = RawQuery(query);

            #endregion

            return(result);
        }
예제 #2
0
        /// <summary>
        /// Execute a DELETE query.
        /// </summary>
        /// <param name="tableName">The table in which you wish to DELETE.</param>
        /// <param name="filter">The expression containing the DELETE filter (i.e. WHERE clause data).</param>
        /// <returns>A DataTable containing the results.</returns>
        public DataTable Delete(string tableName, Expression filter)
        {
            if (String.IsNullOrEmpty(tableName))
            {
                throw new ArgumentNullException(nameof(tableName));
            }
            if (filter == null)
            {
                throw new ArgumentNullException(nameof(filter));
            }

            #region Variables

            string    query = "";
            DataTable result;

            #endregion

            #region Build-DELETE-Query-and-Submit

            switch (_DbType)
            {
            case DbTypes.MsSql:
                query = MssqlHelper.DeleteQuery(tableName, filter);
                break;

            case DbTypes.MySql:
                query = MysqlHelper.DeleteQuery(tableName, filter);
                break;

            case DbTypes.PgSql:
                query = PgsqlHelper.DeleteQuery(tableName, filter);
                break;
            }

            result = Query(query);

            #endregion

            return(result);
        }