Classes · 1 min read

LeftQueryField

A query field class that is being used to define a query expression for the SQL statement using the LEFT function.

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

Usability

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

The result contains all records where Column starts with Value.

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

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