SqlQueryBuilder.BuildSQLEx Method

SqlQueryBuilder BuildSQLEx Method

EasyQuery ASP.NET API Reference

Builds the SQL with some additional columns and conditions which can be passed in parameters

Namespace: Korzh.EasyQuery.Db
Assembly: Korzh.EasyQuery.Db.NET40 (in Korzh.EasyQuery.Db.NET40.dll) Version: 3.7.1.37

Syntax

public bool BuildSQLEx(
	string extraColumns,
	string extraConditions
)

public bool BuildSQLEx(
	string extraColumns,
	string extraConditions
)

Public Function BuildSQLEx ( 
	extraColumns As String,
	extraConditions As String
) As Boolean

Public Function BuildSQLEx ( 
	extraColumns As String,
	extraConditions As String
) As Boolean

public:
bool BuildSQLEx(
	String^ extraColumns, 
	String^ extraConditions
)

public:
bool BuildSQLEx(
	String^ extraColumns, 
	String^ extraConditions
)

extraColumns: Type: System String
The addtional columns which will be placed in SELECT clause of result SQL. All columns should be listed exactly as they will appear in result SQL (e.g. "Customer.FirstName") and separated by comma.

extraConditions: Type: System String
The addtional conditions which will be placed in WHERE clause of result SQL. All conditions should be listed exactly as they will appear in result SQL.
For example: Order.Paid=true AND Order.Freight > 1000

Type:

[Missing <returns> documentation for "M:Korzh.EasyQuery.Db.SqlQueryBuilder.BuildSQLEx(System.String,System.String)"]