| Method | Description | |
|---|---|---|
| Dispose ( ) : void | ||
| Dispose ( bool disposing ) : void | ||
| ManualMigrationCheck ( ) : System |
constructor - undertakes a migration needed check
|
| Method | Description | |
|---|---|---|
|
BuildAnyMissingMigrationStepsSQL ( string>.Dictionary |
||
| CETableExists ( string tableName, SqlCeConnection sqlConnection ) : bool |
Function to check if a table exists in a CE database.
|
|
| CheckCE ( ) : void |
manual migration check for SQL Server Compact Edition (CE)
|
|
| CheckFull ( ) : void |
manual migration check for SQL Server full editions and Azure
|
|
| EnsureBitmasksPopulated ( ) : void | ||
| ExecCENativeSQL ( string sqlScript, SqlCeConnection sqlConnection ) : void |
Use to run T-SQL scripts for SQL Server CE which can't be run through DbCommand since they include native, non-standard commands such as "GO". As there is no CE equivilent to ServerConnection, we will chunk the script into segments seperated by each GO and make each segment a unique DbCommand call. We will also remove the key/index ASC option, CLUSTERED option, [dbo] schema name, WITH CHECK parameter from any script since these are not supported, and convert the (MAX) option to an appropriate value and GetUTCDate to GetDate since these is not supported either. Additionally, any chunk containing a trigger will be completely ignored (the entire chunk) and not run since triggers are not supported. Thus this function is also a translator for CE scripts.
|
|
|
ExecFullNativeSQL ( string sqlScript, |
Use to run T-SQL scripts for SQL Server or Azure which can't be run through DbCommand since they include native, non-standard commands such as "GO". This runs the scripts through a native interface instead. (Faster than splitting into separate DbCommand calls.)
|
