Class SqlGenerator

Inheritance
Object
SqlGenerator
Inherited Members
Namespace: DotNetHelper.ObjectToSql
Assembly: DotNetHelper.ObjectToSql.dll
Syntax
public static class SqlGenerator

Methods

| Improve this Doc View Source

BuildDeleteQuery(SqlSyntaxHelper, String, List<MemberWrapper>, Boolean)

Declaration
public static string BuildDeleteQuery(SqlSyntaxHelper syntax, string tableName, List<MemberWrapper> keyColumns, bool isReadableSql)
Parameters
Type Name Description
SqlSyntaxHelper syntax
String tableName
List<DotNetHelper.FastMember.Extension.Models.MemberWrapper> keyColumns
Boolean isReadableSql
Returns
Type Description
String
| Improve this Doc View Source

BuildDeleteQuery(SqlSyntaxHelper, String, List<String>, Boolean)

Declaration
public static string BuildDeleteQuery(SqlSyntaxHelper syntax, string tableName, List<string> keyColumns, bool isReadableSql)
Parameters
Type Name Description
SqlSyntaxHelper syntax
String tableName
List<String> keyColumns
Boolean isReadableSql
Returns
Type Description
String
| Improve this Doc View Source

BuildInsertQuery(SqlSyntaxHelper, String, List<String>, List<String>, Boolean)

Builds the insert query.

Declaration
public static string BuildInsertQuery(SqlSyntaxHelper syntax, string tableName, List<string> columns, List<string> valueColumns, bool isReadableSql)
Parameters
Type Name Description
SqlSyntaxHelper syntax
String tableName

Name of the table.
List<String> columns

column names
List<String> valueColumns

values of columns
Boolean isReadableSql
Returns
Type Description
String
| Improve this Doc View Source

BuildWhereClause(SqlSyntaxHelper, List<String>, List<String>, Boolean)

Builds the where clause. Example *WHERE A=@A AND B=@b*

Declaration
public static string BuildWhereClause(SqlSyntaxHelper syntax, List<string> columns, List<string> parameterColumns, bool isReadableSql)
Parameters
Type Name Description
SqlSyntaxHelper syntax
List<String> columns
List<String> parameterColumns
Boolean isReadableSql
Returns
Type Description
String
| Improve this Doc View Source

BuildWhereClauseFromMembers(SqlSyntaxHelper, List<MemberWrapper>, Boolean)

BUilds a where clause from a list of member wrappers

Declaration
public static string BuildWhereClauseFromMembers(SqlSyntaxHelper syntax, List<MemberWrapper> members, bool isReadableSql)
Parameters
Type Name Description
SqlSyntaxHelper syntax
List<DotNetHelper.FastMember.Extension.Models.MemberWrapper> members
Boolean isReadableSql
Returns
Type Description
String