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)".
Exibir arquivo 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_oe property

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

PartBeforeValue public_oe property

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