Click or drag to resize

Database Methods

The Database type exposes the following members.

Methods
  NameDescription
Public methodBeginTrans
Public methodStatic memberBuildListSql(DatabaseMainTable, DatabaseJoinTable, String, PairString, String)
Public methodStatic memberBuildListSql(DatabaseMainTable, String, DatabaseJoinTable, String, PairString, String)
Public methodStatic memberBuildLoadSql(String, String, Int64)
Public methodStatic memberBuildLoadSql(String, String, String)
Public methodCacheMessage
Public methodCancelTrans
Public methodCastT(Object)
Public methodCastT(Object, T)
Public methodStatic memberCombineColumn
Public methodCommit
Public methodStatic memberCountRows
Public methodStatic memberCreate(String)
Public methodStatic memberCreate(String, String)
Public methodStatic memberCreate(String, String, String, String, String)
Public methodStatic memberCreateFromSettings
Public methodStatic memberCustomTables
Public methodStatic memberDecryptString
Public methodDelete
Public methodDispose
Public methodStatic memberEnclose
Public methodEncloseKey(String)
Public methodEncloseKey(String, String)
Public methodEncloseKey(String, String, Boolean)
Public methodEq
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public methodExeSql(String)
Public methodExeSql(String, Int32)
Public methodExeSqlReturnID(String, String)
Public methodExeSqlReturnID(String, String, Int32)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodFunCeil
Public methodFunLeft
Public methodFunLen
Protected methodGetConnection
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetLastExecutingTime
Public methodGetNetworkTime
Public methodStatic memberGetSortBy(String, String)
Public methodStatic memberGetSortBy(String, String, String)
Public methodStatic memberGetSortBy(String, String, String, String)
Public methodStatic memberGetSortBy(String, String, String, String, String)
Public methodStatic memberGetSortDirection
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodGetUser
Public methodGetUserID
Public methodStatic memberInList
Public methodInsert(String, DatabaseRow)
Public methodInsert(String, DatabaseRow, String)
Public methodInsertReturnID(String, DatabaseRow, String)
Public methodInsertReturnID(String, DatabaseRow, String, String)
Public methodIsAdmin
Public methodIsAdministrator
Public methodStatic memberIsEnclosed
Public methodStatic memberIsNullable
Public methodStatic memberIsQualifiedName
Public methodStatic memberJoinRows
Public methodStatic memberJoinTwoTreesT
Public methodStatic memberKeyMap(String)
Public methodStatic memberKeyMap(String, String)
Public methodStatic memberLikeClause(String, String)
Public methodStatic memberLikeClause(String, String, Boolean)
Public methodLikeClause2
Public methodStatic memberLikeEndWith
Public methodLikeEndWith2
Public methodStatic memberLikeStartWith(String, String)
Public methodStatic memberLikeStartWith(String, String, Boolean)
Public methodLikeStartWith2
Public methodStatic memberLoopChildrenSql
Protected methodMakeCommand
Protected methodMakeCommand(String)
Protected methodMakeCommand2
Public methodStatic memberMakeSearchText(String, String, String)
Public methodStatic memberMakeSearchText(String, String, String, String)
Public methodStatic memberMakeTreeT
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodStatic memberNotInList
Public methodStatic memberOrderByGivenListT
Public methodStatic memberPagingSql Obsolete.
Public methodPagingSQL
Public methodStatic memberPivot
Public methodReadColumnTypes
Public methodStatic memberReadRow(DbDataReader)
Public methodStatic memberReadRow(DbDataReader, DictionaryString, String)
Public methodReadRowAsXml(String, TextWriter)
Public methodReadRowAsXml(String, TextWriter, DatabaseRowProccesser)
Public methodStatic memberRegisterProvider
Public methodResetStatistics
Public methodRowNum
Public methodStatic memberRows2CSV(IEnumerableDatabaseRow)
Public methodStatic memberRows2CSV(IEnumerableDatabaseRow, Char)
Public methodStatic memberRows2HtmlTable
Public methodRunOneSqlBlock
Public methodRunSqlBlocks(String)
Public methodRunSqlBlocks(String, TextWriter, DatabaseLogFun)
Public methodRunSqlBlocks(TextReader, DictionaryString, String, TextWriter, DatabaseLogFun)
Public methodRunSqlBlocks(String, String, String, TextWriter, DatabaseLogFun)
Public methodRunSqlBlocks(TextReader, DictionaryString, String, String, String, TextWriter, DatabaseLogFun)
Public methodStatic memberSafeToken
Public methodSaveMappingT
Public methodStatic memberScanHeaders
Public methodSelectBoolValue
Public methodSelectDictT1, T2(String)
Public methodSelectDictT1, T2(String, DictionaryT1, T2)
Public methodSelectFile
Public methodSelectFiles
Public methodSelectListT
Public methodSelectRow
Public methodSelectRowReader(String)
Public methodSelectRowReader(String, Int32, DictionaryString, Object)
Public methodSelectRows(String)
Public methodSelectRows(String, DictionaryString, String)
Public methodSelectRows(String, Int32)
Public methodStatic memberSelectRows(IEnumerableDatabaseRow, String)
Public methodSelectRows(String, Int32, DictionaryString, String)
Public methodStatic memberSelectRows(IEnumerableDatabaseRow, String, Object)
Public methodSelectSingleObject
Public methodSelectSingleString
Public methodSelectSingleValueT
Public methodSelectSql(String)
Public methodSelectSql(String, Int32)
Public methodSelectSql(String, Int32, DictionaryString, Object)
Public methodStatic memberSelectUniqueValuesT
Public methodSelectValues
Public methodStatic memberSortRowsT(DatabaseRow, String)
Public methodStatic memberSortRowsT1, T2(DatabaseRow, String, String)
Public methodStatic memberSqlBracket
Public methodStatic memberSqlEscapeStr
Public methodStatic memberSqlSafe(Boolean)
Public methodStatic memberSqlSafe(DateTime)
Public methodStatic memberSqlSafe(Guid)
Public methodStatic memberSqlSafe(String)
Public methodStatic memberSqlSafe(String, Boolean)
Public methodSqlSafe2(String)
Public methodSqlSafe2(String, Boolean)
Public methodStrPlus
Public methodSuggest
Public methodToDatetimeString
Public methodTop
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Public methodToUserDB
Public methodUnicodeLead
Public methodUpdate(String, DatabaseRow, String)
Public methodUpdate(String, DatabaseRow, String, DictionaryString, Object)
Public methodUpdate(String, String, Object, String)
Public methodUpdateOrInsert
Public methodUseDB
Public methodWrapStringArray
Public methodWriteCsvRows(String, TextWriter)
Public methodWriteCsvRows(String, TextWriter, DictionaryString, String)
Public methodWriteCsvRows(String, TextWriter, JSDrawFormColumn, DatabaseRowProccesser)
Public methodWriteCsvRows(String, HttpContext, String, Boolean)
Public methodStatic memberWriteCsvRows(IEnumerableDatabaseRow, TextWriter, JSDrawFormColumn, DatabaseRowProccesser)
Public methodWriteCsvRows(String, HttpContext, JSDrawFormColumn, String, Boolean)
Public methodStatic memberWriteCsvRows(IEnumerableDatabaseRow, TextWriter, JSDrawFormColumn, DatabaseRowProccesser, Char)
Public methodStatic memberWriteCsvRows(IEnumerableDatabaseRow, TextWriter, String, DatabaseRowProccesser, Char)
Public methodWriteExcelRows(String, JSDrawFormColumn, Stream, DatabaseRowProccesser)
Public methodStatic memberWriteExcelRows(DatabaseRow, JSDrawFormColumn, Stream, DatabaseRowProccesser)
Public methodWriteHtmlRows(String, TextWriter)
Public methodWriteHtmlRows(String, TextWriter, JSDrawFormColumn)
Public methodStatic memberWriteHtmlTable
Public methodWriteJsonArray(String, TextWriter)
Public methodWriteJsonArrayT(String, TextWriter)
Public methodWriteJsonDict(String, TextWriter)
Public methodWriteJsonDict(String, TextWriter, String)
Public methodWriteJsonDictArray
Public methodWriteJsonDictObject
Public methodWriteJsonRow(String, TextWriter)
Public methodWriteJsonRow(String, TextWriter, DatabaseRowProccesser)
Public methodWriteJsonRows(String, TextWriter)
Public methodStatic memberWriteJsonRows(DatabaseRow, TextWriter)
Public methodWriteJsonRows(String, TextWriter, Int32)
Public methodStatic memberWriteJsonRows(DatabaseRow, TextWriter, Boolean)
Public methodWriteJsonRows(String, TextWriter, Int32, DatabaseRowProccesser)
Public methodStatic memberWriteJsonTreeT
Public methodStatic memberWriteJssdfXml(DatabaseRow, TextWriter)
Public methodWriteJssdfXml(String, TextWriter, Int32)
Public methodWritePagedJsonDictArray(String, TextWriter, Int32)
Public methodWritePagedJsonDictArray(String, TextWriter, Int32, DatabaseRowProccesser)
Public methodWritePagedJsonDictArray(String, TextWriter, Int32, Int32)
Public methodWritePagedJsonDictArray(String, TextWriter, Int32, DatabaseRowProccesser, Boolean)
Public methodWritePagedJsonDictArray(String, TextWriter, Int32, Int32, DatabaseRowProccesser)
Public methodWriteRows
Public methodStatic memberWriteRows2CSV
Public methodStatic memberWriteRows2Excel
Public methodStatic memberWriteRows2SDF
Public methodWriteSdfRows(String, TextWriter, String, String)
Public methodWriteSdfRows(String, TextWriter, String, String, DatabaseRowProccesser)
Public methodWriteSdfRows(String, HttpContext, String, String, Boolean)
Public methodWriteTableXml
Public methodWriteXmlRows(TextWriter, String)
Public methodWriteXmlRows(TextWriter, String, DatabaseRowProccesser)
Public methodWriteXmlRows(String, HttpContext, String, Boolean)
Top
See Also