Class SqlServerCeProcessor

Inheritance

object

ProcessorBase

GenericProcessorBase

SqlServerCeProcessor

Implements

IMigrationProcessor

IQuerySchema

IDisposable

Inherited Members

GenericProcessorBase.ConnectionString

GenericProcessorBase.Connection

GenericProcessorBase.Factory

GenericProcessorBase.Transaction

GenericProcessorBase.BeginTransaction()

GenericProcessorBase.RollbackTransaction()

GenericProcessorBase.CommitTransaction()

ProcessorBase.WasCommitted

ProcessorBase.Process(CreateSchemaExpression)

ProcessorBase.Process(DeleteSchemaExpression)

ProcessorBase.Process(CreateTableExpression)

ProcessorBase.Process(AlterTableExpression)

ProcessorBase.Process(AlterColumnExpression)

ProcessorBase.Process(CreateColumnExpression)

ProcessorBase.Process(DeleteTableExpression)

ProcessorBase.Process(DeleteColumnExpression)

ProcessorBase.Process(CreateForeignKeyExpression)

ProcessorBase.Process(DeleteForeignKeyExpression)

ProcessorBase.Process(CreateIndexExpression)

ProcessorBase.Process(DeleteIndexExpression)

ProcessorBase.Process(RenameTableExpression)

ProcessorBase.Process(RenameColumnExpression)

ProcessorBase.Process(InsertDataExpression)

ProcessorBase.Process(DeleteDataExpression)

ProcessorBase.Process(AlterDefaultConstraintExpression)

ProcessorBase.Process(UpdateDataExpression)

ProcessorBase.Process(AlterSchemaExpression)

ProcessorBase.Process(CreateSequenceExpression)

ProcessorBase.Process(DeleteSequenceExpression)

ProcessorBase.Process(CreateConstraintExpression)

ProcessorBase.Process(DeleteConstraintExpression)

ProcessorBase.Process(DeleteDefaultConstraintExpression)

ProcessorBase.Execute(string)

ProcessorBase.Dispose()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

Namespace: FluentMigrator.Runner.Processors.SqlServer

Assembly: FluentMigrator.Runner.SqlServerCe.dll

Syntax

public sealed class SqlServerCeProcessor : GenericProcessorBase, IMigrationProcessor, IQuerySchema, IDisposable

Constructors

SqlServerCeProcessor(SqlServerCeDbFactory, SqlServerCeGenerator, ILogger<SqlServerCeProcessor>, IOptionsSnapshot<ProcessorOptions>, IConnectionStringAccessor, IServiceProvider)

Declaration

public SqlServerCeProcessor(SqlServerCeDbFactory factory, SqlServerCeGenerator generator, ILogger<SqlServerCeProcessor> logger, IOptionsSnapshot<ProcessorOptions> options, IConnectionStringAccessor connectionStringAccessor, IServiceProvider serviceProvider)

Parameters

Type	Name	Description
SqlServerCeDbFactory	factory
SqlServerCeGenerator	generator
ILogger<SqlServerCeProcessor>	logger
IOptionsSnapshot<ProcessorOptions>	options
IConnectionStringAccessor	connectionStringAccessor
IServiceProvider	serviceProvider

SqlServerCeProcessor(IDbConnection, IMigrationGenerator, IAnnouncer, IMigrationProcessorOptions, IDbFactory)

Declaration

[Obsolete]
public SqlServerCeProcessor(IDbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)

Parameters

Type	Name	Description
IDbConnection	connection
IMigrationGenerator	generator
IAnnouncer	announcer
IMigrationProcessorOptions	options
IDbFactory	factory

Properties

DatabaseType

Gets the database type

Declaration

public override string DatabaseType { get; }

Property Value

Type	Description
string

Overrides

ProcessorBase.DatabaseType

DatabaseTypeAliases

Gets the database type aliases

Declaration

public override IList<string> DatabaseTypeAliases { get; }

Property Value

Type	Description
IList<string>

Overrides

ProcessorBase.DatabaseTypeAliases

Methods

ColumnExists(string, string, string)

Tests if a column exists

Declaration

public override bool ColumnExists(string schemaName, string tableName, string columnName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name
string	columnName	The column name

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.ColumnExists(string, string, string)

ConstraintExists(string, string, string)

Tests if a constraint exists

Declaration

public override bool ConstraintExists(string schemaName, string tableName, string constraintName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name
string	constraintName	The constraint name

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.ConstraintExists(string, string, string)

CreateCommand(string, IDbConnection, IDbTransaction)

Declaration

protected override IDbCommand CreateCommand(string commandText, IDbConnection connection, IDbTransaction transaction)

Parameters

Type	Name	Description
string	commandText
IDbConnection	connection
IDbTransaction	transaction

Returns

Type	Description
IDbCommand

Overrides

GenericProcessorBase.CreateCommand(string, IDbConnection, IDbTransaction)

DefaultValueExists(string, string, string, object)

Tests if a default value for a column exists

Declaration

public override bool DefaultValueExists(string schemaName, string tableName, string columnName, object defaultValue)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name
string	columnName	The column name
object	defaultValue	The default value

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.DefaultValueExists(string, string, string, object)

Execute(string, params object[])

Execute an SQL statement

Declaration

public override void Execute(string template, params object[] args)

Parameters

Type	Name	Description
string	template	The SQL statement
object[]	args	The arguments to replace in the SQL statement

Overrides

ProcessorBase.Execute(string, params object[])

Exists(string, params object[])

Returns true if data could be found for the given SQL query

Declaration

public override bool Exists(string template, params object[] args)

Parameters

Type	Name	Description
string	template	The SQL query
object[]	args	The arguments of the SQL query

Returns

Type	Description
bool	true when the SQL query returned data

Overrides

ProcessorBase.Exists(string, params object[])

IndexExists(string, string, string)

Tests if an index exists

Declaration

public override bool IndexExists(string schemaName, string tableName, string indexName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name
string	indexName	The index name

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.IndexExists(string, string, string)

Process(PerformDBOperationExpression)

Executes a DB operation

Declaration

public override void Process(PerformDBOperationExpression expression)

Parameters

Type	Name	Description
PerformDBOperationExpression	expression	The expression to execute

Overrides

ProcessorBase.Process(PerformDBOperationExpression)

Process(string)

Declaration

protected override void Process(string sql)

Parameters

Type	Name	Description
string	sql

Overrides

ProcessorBase.Process(string)

Read(string, params object[])

Executes and returns the result of an SQL query

Declaration

public override DataSet Read(string template, params object[] args)

Parameters

Type	Name	Description
string	template	The SQL query
object[]	args	The arguments of the SQL query

Returns

Type	Description
DataSet	The data from the specified SQL query

Overrides

ProcessorBase.Read(string, params object[])

ReadTableData(string, string)

Reads all data from all rows from a table

Declaration

public override DataSet ReadTableData(string schemaName, string tableName)

Parameters

Type	Name	Description
string	schemaName	The schema name of the table
string	tableName	The table name

Returns

Type	Description
DataSet	The data from the specified table

Overrides

ProcessorBase.ReadTableData(string, string)

SchemaExists(string)

Tests if the schema exists

Declaration

public override bool SchemaExists(string schemaName)

Parameters

Type	Name	Description
string	schemaName	The schema name

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.SchemaExists(string)

SequenceExists(string, string)

Tests if a sequence exists

Declaration

public override bool SequenceExists(string schemaName, string sequenceName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	sequenceName	The sequence name

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.SequenceExists(string, string)

TableExists(string, string)

Tests if the table exists

Declaration

public override bool TableExists(string schemaName, string tableName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.TableExists(string, string)

Implements

IMigrationProcessor

IQuerySchema

IDisposable