StiPostgreSqlConnector Class

Namespace: Stimulsoft.Base

Inheritance

Inherits from: StiSqlDataConnector

Constructors

Constructor Description
StiPostgreSqlConnector(string connectionString)  

StiPostgreSqlConnector(connectionString: string)

Parameters

  • connectionString (string)

Properties

Property Type Description
AllowDevart static bool  

Methods

Method Returns Description
CreateParameter (+1 overloads) DbParameter Returns new SQL parameter with specified parameter.
Get static StiPostgreSqlConnector  
GetDatabaseSpecificName string  
GetFamilyConnectors StiDataConnector[] Return an array of the data connectors which can be used also to access data for this type of the connector.
GetNetType (+1 overloads) Type Returns a .NET type from the specified string representaion of the database type.
GetSampleConnectionString string Returns sample of the connection string to this connector.
GetSqlType int Returns a SQL based type from the .NET type.
LoadDevartConnector static StiPostgreSqlDevartConnector  
LoadGenericConnector static StiPostgreSqlConnector  
ResetSettings void  
RetrieveSchema StiDataSchema Returns schema object which contains information about structure of the database. Schema returned start at specified root element (if it applicable).

Method Details

CreateParameter

CreateParameter(parameterName: string, value: object, size: int): DbParameter

Returns new SQL parameter with specified parameter.

Parameters

  • parameterName (string)
  • value (object)
  • size (int)

Returns DbParameter


CreateParameter(parameterName: string, type: int, size: int): DbParameter

Returns new SQL parameter with specified parameter.

Parameters

  • parameterName (string)
  • type (int)
  • size (int)

Returns DbParameter


Get static

Get(connectionString: string): StiPostgreSqlConnector

Parameters

  • connectionString (string)

Returns StiPostgreSqlConnector


GetDatabaseSpecificName

GetDatabaseSpecificName(name: string): string

Parameters

  • name (string)

Returns string


GetFamilyConnectors

GetFamilyConnectors(): StiDataConnector[]

Return an array of the data connectors which can be used also to access data for this type of the connector.

Returns StiDataConnector[]


GetNetType

GetNetType(dbType: int): Type

Returns a .NET type from the specified string representaion of the database type.

Parameters

  • dbType (int)

Returns Type


GetNetType(dbType: string): Type

Returns a .NET type from the specified string representaion of the database type.

Parameters

  • dbType (string)

Returns Type


GetSampleConnectionString

GetSampleConnectionString(): string

Returns sample of the connection string to this connector.

Returns string


GetSqlType

GetSqlType(type: Type): int

Returns a SQL based type from the .NET type.

Parameters

  • type (Type)

Returns int


LoadDevartConnector static

LoadDevartConnector(connectionString: string): StiPostgreSqlDevartConnector

Parameters

  • connectionString (string)

Returns StiPostgreSqlDevartConnector


LoadGenericConnector static

LoadGenericConnector(connectionString: string): StiPostgreSqlConnector

Parameters

  • connectionString (string)

Returns StiPostgreSqlConnector


ResetSettings

ResetSettings(): void


RetrieveSchema

RetrieveSchema(allowException: bool): StiDataSchema

Returns schema object which contains information about structure of the database. Schema returned start at specified root element (if it applicable).

Parameters

  • allowException (bool)

Returns StiDataSchema