SqlIdFilterHelperTBuildWhereClause Method (String, String)

Adds a where clause to the query, it will use one of the parameters depending on the number of ids requested. Both paramters must be provided.

Namespace: Omada.OE.AppLogic.Helpers
Assembly: Omada.OE.AppLogic (in Omada.OE.AppLogic.dll) Version: 15.0.0.0

Syntax

public void BuildWhereClause(
	string tempTableQueryPart,
	string whereIdInQueryPart
)

tempTableQueryPart: Type: SystemString
The query-part to-be-used with a temp-table if a "where id in (xxx)" construct is not suitable (due to too many ids). Example: "ID in (select Id from $temptable$)"
whereIdInQueryPart: Type: SystemString
The query-part to-be-used in a "where id in (xxx)" construct when there are only a few ids. Example: "ID in ($delimids$)"

SqlIdFilterHelperAddLanguageSpecificTextSet("LSTAD2FE68A_0?cs=&lt;|vb=(Of |cpp=&lt;|fs=&lt;'|nu=(");TAddLanguageSpecificTextSet("LSTAD2FE68A_1?cs=&gt;|vb=)|cpp=&gt;|fs=&gt;|nu=)");AddLanguageSpecificTextSet("LSTAD2FE68A_2?cpp=::|nu=.");BuildWhereClause Method (String, String)