SqlServerBridge class

An implementation of Korzh.DbUtils.BaseDbBridge for MySQL Implements the Korzh.DbUtils.BaseDbBridge

public class Korzh.DbUtils.SqlServer.SqlServerBridge
    : BaseDbBridge, IDbReader, IDbBridge, IDbWriter

Methods

Type Name Description
void AddParameters(IDbCommand command, IDataRecord record) Adds the parameters to the DB command object according to the current server type.
DbConnection CreateConnection(String connectionString) Creates the connection. This is an abstract method which must be implemented in derived classes
void ExtractDatasetList(IList<DatasetInfo> datasets) Gets the list of tables for the current DB and saves them to datasets list passed in the parameter.
void TurnOffAutoIncrement() Sends an SQL command which turns off the possibility to set values for IDENTITY (auto-increment) columns for the current table. Must be implemented in derived classes.
void TurnOffConstraints() Sends an SQL command which turns off the constraints for the current table. Must be implemented in derived classes.
void TurnOnAutoIncrement() Sends an SQL command which turns on the possibility to set values for IDENTITY (auto-increment) columns for the current table. Must be implemented in derived classes.
void TurnOnConstraints() Sends an SQL command which turns the constraints on for the current table. Must be implemented in derived classes.