C# Class Azavea.Open.DAO.SQLite.SQLiteDescriptor

This class is a ConnectionDescriptor implementation for using FastDAO to communicate with a SQLite database.

Inheritance: Azavea.Open.DAO.SQL.AbstractSqlConnectionDescriptor, ITransactionalConnectionDescriptor

Mostra file Open project: azavea/net-dao-sqlite Class Usage Examples

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	Returns the appropriate data access layer for this connection. The default implementation returns a normal SQL data access layer, but this may be overridden in particular DB connection descriptors.
CreateNewAdapter ( IDbCommand cmd ) : DbDataAdapter
CreateNewConnection ( ) : DbConnection
MakeModulusClause ( string columnName ) : SqlClauseWithValue
MakeSequenceValueQuery ( string sequenceName ) : string
NeedAsForColumnAliases ( ) : bool
NeedToAliasColumns ( ) : bool
SQLiteDescriptor ( Config config, string component, ConnectionInfoDecryptionDelegate decryptionDelegate ) : System	This constructor reads all the appropriate values from our standard config file in the normal format.
SQLiteDescriptor ( string databasePath ) : System	Constructor for talking to a SQLite database.
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

Returns the appropriate data access layer for this connection. The default implementation returns a normal SQL data access layer, but this may be overridden in particular DB connection descriptors.

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

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

SQLiteDescriptor() public method

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

public SQLiteDescriptor ( 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

SQLiteDescriptor() public method

Constructor for talking to a SQLite database.

public SQLiteDescriptor ( string databasePath ) : System
databasePath	string	Path to the db file.
return	System

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