Search Results for

    Show / Hide Table of Contents

    Interface IQueryDeleteBuilder

    Builds SQL DELETE expressions.

    Inherited Members
    IQueryBuilderFiltered.RemoveTable(string)
    IQueryBuilderFiltered.AddWhereCondition(string, string, SQLOperator, string, string)
    IQueryBuilderFiltered.AddWhereCondition(string, string, SQLOperator, string)
    IQueryBuilderFiltered.AddWhereIsNullCondition(string, string, string, SQLOperator, string)
    IQueryBuilderFiltered.AddWhereIsNull(string, string)
    IQueryBuilderFiltered.AddWhereIsNotNull(string, string)
    IQueryBuilderFiltered.AddWhereExpression(string)
    IQueryBuilderFiltered.RemoveWhereCondition(int)
    IQueryBuilderFiltered.AddHavingCondition(AggregateFunction, string, string, SQLOperator, AggregateFunction, string, string)
    IQueryBuilderFiltered.AddHavingCondition(AggregateFunction, string, string, SQLOperator, string)
    IQueryBuilderFiltered.AddHavingExpression(string)
    IQueryBuilderFiltered.BeginWhereGroup(GroupType)
    IQueryBuilderFiltered.EndWhereGroup()
    IQueryBuilderFiltered.BeginHavingGroup(GroupType)
    IQueryBuilderFiltered.EndHavingGroup()
    IQueryBuilderFiltered.ToString()
    IQueryBuilderFiltered.CurrentWhereGroup
    IQueryBuilderFiltered.CurrentHavingGroup
    IQueryBuilder.GetCommandText()
    IQueryBuilder.GetCommandText(string)
    IQueryBuilder.MaxQueryWidth
    Namespace: LemonEdge.DataAccess.Core.Abstractions.Builders
    Assembly: LemonEdge.DataAccess.Core.Abstractions.dll
    Syntax
    public interface IQueryDeleteBuilder : IQueryBuilderFiltered, IQueryBuilder

    Methods

    AddCustomJoin(string)

    Adds custom JOIN SQL.

    Declaration
    void AddCustomJoin(string customJoin)
    Parameters
    Type Name Description
    string customJoin

    The SQL.

    AddDeleteOutputCol(string)

    Adds a column to the OUTPUT.

    Declaration
    void AddDeleteOutputCol(string col)
    Parameters
    Type Name Description
    string col

    The name of the column.

    Init()

    Initialises the class by clearing all local variables.

    Declaration
    void Init()

    OutputIntoTable(string)

    Adds an OUTPUT clause.

    Declaration
    void OutputIntoTable(string tableName)
    Parameters
    Type Name Description
    string tableName

    The target.

    Extension Methods

    LinqExtensions.AsArray<T>(T)
    LinqExtensions.ToArrayOfOne<T>(T)
    LinqExtensions.ToListOfOne<T>(T)
    MiscExtensions.SetIfNotEqual<T, TP>(T, Expression<Func<T, TP>>, TP)
    WeakReferenceExtensions.WeakReference(object)
    SQLExtensions.ToSQLValue(object, bool)
    ReflectionExtensions.ClearEventInvocations(object, string)
    StringExtensions.ToCSVFormatString(object, Type)
    In this article
    Back to top © LemonEdge Technologies. All rights reserved.