SqlServerMigrationSqlGenerator Class

Reference

Definition

Namespace:: System.Data.Entity.Migrations.Sql

Assembly:: EntityFramework.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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: Object

MigrationSqlGenerator
SqlServerMigrationSqlGenerator

Derived: System.Data.Entity.Migrations.Sql.SqlCeMigrationSqlGenerator

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

Share via