C# Класс Azavea.Open.DAO.SQLServer.SQLServerDescriptor

This class represents the info necessary to connect to a SQL Server database. TODO: Add support for SQL Server Spatial.
Наследование: Azavea.Open.DAO.SQL.AbstractSqlConnectionDescriptor, ITransactionalConnectionDescriptor
Показать файл Открыть проект Примеры использования класса

Открытые свойства

Свойство Тип Описание
Database string
Password string
Server string
User string

Защищенные свойства (Protected)

Свойство Тип Описание
_cleanConnStr string
_connectionStr string

Открытые методы

Метод Описание
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
MakeBitwiseAndClause ( string columnName ) : SqlClauseWithValue
MakeConnectionString ( string server, string database, string user, string password ) : string

Assembles a connection string that can be used to get a database connection. All the parameters are optional for the purposes of this method, although obviously it would be possible to create a useless connection string if you leave out important parameters.
MakeModulusClause ( string fieldName ) : SqlClauseWithValue
NeedAsForColumnAliases ( ) : bool
NeedToAliasColumns ( ) : bool
SQLServerDescriptor ( Config config, string component, ConnectionInfoDecryptionDelegate decryptionDelegate ) : System

This constructor reads all the appropriate values from a config file.
SQLServerDescriptor ( string server, string database, string user, string password ) : System

Constructor that lets you pass everything as parameters rather than requiring a config.
SetParametersOnCommand ( IDbCommand cmd, IEnumerable parameters ) : void
TableAliasPrefix ( ) : string
TableAliasSuffix ( ) : string
ToCleanString ( ) : string
ToCompleteString ( ) : string
UsePooling ( ) : bool

Описание методов

BeginTransaction() публичный Метод

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
Результат ITransaction

ColumnAliasPrefix() публичный Метод

public ColumnAliasPrefix ( ) : string
Результат string

ColumnAliasSuffix() публичный Метод

public ColumnAliasSuffix ( ) : string
Результат string

CreateDataAccessLayer() публичный Метод

public CreateDataAccessLayer ( ) : IDaLayer
Результат IDaLayer

CreateNewAdapter() публичный Метод

public CreateNewAdapter ( IDbCommand cmd ) : DbDataAdapter
cmd IDbCommand
Результат System.Data.Common.DbDataAdapter

CreateNewConnection() публичный Метод

public CreateNewConnection ( ) : DbConnection
Результат System.Data.Common.DbConnection

MakeBitwiseAndClause() публичный Метод

public MakeBitwiseAndClause ( string columnName ) : SqlClauseWithValue
columnName string
Результат Azavea.Open.DAO.SQL.SqlClauseWithValue

MakeConnectionString() публичный статический Метод

Assembles a connection string that can be used to get a database connection. All the parameters are optional for the purposes of this method, although obviously it would be possible to create a useless connection string if you leave out important parameters.
public static MakeConnectionString ( string server, string database, string user, string password ) : string
server string Server name that is hosting the database
database string Database name on the server.
user string User name to use when accessing the db.
password string Password for above user.
Результат string

MakeModulusClause() публичный Метод

public MakeModulusClause ( string fieldName ) : SqlClauseWithValue
fieldName string
Результат Azavea.Open.DAO.SQL.SqlClauseWithValue

NeedAsForColumnAliases() публичный Метод

public NeedAsForColumnAliases ( ) : bool
Результат bool

NeedToAliasColumns() публичный Метод

public NeedToAliasColumns ( ) : bool
Результат bool

SQLServerDescriptor() публичный Метод

This constructor reads all the appropriate values from a config file.
public SQLServerDescriptor ( 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.
Результат System

SQLServerDescriptor() публичный Метод

Constructor that lets you pass everything as parameters rather than requiring a config.
public SQLServerDescriptor ( string server, string database, string user, string password ) : System
server string Server name. 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 Password for the user. May be null.
Результат System

SetParametersOnCommand() публичный Метод

public SetParametersOnCommand ( IDbCommand cmd, IEnumerable parameters ) : void
cmd IDbCommand
parameters IEnumerable
Результат void

TableAliasPrefix() публичный Метод

public TableAliasPrefix ( ) : string
Результат string

TableAliasSuffix() публичный Метод

public TableAliasSuffix ( ) : string
Результат string

ToCleanString() публичный Метод

public ToCleanString ( ) : string
Результат string

ToCompleteString() публичный Метод

public ToCompleteString ( ) : string
Результат string

UsePooling() публичный Метод

public UsePooling ( ) : bool
Результат bool

Описание свойств

Database публичное свойство

The database name. May not be null.
public string Database
Результат string

Password публичное свойство

The password for the User. May be null.
public string Password
Результат string

Server публичное свойство

The server name. May not be null.
public string Server
Результат string

User публичное свойство

The user name, if necessary to log into the database. May be null.
public string User
Результат string

_cleanConnStr защищенное свойство

protected string _cleanConnStr
Результат string

_connectionStr защищенное свойство

protected string _connectionStr
Результат string