SqlCeMigrationSqlGenerator Class

  • Reference

Definition

Namespace:
System.Data.Entity.SqlServerCompact.Legacy
Assembly:
EntityFramework.SqlServerCompact.Legacy.dll

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

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Maintainability", "CA1506:AvoidExcessiveClassCoupling")]
public class SqlCeMigrationSqlGenerator : System.Data.Entity.Migrations.Sql.MigrationSqlGenerator
type SqlCeMigrationSqlGenerator = class
    inherit MigrationSqlGenerator
Public Class SqlCeMigrationSqlGenerator
Inherits MigrationSqlGenerator
Inheritance
Object
MigrationSqlGenerator
SqlCeMigrationSqlGenerator
Attributes
SuppressMessageAttribute

Constructors

SqlCeMigrationSqlGenerator()

Properties

GuidColumnDefault

Returns the column default value to use for store-generated GUID columns when no default value is explicitly specified in the migration. Always returns newid() for SQL Compact.
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(AlterProcedureOperation)

Generates the specified alter procedure operation.
Generate(AlterTableOperation)

Override this method to generate SQL when the definition of a table or its attributes are changed. The default implementation of this method does nothing.
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(ColumnModel, IndentedTextWriter)

Generates SQL for the given column model. This method is called by other methods that process columns and can be overridden to change the SQL generated.
Generate(CreateIndexOperation)

Generates SQL for a CreateIndexOperation. Generated SQL should be added using the Statement method.
Generate(CreateProcedureOperation)

Generates the specified create procedure operation.
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(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(DropProcedureOperation)

Generates the specified drop procedure operation.
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(HistoryOperation)

Generates SQL for a HistoryOperation. Generated SQL should be added using the Statement method.
Generate(IEnumerable<MigrationOperation>, String)

Converts a set of migration operations into Microsoft SQL Server specific SQL.
Generate(MigrationOperation)

Generates SQL for a MigrationOperation. Allows derived providers to handle additional operation types. Generated SQL should be added using the Statement method.
Generate(MoveProcedureOperation)

Generates the specified move procedure operation.
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(RenameIndexOperation)

Generates SQL for a RenameIndexOperation. Generated SQL should be added using the Statement method.
Generate(RenameProcedureOperation)

Generates the specified rename procedure operation.
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 or StatementBatch methods.
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.
Generate(UpdateDatabaseOperation)

Generates the specified update database operation which represents applying a series of migrations. The generated script is idempotent, meaning it contains conditional logic to check if individual migrations have already been applied and only apply the pending ones.
GenerateMakeSystemTable(CreateTableOperation, IndentedTextWriter)

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.
StatementBatch(String, Boolean)

Breaks string into one or more statements, handling T-SQL utility statements as necessary.
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