RightTrimQueryField

An extended query field class for defining SQL expressions using the RTRIM function. Inherits QueryField.

Usability

var where = new RightTrimQueryField("Column", "Value");
var result = connection.Query<Entity>(where);

The result contains all records where the right-trimmed value of Column equals Value.

GetString

The GetString() method returns the command text using the RTRIM function.

var where = new RightTrimQueryField("Column", "Value");
var text = where.GetString(connection.GetDbSetting()); // Returns (RTRIM([Column]) = @Column)