C# Class Azavea.Open.DAO.SQL.SqlClauseWithValue

Many SQL clauses look something like this: "(colName > 5)". However, on some DBs, that same clause may actually look like this: "LT_OR_EQ(5, colName)". To make things more complicated, you may want to not put 5 in the string, but use a parameter instead. So this allows you to represent it, in the first case PartBeforeValue would be "(colName > " and PartAfterValue would be ")", and in the second case PartBeforeValue would be "LT_OR_EQ(" and PartAfterValue would be ", colName)".
Show file Open project: azavea/net-dao

Public Properties

Property Type Description
PartAfterValue string
PartBeforeValue string

Public Methods

Method Description
Clear ( ) : void

Sets both parts back to null.
SqlClauseWithValue ( )

Create a blank clause.
SqlClauseWithValue ( string before, string after )

Create a clause by specifying the before and after parts.

Method Details

Clear() public method

Sets both parts back to null.
public Clear ( ) : void
return void

SqlClauseWithValue() public method

Create a blank clause.
public SqlClauseWithValue ( )

SqlClauseWithValue() public method

Create a clause by specifying the before and after parts.
public SqlClauseWithValue ( string before, string after )
before string The part of the clause that comes before the value.
after string The part of the clause that comes after the value.

Property Details

PartAfterValue public property

The part of the clause that comes after the value. May be null.
public string PartAfterValue
return string

PartBeforeValue public property

The part of the clause that comes before the value. May be null.
public string PartBeforeValue
return string