Class MsSqlConnection

Namespace

Dynamicweb.DataManagement

Assembly

Dynamicweb.DataManagement.dll

Represents connection to instance of Microsoft SQL Server

[DMConnectionInfo(1, "Microsoft SQL Server")]
public class MsSqlConnection : RemoteServerConnection, ICloneable

Inheritance

object

DbObject

DMConnection

RemoteServerConnection

MsSqlConnection

Implements

ICloneable

Inherited Members

RemoteServerConnection.DBName

RemoteServerConnection.ServiceName

RemoteServerConnection.Server

RemoteServerConnection.UserID

RemoteServerConnection.Password

RemoteServerConnection.TrustedConnection

DMConnection.Name

DMConnection.Type

DMConnection.DW

DMConnection.Meta

DMConnection.Data

DMConnection.GetConnection(int, string)

DMConnection.GetConnection(int)

DMConnection.GetConnections()

DMConnection.GetConnectionsBySql(string)

DbObject._id

DbObject._tableName

DbObject._keyField

DbObject.ID

DbObject.IsNew

DbObject.Delete()

DbObject.Delete(int)

DbObject.Load(int)

DbObject.Save()

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

MsSqlConnection()

Default constructor

public MsSqlConnection()

Properties

ConnectionString

public string ConnectionString { get; }

Property Value

string

Methods

Clone()

Creates new MsSqlConnection object using data of current object

public override object Clone()

Returns

object

New MsSqlConnection object with copied data

Fill(IDataReader)

Fills current connection property with data of DataReader

public override void Fill(IDataReader dataReader)

Parameters

dataReader IDataReader

Source DataReader

FillRow(DataRow)

Fill fields: ServiceName, Server, UserId, Password, TrustedConnection

protected override void FillRow(DataRow row)

Parameters

row DataRow

GetAdapter()

Returns new SqlDataAdapter instance

public SqlDataAdapter GetAdapter()

Returns

SqlDataAdapter

SqlDataAdapter object

GetData()

protected override DMConnectionData GetData()

Returns

DMConnectionData

GetDatabaseConnection()

Gets SqlConnection instance

public SqlConnection GetDatabaseConnection()

Returns

SqlConnection

GetMeta()

protected override DMConnectionMeta GetMeta()

Returns

DMConnectionMeta