Class SqlUpdate

Namespace

Dynamicweb.Updates

Assembly

Dynamicweb.Core.dll

Represents an update which executes a given sql statement.

public class SqlUpdate : Update

Inheritance

object

Update

SqlUpdate

Inherited Members

Update.Key

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

SqlUpdate(string, UpdateProvider, string)

public SqlUpdate(string id, UpdateProvider provider, string sql)

Parameters

id string

provider UpdateProvider

sql string

SqlUpdate(string, UpdateProvider, string, string)

public SqlUpdate(string id, UpdateProvider provider, string sql, string sqlConditional)

Parameters

id string

provider UpdateProvider

sql string

sqlConditional string

Methods

AddColumn(string, UpdateProvider, string, string, string)

public static Update AddColumn(string id, UpdateProvider provider, string tableName, string columnName, string columnDefinition)

Parameters

id string

provider UpdateProvider

tableName string

columnName string

columnDefinition string

Returns

Update

AddIndex(string, UpdateProvider, string, string, string)

public static Update AddIndex(string id, UpdateProvider provider, string tableName, string indexName, string indexDefinition)

Parameters

id string

provider UpdateProvider

tableName string

indexName string

indexDefinition string

Returns

Update

AddTable(string, UpdateProvider, string, string)

public static Update AddTable(string id, UpdateProvider provider, string tableName, string tableDefinition)

Parameters

id string

provider UpdateProvider

tableName string

tableDefinition string

Returns

Update

ChangeColumn(string, UpdateProvider, string, string, string)

public static Update ChangeColumn(string id, UpdateProvider provider, string tableName, string columnName, string columnDefinition)

Parameters

id string

provider UpdateProvider

tableName string

columnName string

columnDefinition string

Returns

Update

DropColumn(string, UpdateProvider, string, string)

public static Update DropColumn(string id, UpdateProvider provider, string tableName, string columnName)

Parameters

id string

provider UpdateProvider

tableName string

columnName string

Returns

Update

Execute(UpdateContext)

public override void Execute(UpdateContext context)

Parameters

context UpdateContext

InitializeDatabase(UpdateProvider, string)

public static Update InitializeDatabase(UpdateProvider provider, string sqlConditional)

Parameters

provider UpdateProvider

sqlConditional string

Returns

Update