C# Class Azavea.Open.DAO.Firebird.FirebirdDescriptor

This class is a ConnectionDescriptor implementation for using FastDAO to communicate with a Firebird database (embedded or server).
Inheritance: Azavea.Open.DAO.SQL.AbstractSqlConnectionDescriptor, ITransactionalConnectionDescriptor
Exibir arquivo Open project: azavea/net-dao-firebird Class Usage Examples

Public Properties

Property Type Description
Database string
Password string
Server string
User string

Public Methods

Method Description
BeginTransaction ( ) : ITransaction

Begins the transaction. Returns a NEW ConnectionDescriptor that you should use for operations you wish to be part of the transaction. NOTE: You MUST call Commit or Rollback on the returned ITransaction when you are done.

ColumnAliasPrefix ( ) : string
ColumnAliasSuffix ( ) : string
CreateDataAccessLayer ( ) : IDaLayer
CreateNewAdapter ( IDbCommand cmd ) : DbDataAdapter
CreateNewConnection ( ) : DbConnection
FirebirdDescriptor ( Config config, string component, ConnectionInfoDecryptionDelegate decryptionDelegate ) : System

This constructor reads all the appropriate values from our standard config file in the normal format.

FirebirdDescriptor ( string databasePath ) : System

Constructor for talking to an embedded firebird database.

FirebirdDescriptor ( string server, string database, string user, string password ) : System

Constructor for talking to a server-based firebird database.

MakeModulusClause ( string columnName ) : SqlClauseWithValue
MakeSequenceValueQuery ( string sequenceName ) : string
NeedAsForColumnAliases ( ) : bool
NeedToAliasColumns ( ) : bool
SetParametersOnCommand ( IDbCommand cmd, IEnumerable parameters ) : void
SupportsTruncate ( ) : bool
TableAliasPrefix ( ) : string
TableAliasSuffix ( ) : string
ToCleanString ( ) : string
ToCompleteString ( ) : string
UsePooling ( ) : bool

Method Details

BeginTransaction() public method

Begins the transaction. Returns a NEW ConnectionDescriptor that you should use for operations you wish to be part of the transaction. NOTE: You MUST call Commit or Rollback on the returned ITransaction when you are done.
public BeginTransaction ( ) : ITransaction
return ITransaction

ColumnAliasPrefix() public method

public ColumnAliasPrefix ( ) : string
return string

ColumnAliasSuffix() public method

public ColumnAliasSuffix ( ) : string
return string

CreateDataAccessLayer() public method

public CreateDataAccessLayer ( ) : IDaLayer
return IDaLayer

CreateNewAdapter() public method

public CreateNewAdapter ( IDbCommand cmd ) : DbDataAdapter
cmd IDbCommand
return System.Data.Common.DbDataAdapter

CreateNewConnection() public method

public CreateNewConnection ( ) : DbConnection
return System.Data.Common.DbConnection

FirebirdDescriptor() public method

This constructor reads all the appropriate values from our standard config file in the normal format.
public FirebirdDescriptor ( Config config, string component, ConnectionInfoDecryptionDelegate decryptionDelegate ) : System
config Azavea.Open.Common.Config Config to get params from.
component string Section of the config XML to look in for db params.
decryptionDelegate ConnectionInfoDecryptionDelegate Delegate to call to decrypt password fields. /// May be null if passwords are in plain text.
return System

FirebirdDescriptor() public method

Constructor for talking to an embedded firebird database.
public FirebirdDescriptor ( string databasePath ) : System
databasePath string Path to the db file.
return System

FirebirdDescriptor() public method

Constructor for talking to a server-based firebird database.
public FirebirdDescriptor ( string server, string database, string user, string password ) : System
server string Server name or IP. May not be null.
database string Database name on that server. May not be null.
user string Database user name, may be null.
password string Plain text password for the user. /// May be null.
return System

MakeModulusClause() public method

public MakeModulusClause ( string columnName ) : SqlClauseWithValue
columnName string
return Azavea.Open.DAO.SQL.SqlClauseWithValue

MakeSequenceValueQuery() public method

public MakeSequenceValueQuery ( string sequenceName ) : string
sequenceName string
return string

NeedAsForColumnAliases() public method

public NeedAsForColumnAliases ( ) : bool
return bool

NeedToAliasColumns() public method

public NeedToAliasColumns ( ) : bool
return bool

SetParametersOnCommand() public method

public SetParametersOnCommand ( IDbCommand cmd, IEnumerable parameters ) : void
cmd IDbCommand
parameters IEnumerable
return void

SupportsTruncate() public method

public SupportsTruncate ( ) : bool
return bool

TableAliasPrefix() public method

public TableAliasPrefix ( ) : string
return string

TableAliasSuffix() public method

public TableAliasSuffix ( ) : string
return string

ToCleanString() public method

public ToCleanString ( ) : string
return string

ToCompleteString() public method

public ToCompleteString ( ) : string
return string

UsePooling() public method

public UsePooling ( ) : bool
return bool

Property Details

Database public_oe property

The database name, either the DB name or the DB file name.
public string Database
return string

Password public_oe property

The password for the User. This is the plain text password.
public string Password
return string

Server public_oe property

The server name, may be null if this is an embedded (I.E. file system) db.
public string Server
return string

User public_oe property

The user name, if necessary to log into the database.
public string User
return string