Class Query

Postgres Query class

Inheritance

System.Object

Query

Query

Inherited Members

Query.Commit(Database)

Query.Init(Database)

Query.Transaction(Database)

Query.Rollback(Database)

Query.Bind(String, Object, Object)

Query.Distinct(Boolean)

Query.Exec(String)

Query.Get()

Query.Get(String)

Query.Get(IEnumerable<String>)

Query.GroupBy(String)

Query.Join(String, String, String, Boolean)

Query.LeftJoin(List<LeftJoin>)

Query.Limit(Int32)

Query.Offset(Int32)

Query.Order(String)

Query.Order(IEnumerable<String>)

Query.Pkey()

Query.Pkey(String[])

Query.Set(String, Object, Boolean)

Query.Set(String, Object, Boolean, Nullable<DbType>)

Query.Set(Dictionary<String, Object>, Boolean)

Query.Table(String)

Query.Table(List<String>)

Query.Where(Action<Query>)

Query.Where(String, Object, String, Boolean)

Query.Where(String, IEnumerable<Object>, String, Boolean)

Query.Where(Dictionary<String, Object>, String, Boolean)

Query.AndWhere(Action<Query>)

Query.AndWhere(String, Object, String, Boolean)

Query.AndWhere(String, IEnumerable<Object>, String, Boolean)

Query.AndWhere(Dictionary<String, Object>, String, Boolean)

Query.OrWhere(Action<Query>)

Query.OrWhere(String, Object, String, Boolean)

Query.OrWhere(String, IEnumerable<Object>, String, Boolean)

Query.OrWhere(Dictionary<String, Object>, String, Boolean)

Query.WhereGroup(Boolean, String)

Query.WhereGroup(Action<Query>, String)

Query.WhereIn(String, ICollection<Object>, String)

Query._BuildField(Boolean)

Query._BuildGroupBy()

Query._BuildJoin()

Query._BuildLimit()

Query._BuildOrder()

Query._BuildSet()

Query._BuildTable()

Query._BuildValue()

Query._BuildWhere()

Query._Delete()

Query._Insert()

Query._ProtectIdentifiers(String)

Query._Raw(String)

Query._SafeBind(String)

Query._Select()

Query._Update()

Query._Where(String, Object, String, String, Boolean)

Query._WhereGroup(Boolean, String)

Namespace: DataTables.DatabaseUtil.Postgres

Assembly: DataTables-Editor-Server.dll

Syntax

public class Query : Query

Constructors

Query(Database, String)

Create a query instance specifically for Postgres

Declaration

public Query(Database db, string type)

Parameters

Type	Name	Description
Database	db	Host database
System.String	type	Query type

Methods

_Exec()

Execute the SQL command

Declaration

protected override Result _Exec()

Returns

Type	Description
Result	Result instance

Overrides

Query._Exec()

_Prepare(String)

Bind parameters to the SQL statement

Declaration

protected override void _Prepare(string sql)

Parameters

Type	Name	Description
System.String	sql	SQL command

Overrides

Query._Prepare(String)