eBiss 3

Hilfe & Dokumentation

User Tools

Site Tools


Sidebar

en:howtos:dbadapter:wherecondition

DB Adapter - Where Conditions

A simple condition with a variable looks like this:

        [Where("< $State")]
        public int State;

You can either define the variable in the default system partner using the prefix 'eBiss.DbAdapter.'; in this case:

  • eBiss.DbAdapter.State

or in the job step:

  • State

If you use variables with conditions or with string types, you should set DontChangeCondition to true, e.g.:

  [Where("$Name", DontChangeCondition = true)]
  public string Name;

In case of setting DontChangeCondition, the expression will not be changed, e.g. not be quoted.

In the job step you can define the variable e.g. as:

  • like 'Mustermann%'
  • = 'Musterfrau'
en/howtos/dbadapter/wherecondition.txt · Last modified: 2024/02/20 08:15 by 127.0.0.1