Export (0) Print
Expand All

SqlServerMigrationSqlGenerator Class

Entity Framework 5.0

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

Namespace:  System.Data.Entity.Migrations.Sql
Assembly:  EntityFramework (in EntityFramework.dll)

public class SqlServerMigrationSqlGenerator : MigrationSqlGenerator

The SqlServerMigrationSqlGenerator type exposes the following members.

  NameDescription
Public methodSqlServerMigrationSqlGeneratorInitializes a new instance of the SqlServerMigrationSqlGenerator class.
Top

  NameDescription
Protected methodBuildColumnTypeGenerates SQL to specify the data type of a column. This method just generates the actual type, not the SQL to create the column.
Protected methodCreateConnectionCreates an empty connection for the current provider. Allows derived providers to use connection other than SqlConnection.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Protected methodGenerate(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.
Protected methodGenerate(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.
Protected methodGenerate(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.
Protected methodGenerate(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.
Protected methodGenerate(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.
Protected methodGenerate(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.
Protected methodGenerate(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.
Protected methodGenerate(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.
Protected methodGenerate(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.
Protected methodGenerate(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.
Protected methodGenerate(AddColumnOperation)Generates SQL for a AddColumnOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(AddForeignKeyOperation)Generates SQL for a AddForeignKeyOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(AddPrimaryKeyOperation)Generates SQL for a AddPrimaryKeyOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(AlterColumnOperation)Generates SQL for a AlterColumnOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(CreateIndexOperation)Generates SQL for a CreateIndexOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(CreateTableOperation)Generates SQL for a CreateTableOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(DeleteHistoryOperation)Generates SQL for a DeleteHistoryOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(DropColumnOperation)Generates SQL for a DropColumnOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(DropForeignKeyOperation)Generates SQL for a DropForeignKeyOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(DropIndexOperation)Generates SQL for a DropIndexOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(DropPrimaryKeyOperation)Generates SQL for a DropPrimaryKeyOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(DropTableOperation)Generates SQL for a DropTableOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(InsertHistoryOperation)Generates SQL for a InsertHistoryOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(MoveTableOperation)Generates SQL for a MoveTableOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(RenameColumnOperation)Generates SQL for a RenameColumnOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(RenameTableOperation)Generates SQL for a RenameTableOperation. Generated SQL should be added using the Statement method.
Protected methodGenerate(SqlOperation)Generates SQL for a SqlOperation. Generated SQL should be added using the Statement method.
Public methodGenerate(IEnumerable<MigrationOperation>, String)Converts a set of migration operations into Microsoft SQL Server specific SQL. (Overrides MigrationSqlGenerator.Generate(IEnumerable<MigrationOperation>, String).)
Protected methodGenerateCreateSchemaGenerates SQL to create a database schema. Generated SQL should be added using the Statement method.
Protected methodGenerateMakeSystemTableGenerates SQL to mark a table as a system table. Generated SQL should be added using the Statement method.
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Protected methodNameGenerates a quoted name. The supplied name may or may not contain the schema.
Protected methodQuoteQuotes an identifier for SQL Server.
Protected methodStatement(IndentedTextWriter)Adds a new Statement to be executed against the database.
Protected methodStatement(String, Boolean)Adds a new Statement to be executed against the database.
Public methodToString (Inherited from Object.)
Protected methodStatic memberWriterGets 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.
Top

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show:
© 2014 Microsoft