/ Assembly List / LJCDBMessage / DbSqlBuilder

Namespace - LJCDBMessage


Syntax

C#
public class DbSqlBuilder

Provides SQL builder methods.

Public Methods
#ctor Initializes an object instance.
ColumnList Creates the list of included table columns.
CreateAddSql Creates the SQL Insert statement.
CreateDeleteSql Creates the SQL Delete statement.
CreateLoadSql Creates the SQL Select statement for multiple records.
CreateRetrieveSql Creates the SQL Select statement for one record.
CreateUpdateSql Creates the SQL Update statement.
FilterWhereClause Creates the where clause from the filters.
InsertValueList Creates a list of record values. (R)
JoinStatement Creates the join statement.
KeyWhereClause Creates the where clause from the key values.
OrderBy Creates the order by statement from the order by column list.
PageFetch Creates the offset/fetch next statement.
UpdateValueList Creates a list of record update values.
WhereClause Create the where clause.
15 Methods

Copyright © Lester J. Clark and Contributors.
Licensed under the MIT License.