• 홈
• BF2Statistics
• Database
• QueryBuilder
• UpdateQueryBuilder

C# 클래스 BF2Statistics.Database.QueryBuilder.UpdateQueryBuilder

파일 보기 프로젝트 열기: BF2Statistics/ControlCenter 1 사용 예제들

공개 프로퍼티들

프로퍼티	타입	설명
Table	string

보호된 프로퍼티들

프로퍼티	타입	설명
Driver	DatabaseDriver
Fields	FieldValuePair>.Dictionary
WhereStatement	WhereStatement

공개 메소드들

메소드	설명
AddWhere ( string field, Comparison @operator, object compareValue ) : WhereClause
AddWhere ( WhereClause Clause ) : void
BuildCommand ( ) : DbCommand	Builds the query string with the current SQL Statement, and returns the DbCommand to be executed. All WHERE paramenters are propery escaped, making this command SQL Injection safe.
BuildQuery ( ) : string	Builds the query string with the current SQL Statement, and returns the querystring. This method is NOT Sql Injection safe!
Execute ( ) : int	Executes the command against the database. The database driver must be set!
SetDbDriver ( DatabaseDriver Driver ) : void	Sets the database driver
SetField ( string Field, object Value ) : void	Sets a value for the specified field
SetField ( string Field, object Value, ValueMode Mode ) : void	Sets a value for the specified field
SetTable ( string Table ) : void	Sets the table name to update
SetWhereOperator ( LogicOperator @Operator ) : void	Sets the Logic Operator for the WHERE statement
UpdateQueryBuilder ( DatabaseDriver Driver ) : System	Creates a new instance of UpdateQueryBuilder with the provided Database Driver.
UpdateQueryBuilder ( string Table, DatabaseDriver Driver ) : System	Creates a new instance of UpdateQueryBuilder with the provided Database Driver.

보호된 메소드들

메소드	설명
BuildQuery ( bool BuildCommand ) : object	Builds the query string or DbCommand
GetSign ( ValueMode Mode ) : string	Returns the sign for the given value mode

메소드 상세

프로퍼티 상세