Share via


SqlServerMigrationSqlGenerator Class

Definition

Provider to convert provider agnostic migration operations into SQL commands that can be run against a Microsoft SQL Server database.

public class SqlServerMigrationSqlGenerator : System.Data.Entity.Migrations.Sql.MigrationSqlGenerator
type SqlServerMigrationSqlGenerator = class
    inherit MigrationSqlGenerator
Public Class SqlServerMigrationSqlGenerator
Inherits MigrationSqlGenerator
Inheritance
SqlServerMigrationSqlGenerator
Derived

Constructors

SqlServerMigrationSqlGenerator()

Properties

ProviderManifest

Gets or sets the provider manifest.

(Inherited from MigrationSqlGenerator)

Methods

BuildColumnType(ColumnModel)

Generates SQL to specify the data type of a column. This method just generates the actual type, not the SQL to create the column.

BuildStoreTypeUsage(String, PropertyModel)

Builds the store type usage for the specified storeTypeName using the facets from the specified propertyModel.

(Inherited from MigrationSqlGenerator)
CreateConnection()

Creates an empty connection for the current provider. Allows derived providers to use connection other than SqlConnection.

Generate(AddColumnOperation)

Generates SQL for a AddColumnOperation. Generated SQL should be added using the Statement method.

Generate(AddForeignKeyOperation)

Generates SQL for a AddForeignKeyOperation. Generated SQL should be added using the Statement method.

Generate(AddPrimaryKeyOperation)

Generates SQL for a AddPrimaryKeyOperation. Generated SQL should be added using the Statement method.

Generate(AlterColumnOperation)

Generates SQL for a AlterColumnOperation. Generated SQL should be added using the Statement method.

Generate(Boolean)

Generates SQL to specify a constant bool default value being set on a column. This method just generates the actual value, not the SQL to set the default value.

Generate(Byte[])

Generates SQL to specify a constant byte[] default value being set on a column. This method just generates the actual value, not the SQL to set the default value.

Generate(CreateIndexOperation)

Generates SQL for a CreateIndexOperation. Generated SQL should be added using the Statement method.

Generate(CreateTableOperation)

Generates SQL for a CreateTableOperation. Generated SQL should be added using the Statement method.

Generate(DateTime)

Generates SQL to specify a constant DateTime default value being set on a column. This method just generates the actual value, not the SQL to set the default value.

Generate(DateTimeOffset)

Generates SQL to specify a constant DateTimeOffset default value being set on a column. This method just generates the actual value, not the SQL to set the default value.

Generate(DbGeography)

Generates SQL to specify a constant geogrpahy default value being set on a column. This method just generates the actual value, not the SQL to set the default value.

Generate(DbGeometry)

Generates SQL to specify a constant geometry default value being set on a column. This method just generates the actual value, not the SQL to set the default value.

Generate(DeleteHistoryOperation)

Generates SQL for a DeleteHistoryOperation. Generated SQL should be added using the Statement method.

Generate(DropColumnOperation)

Generates SQL for a DropColumnOperation. Generated SQL should be added using the Statement method.

Generate(DropForeignKeyOperation)

Generates SQL for a DropForeignKeyOperation. Generated SQL should be added using the Statement method.

Generate(DropIndexOperation)

Generates SQL for a DropIndexOperation. Generated SQL should be added using the Statement method.

Generate(DropPrimaryKeyOperation)

Generates SQL for a DropPrimaryKeyOperation. Generated SQL should be added using the Statement method.

Generate(DropTableOperation)

Generates SQL for a DropTableOperation. Generated SQL should be added using the Statement method.

Generate(Guid)

Generates SQL to specify a constant Guid default value being set on a column. This method just generates the actual value, not the SQL to set the default value.

Generate(IEnumerable<MigrationOperation>, String)

Converts a set of migration operations into Microsoft SQL Server specific SQL.

Generate(InsertHistoryOperation)

Generates SQL for a InsertHistoryOperation. Generated SQL should be added using the Statement method.

Generate(MoveTableOperation)

Generates SQL for a MoveTableOperation. Generated SQL should be added using the Statement method.

Generate(Object)

Generates SQL to specify a constant default value being set on a column. This method just generates the actual value, not the SQL to set the default value.

Generate(RenameColumnOperation)

Generates SQL for a RenameColumnOperation. Generated SQL should be added using the Statement method.

Generate(RenameTableOperation)

Generates SQL for a RenameTableOperation. Generated SQL should be added using the Statement method.

Generate(SqlOperation)

Generates SQL for a SqlOperation. Generated SQL should be added using the Statement method.

Generate(String)

Generates SQL to specify a constant string default value being set on a column. This method just generates the actual value, not the SQL to set the default value.

Generate(TimeSpan)

Generates SQL to specify a constant TimeSpan default value being set on a column. This method just generates the actual value, not the SQL to set the default value.

GenerateCreateSchema(String)

Generates SQL to create a database schema. Generated SQL should be added using the Statement method.

GenerateMakeSystemTable(CreateTableOperation)

Generates SQL to mark a table as a system table. Generated SQL should be added using the Statement method.

GenerateProcedureBody(ICollection<DbModificationCommandTree>, String, String)

Generates the SQL body for a stored procedure.

(Inherited from MigrationSqlGenerator)
IsPermissionDeniedError(Exception)

Determines if a provider specific exception corresponds to a database-level permission denied error.

(Inherited from MigrationSqlGenerator)
Name(String)

Generates a quoted name. The supplied name may or may not contain the schema.

Quote(String)

Quotes an identifier for SQL Server.

Statement(IndentedTextWriter)

Adds a new Statement to be executed against the database.

Statement(String, Boolean)

Adds a new Statement to be executed against the database.

Writer()

Gets a new IndentedTextWriter that can be used to build SQL.

This is just a helper method to create a writer. Writing to the writer will not cause SQL to be registered for execution. You must pass the generated SQL to the Statement method.

Applies to