Parameters and an example of a function FuncAND

FuncAND the same function as the logical “And” SQL Builder function limitations SQLWhereLanguageDef.

Parameters GetFunction

GetFunction accepts the first argument type of a function funcAND, and then accepts N (>= 2) functions to be combined with logical And.

For example, you want to subtract all the Loans specific Customer issued in excess of 100,000 rubles.

The SQL statement would look as follows:

SELECT * FROM Кредит WHERE Клиент = '{ID}' AND СуммаКредита > 100000@@
Где {ID} - [Primary-keys-objects|первичный ключ) искомого `Клиента`

SQLWhereLanguageDef:

Клиент клиент = new Клиент();
SQLWhereLanguageDef langdef = SQLWhereLanguageDef.LanguageDef;
Function lf = langdef.GetFunction(
					langdef.funcAND,
					langdef.GetFunction(
						langdef.funcEQ, 
						new VariableDef(langdef.GuidType, Information.ExtractPropertyPath<Кредит>(x => x.Клиент)), 
						клиент.__PrimaryKey),
					langdef.GetFunction(
						langdef.funcG, 
						new VariableDef(langdef.NumericType, Information.ExtractPropertyPath<Кредит>(x => x.СуммаКредита)), 
						100000));