public MediaTypeMenu(NodeMenuCommandParameters parameters, ExplorerToolWindow parent)
{
var cmd = new CommonMenuCommandHandler(parent);
//Export to Xml
CreateXmlExportMenuItem(cmd, parameters);
}
public ContentTypeRootMenu(NodeMenuCommandParameters parameters, ExplorerToolWindow parent)
{
var cmd = new CommonMenuCommandHandler(parent);
//Import xml
CreateXmlImportMenuItem(cmd, parameters);
}
public TriggerContextMenu(MenuCommandParameters menuCommandParameters, ExplorerToolWindow parent)
{
var tcmd = new TriggerMenuCommandsHandler(parent);
CreateScriptAsCreateMenuItem(tcmd, menuCommandParameters);
CreateScriptAsDropMenuItem(tcmd, menuCommandParameters);
}
public ContentTypeMenu(NodeMenuCommandParameters parameters, ExplorerToolWindow parent)
{
var cmd = new CommonMenuCommandHandler(parent);
//Export to Xml
CreateXmlExportMenuItem(cmd, parameters);
//Items.Add(new Separator());
}
public IndexContextMenu(MenuCommandParameters menuCommandParameters, ExplorerToolWindow parent)
{
var tcmd = new IndexMenuCommandsHandler(parent);
CreateScriptAsCreateMenuItem(tcmd, menuCommandParameters);
CreateScriptAsDropMenuItem(tcmd, menuCommandParameters);
Items.Add(new Separator());
CreateScriptAsStatisticsMenuItem(tcmd, menuCommandParameters);
}
public ViewContextMenu(MenuCommandParameters menuCommandParameters, ExplorerToolWindow parent)
{
var tcmd = new ViewMenuCommandsHandler(parent);
//TODO Why does the Report Viewer fail?
//ReportDataMenuItem(tcmd, menuCommandParameters);
//Items.Add(new Separator());
CreateScriptAsCreateMenuItem(tcmd, menuCommandParameters);
CreateScriptAsDropMenuItem(tcmd, menuCommandParameters);
}
public ViewContextMenu(MenuCommandParameters menuCommandParameters, ExplorerToolWindow parent)
{
var tcmd = new ViewMenuCommandsHandler(parent);
CreateReportDataMenuItem(tcmd, menuCommandParameters);
AddSqlEditorItem(tcmd, menuCommandParameters);
Items.Add(new Separator());
CreateScriptAsCreateMenuItem(tcmd, menuCommandParameters);
CreateScriptAsDropMenuItem(tcmd, menuCommandParameters);
CreateScriptAsDropAndCreateMenuItem(tcmd, menuCommandParameters);
}
public TableContextMenu(MenuCommandParameters menuCommandParameters, ExplorerToolWindow parent)
{
var isSqlCe = menuCommandParameters.DatabaseInfo.DatabaseType == DatabaseType.SQLCE35 ||
menuCommandParameters.DatabaseInfo.DatabaseType == DatabaseType.SQLCE40;
var isSqlite = menuCommandParameters.DatabaseInfo.DatabaseType == DatabaseType.SQLite;
var tcmd = new TableMenuCommandsHandler(parent);
//Edit menu
CreateEditTableDataMenuItem(tcmd, menuCommandParameters);
ReportDataMenuItem(tcmd, menuCommandParameters);
AddSqlEditorItem(tcmd, menuCommandParameters);
Items.Add(new Separator());
if (isSqlCe)
{
AddColumnMenuItem(tcmd, menuCommandParameters);
AddIndexMenuItem(tcmd, menuCommandParameters);
AddFkMenuItem(tcmd, menuCommandParameters);
Items.Add(new Separator());
}
CreateScriptAsCreateMenuItem(tcmd, menuCommandParameters);
CreateScriptAsDropMenuItem(tcmd, menuCommandParameters);
if (!isSqlite)
{
CreateScriptAsDropAndCreateMenuItem(tcmd, menuCommandParameters);
}
Items.Add(new Separator());
CreateScriptAsSelectMenuItem(tcmd, menuCommandParameters);
CreateScriptAsInsertMenuItem(tcmd, menuCommandParameters);
CreateScriptAsUpdateMenuItem(tcmd, menuCommandParameters);
CreateScriptAsDeleteMenuItem(tcmd, menuCommandParameters);
CreateScriptAsDataMenuItem(tcmd, menuCommandParameters);
#if SSMS
if (isSqlCe)
{
CreateScriptAsSQLCLRSampleMenuItem(tcmd, menuCommandParameters);
}
#endif
Items.Add(new Separator());
ImportDataMenuItem(tcmd, menuCommandParameters);
Items.Add(new Separator());
if (isSqlCe)
{
CompareDataMenuItem(tcmd, menuCommandParameters);
Items.Add(new Separator());
}
RenameMenuItem(tcmd, menuCommandParameters);
if (isSqlCe)
{
DescriptionMenuItem(tcmd, menuCommandParameters);
}
}
public IndexContextMenu(MenuCommandParameters menuCommandParameters, ExplorerToolWindow parent)
{
var isSqlCe = menuCommandParameters.DatabaseInfo.DatabaseType == DatabaseType.SQLCE35 ||
menuCommandParameters.DatabaseInfo.DatabaseType == DatabaseType.SQLCE40;
var tcmd = new IndexMenuCommandsHandler(parent);
CreateScriptAsCreateMenuItem(tcmd, menuCommandParameters);
CreateScriptAsDropMenuItem(tcmd, menuCommandParameters);
if (isSqlCe)
{
Items.Add(new Separator());
CreateScriptAsStatisticsMenuItem(tcmd, menuCommandParameters);
}
}
public ViewsContextMenu(DatabaseMenuCommandParameters menuCommandParameters, ExplorerToolWindow parent)
{
var dcmd = new DatabaseMenuCommandsHandler(parent);
var refreshCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.RefreshViews);
var refreshMenuItem = new MenuItem
{
Header = "Refresh",
Icon = ImageHelper.GetImageFromResource("../resources/refresh_16xLG.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = menuCommandParameters
};
refreshMenuItem.CommandBindings.Add(refreshCommandBinding);
Items.Add(refreshMenuItem);
}
public ColumnContextMenu(MenuCommandParameters menuCommandParameters, ExplorerToolWindow parent)
{
if (menuCommandParameters.DatabaseInfo.DatabaseType == DatabaseType.SQLite)
{
return;
}
var tcmd = new ColumnMenuCommandsHandler(parent);
CreateModifyColumnMenuItem(tcmd, menuCommandParameters);
Items.Add(new Separator());
CreateScriptAsCreateMenuItem(tcmd, menuCommandParameters);
CreateScriptAsDropMenuItem(tcmd, menuCommandParameters);
CreateScriptAsAlterMenuItem(tcmd, menuCommandParameters);
Items.Add(new Separator());
CreateDescriptionMenuItem(tcmd, menuCommandParameters);
}
public GenericMenu(NodeMenuCommandParameters parameters, ExplorerToolWindow parent)
{
var cmd = new CommonMenuCommandHandler(parent);
//Rename
CreateRenameMenuItem(cmd, parameters);
//Move
//CreateMoveMenuItem(cmd, parameters);
Items.Add(new Separator());
//Delete
CreateDeleteMenuItem(cmd, parameters);
//Trash
CreateTrashMenuItem(cmd, parameters);
Items.Add(new Separator());
//Serialize item to xml
CreateXmlExportMenuItem(cmd, parameters);
}
public ScopesContextMenu(MenuCommandParameters scopeMenuCommandParameters, ExplorerToolWindow parent)
{
var dcmd = new ScopesMenuCommandsHandler(parent);
if (scopeMenuCommandParameters.MenuItemType == MenuType.Manage)
{
var dropScopeCommandBinding = new CommandBinding(ScopesMenuCommands.ScopeCommand,
dcmd.DropScope);
var dropScopeMenuItem = new MenuItem
{
Header = "Deprovision Scope...",
Icon = ImageHelper.GetImageFromResource("../resources/action_Cancel_16xLG.png"),
Command = ScopesMenuCommands.ScopeCommand,
CommandParameter = scopeMenuCommandParameters,
};
dropScopeMenuItem.CommandBindings.Add(dropScopeCommandBinding);
Items.Add(dropScopeMenuItem);
}
else
{
}
}
public BaseCommandHandler(ExplorerToolWindow parent)
{
ParentWindow = parent;
}
protected BaseCommandHandler(ExplorerToolWindow parent)
{
_parentWindow = parent;
}
public DatabasesContextMenu(DatabaseMenuCommandParameters databaseMenuCommandParameters, ExplorerToolWindow parent)
{
var dcmd = new DatabasesMenuCommandsHandler(parent);
var ver40IsInstalled = DataConnectionHelper.IsV40Installed();
var ver35IsInstalled = DataConnectionHelper.IsV35Installed();
var pkg = parent.Package as SqlCeToolboxPackage;
Items.Add(BuildAddCeDatabaseMenuItem(databaseMenuCommandParameters, dcmd, pkg, ver40IsInstalled));
Items.Add(BuildAddCe35DatabaseMenuItem(databaseMenuCommandParameters, dcmd, pkg, ver35IsInstalled));
Items.Add(BuildAddSqLiteDatabaseMenuItem(databaseMenuCommandParameters, dcmd));
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(BuildAddSqlServerDatabaseMenuItem(databaseMenuCommandParameters, dcmd));
}
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(BuildAddFromSolutionMenuItem(databaseMenuCommandParameters, dcmd, ver40IsInstalled, ver35IsInstalled));
}
Items.Add(BuildFixConnectionsMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(new Separator());
Items.Add(BuildDesignDatabaseMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(new Separator());
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(BuildLocalDatabaseCacheMenuItem(databaseMenuCommandParameters, dcmd, ver35IsInstalled));
}
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(new Separator());
}
Items.Add(BuildVersionDetectMenuItem(databaseMenuCommandParameters, dcmd));
}
public SqliteDatabaseContextMenu(DatabaseMenuCommandParameters databaseMenuCommandParameters, ExplorerToolWindow parent)
{
var itemBuilder = new DatabaseContextMenuItems();
var dbType = databaseMenuCommandParameters.DatabaseInfo.DatabaseType;
if (dbType != DatabaseType.SQLite)
{
return;
}
var dcmd = new DatabaseMenuCommandsHandler(parent);
Items.Add(itemBuilder.BuildShowSqlEditorMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(itemBuilder.BuildCreateTableMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(new Separator());
var scriptDatabaseRootMenuItem = new MenuItem
{
Header = "Script Database",
Icon = ImageHelper.GetImageFromResource("../resources/script_16xLG.png"),
};
var toolTip = new ToolTip
{
Content = "Generate a SQL Server Compact/SQLite compatible database script"
};
// Database scripting items
var scriptDatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.ScriptDatabase);
scriptDatabaseRootMenuItem.Items.Add(itemBuilder.BuildScriptDatabaseSchemaMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(itemBuilder.BuildScriptDatabaseSchemaDataMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(itemBuilder.BuildScriptDatabaseDataMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
//End Database scripting items
Items.Add(scriptDatabaseRootMenuItem);
Items.Add(new Separator());
var maintenanceMenuItem = new MenuItem
{
Header = "Maintenance",
Icon = ImageHelper.GetImageFromResource("../resources/Hammer_Builder_16xLG.png"),
};
var shrinkMenuItem = itemBuilder.BuildShrinkMenuItem(databaseMenuCommandParameters, dcmd);
maintenanceMenuItem.Items.Add(shrinkMenuItem);
var compactMenuItem = itemBuilder.BuildCompactMenuItem(databaseMenuCommandParameters, dcmd);
maintenanceMenuItem.Items.Clear();
compactMenuItem.Header = "Vacuum";
compactMenuItem.ToolTip = "Rebuilds the database file, repacking it into a minimal amount of disk space";
shrinkMenuItem.Header = "Re-index";
shrinkMenuItem.ToolTip = "Deletes and recreates indexes";
maintenanceMenuItem.Items.Add(compactMenuItem);
maintenanceMenuItem.Items.Add(shrinkMenuItem);
Items.Add(maintenanceMenuItem);
Items.Add(new Separator());
Items.Add(itemBuilder.BuildScriptDatabaseExportMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(new Separator());
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(itemBuilder.BuildScriptDatabaseGraphMenuItem(databaseMenuCommandParameters, dcmd));
}
Items.Add(itemBuilder.BuildDocDatabaseMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(new Separator());
var generateCodeRootMenuItem = new MenuItem
{
Header = "Generate Code",
Icon = ImageHelper.GetImageFromResource("../resources/Schema_16xLG.png"),
};
#if SSMS
#else
if (SqlCeToolboxPackage.VsSupportsEfCore())
{
generateCodeRootMenuItem.Items.Add(itemBuilder.BuildEfCoreModelMenuItem(databaseMenuCommandParameters, dcmd));
}
#endif
generateCodeRootMenuItem.Items.Add(BuildScriptModelMenuItem(databaseMenuCommandParameters, dcmd));
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(generateCodeRootMenuItem);
}
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(new Separator());
}
Items.Add(itemBuilder.BuildGenerateInfoMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(new Separator());
if (!databaseMenuCommandParameters.DatabaseInfo.FromServerExplorer)
{
Items.Add(itemBuilder.BuildRenameConnectionMenuItem(databaseMenuCommandParameters, dcmd));
}
Items.Add(itemBuilder.BuildRemoveConnectionMenuItem(databaseMenuCommandParameters, dcmd));
}
public SqlServerDatabaseMenuCommandsHandler(ExplorerToolWindow parent)
{
_package = parent.Package as SqlCeToolboxPackage;
}
public ScopesMenuCommandsHandler(ExplorerToolWindow parent)
{
_parentWindow = parent;
}
public SqlCeDatabaseContextMenu(DatabaseMenuCommandParameters databaseMenuCommandParameters, ExplorerToolWindow parent)
{
var itemBuilder = new DatabaseContextMenuItems();
var dbType = databaseMenuCommandParameters.DatabaseInfo.DatabaseType;
if (!(dbType == DatabaseType.SQLCE35 ||
dbType == DatabaseType.SQLCE40))
{
return;
}
var dcmd = new DatabaseMenuCommandsHandler(parent);
var cecmd = new SqlCeDatabaseMenuCommandsHandler(parent);
Items.Add(itemBuilder.BuildShowSqlEditorMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(itemBuilder.BuildCreateTableMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(new Separator());
var scriptDatabaseRootMenuItem = new MenuItem
{
Header = "Script Database",
Icon = ImageHelper.GetImageFromResource("../resources/script_16xLG.png"),
};
var toolTip = new ToolTip
{
Content = "Generate a SQL Server Compact/SQLite compatible database script"
};
// Database scripting items
var scriptDatabaseCommandBinding =
new CommandBinding(DatabaseMenuCommands.DatabaseCommand, dcmd.ScriptDatabase);
scriptDatabaseRootMenuItem.Items.Add(itemBuilder.BuildScriptDatabaseSchemaMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(itemBuilder.BuildScriptDatabaseSchemaDataMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(BuildScriptAzureSchemaDataMenuItem(databaseMenuCommandParameters, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(itemBuilder.BuildScriptDatabaseSchemaDataSqLiteMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(itemBuilder.BuildScriptDatabaseSchemaDataBlobMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(itemBuilder.BuildScriptDatabaseDataMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseDataForServerMenuItem(databaseMenuCommandParameters, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseDiffMenuItem(databaseMenuCommandParameters, dcmd));
//End Database scripting items
Items.Add(scriptDatabaseRootMenuItem);
Items.Add(new Separator());
var maintenanceMenuItem = new MenuItem
{
Header = "Maintenance",
Icon = ImageHelper.GetImageFromResource("../resources/Hammer_Builder_16xLG.png"),
};
maintenanceMenuItem.Items.Add(BuildPwdMenuItem(databaseMenuCommandParameters, cecmd));
var shrinkMenuItem = itemBuilder.BuildShrinkMenuItem(databaseMenuCommandParameters, dcmd);
maintenanceMenuItem.Items.Add(shrinkMenuItem);
var compactMenuItem = itemBuilder.BuildCompactMenuItem(databaseMenuCommandParameters, dcmd);
maintenanceMenuItem.Items.Add(compactMenuItem);
maintenanceMenuItem.Items.Add(BuildVerifyMenuItem(databaseMenuCommandParameters, cecmd));
maintenanceMenuItem.Items.Add(BuildRepairDeleteMenuItem(databaseMenuCommandParameters, cecmd));
maintenanceMenuItem.Items.Add(BuildRepairRecoverAllMenuItem(databaseMenuCommandParameters, cecmd));
maintenanceMenuItem.Items.Add(BuildRepairRecoverPossibleMenuItem(databaseMenuCommandParameters, cecmd));
Items.Add(maintenanceMenuItem);
Items.Add(new Separator());
Items.Add(itemBuilder.BuildScriptDatabaseExportMenuItem(databaseMenuCommandParameters, dcmd));
if (dbType == DatabaseType.SQLCE35 &&
Helpers.RepositoryHelper.IsV40Installed())
{
Items.Add(BuildScriptUpgradeMenuItem(databaseMenuCommandParameters, cecmd));
}
Items.Add(new Separator());
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(itemBuilder.BuildScriptDatabaseGraphMenuItem(databaseMenuCommandParameters, dcmd));
}
Items.Add(itemBuilder.BuildDocDatabaseMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(new Separator());
var generateCodeRootMenuItem = new MenuItem
{
Header = "Generate Code",
Icon = ImageHelper.GetImageFromResource("../resources/Schema_16xLG.png"),
};
#if SSMS
#else
var scriptDcCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
cecmd.GenerateDataContextInProject);
generateCodeRootMenuItem.Items.Add(BuildScriptDcMenuItem(databaseMenuCommandParameters, scriptDcCommandBinding));
generateCodeRootMenuItem.Items.Add(BuildScriptWpdcMenuItem(databaseMenuCommandParameters, scriptDcCommandBinding, dbType));
generateCodeRootMenuItem.Items.Add(new Separator());
#endif
var syncFxRootMenuItem = new MenuItem
{
Header = "Sync Framework Tools",
Icon = ImageHelper.GetImageFromResource("../resources/Synchronize_16xLG.png"),
};
var isSyncFxInstalled = DataConnectionHelper.IsSyncFx21Installed();
syncFxRootMenuItem.Items.Add(BuildSyncFxProvisionMenuItem(databaseMenuCommandParameters, cecmd, dbType, isSyncFxInstalled));
syncFxRootMenuItem.Items.Add(BuildSyncFxDeprovisionMenuItem(databaseMenuCommandParameters, cecmd, dbType, isSyncFxInstalled));
syncFxRootMenuItem.Items.Add(BuildSyncFxGenerateSnapshotMenuItem(databaseMenuCommandParameters, cecmd, dbType, isSyncFxInstalled));
generateCodeRootMenuItem.Items.Add(BuildSyncFxMenuItem(databaseMenuCommandParameters, cecmd, dbType, isSyncFxInstalled));
generateCodeRootMenuItem.Items.Add(syncFxRootMenuItem);
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(generateCodeRootMenuItem);
}
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(new Separator());
}
Items.Add(BuildAddDescriptionMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(itemBuilder.BuildGenerateInfoMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(new Separator());
Items.Add(BuildCopyConnectionMenuItem(databaseMenuCommandParameters, cecmd));
Items.Add(itemBuilder.BuildRemoveConnectionMenuItem(databaseMenuCommandParameters, dcmd));
}
public KeyMenuCommandsHandler(ExplorerToolWindow parent)
{
ParentWindow = parent;
}
public SubscriptionsContextMenu(MenuCommandParameters subsMenuCommandParameters, ExplorerToolWindow parent)
{
var dcmd = new SubscriptionsMenuCommandsHandler(parent);
if (subsMenuCommandParameters.MenuItemType == MenuType.Manage)
{
var newSubsCommandBinding = new CommandBinding(SubscriptionsMenuCommands.SubscriptionCommand,
dcmd.NewSubscription);
var newSubsMenuItem = new MenuItem
{
Header = "Manage Subscription...",
Icon = ImageHelper.GetImageFromResource("../resources/arrow_Sync_16xLG.png"),
Command = SubscriptionsMenuCommands.SubscriptionCommand,
CommandParameter = subsMenuCommandParameters,
};
newSubsMenuItem.CommandBindings.Add(newSubsCommandBinding);
Items.Add(newSubsMenuItem);
var dropSubsCommandBinding = new CommandBinding(SubscriptionsMenuCommands.SubscriptionCommand,
dcmd.DropSubscription);
var dropSubsMenuItem = new MenuItem
{
Header = "Drop Subscription...",
Icon = ImageHelper.GetImageFromResource("../resources/arrow_Sync_16xLG.png"),
Command = SubscriptionsMenuCommands.SubscriptionCommand,
CommandParameter = subsMenuCommandParameters,
};
dropSubsMenuItem.CommandBindings.Add(dropSubsCommandBinding);
Items.Add(dropSubsMenuItem);
}
else
{
var newSubsCommandBinding = new CommandBinding(SubscriptionsMenuCommands.SubscriptionCommand,
dcmd.NewSubscription);
var newSubsMenuItem = new MenuItem
{
Header = "New Subscription...",
Icon = ImageHelper.GetImageFromResource("../resources/arrow_Sync_16xLG.png"),
Command = SubscriptionsMenuCommands.SubscriptionCommand,
CommandParameter = subsMenuCommandParameters,
};
newSubsMenuItem.CommandBindings.Add(newSubsCommandBinding);
Items.Add(newSubsMenuItem);
}
}
public DatabaseContextMenu(DatabaseMenuCommandParameters databaseMenuCommandParameters, ExplorerToolWindow parent)
{
var dbType = databaseMenuCommandParameters.DatabaseInfo.DatabaseType;
var isSqlCe = dbType == DatabaseType.SQLCE35 ||
dbType == DatabaseType.SQLCE40;
var dcmd = new DatabaseMenuCommandsHandler(parent);
var cecmd = new SqlCeDatabaseMenuCommandsHandler(parent);
Items.Add(BuildShowSqlEditorMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(BuildCreateTableMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(new Separator());
var scriptDatabaseRootMenuItem = new MenuItem
{
Header = "Script Database",
Icon = ImageHelper.GetImageFromResource("../resources/script_16xLG.png"),
};
// Database scripting items
var scriptDatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.ScriptDatabase);
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseSchemaMenuItem(databaseMenuCommandParameters, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseSchemaDataMenuItem(databaseMenuCommandParameters, scriptDatabaseCommandBinding));
if (isSqlCe)
{
scriptDatabaseRootMenuItem.Items.Add(BuildScriptAzureSchemaDataMenuItem(databaseMenuCommandParameters, scriptDatabaseCommandBinding));
}
if (isSqlCe)
{
scriptDatabaseRootMenuItem.Items.Add(BuildScriptSqliteSchemaDataMenuItem(databaseMenuCommandParameters, scriptDatabaseCommandBinding));
}
if (isSqlCe)
{
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseSchemaDataBlobMenuItem(databaseMenuCommandParameters, scriptDatabaseCommandBinding));
}
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseDataMenuItem(databaseMenuCommandParameters, scriptDatabaseCommandBinding));
if (isSqlCe)
{
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseDataForServerMenuItem(databaseMenuCommandParameters, scriptDatabaseCommandBinding));
}
if (isSqlCe)
{
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseDiffMenuItem(databaseMenuCommandParameters, dcmd));
}
//End Database scripting items
Items.Add(scriptDatabaseRootMenuItem);
Items.Add(new Separator());
var maintenanceMenuItem = new MenuItem
{
Header = "Maintenance",
Icon = ImageHelper.GetImageFromResource("../resources/Hammer_Builder_16xLG.png"),
};
maintenanceMenuItem.Items.Add(BuildPwdMenuItem(databaseMenuCommandParameters, cecmd));
var shrinkMenuItem = BuildShrinkMenuItem(databaseMenuCommandParameters, dcmd);
maintenanceMenuItem.Items.Add(shrinkMenuItem);
var compactMenuItem = BuildCompactMenuItem(databaseMenuCommandParameters, dcmd);
maintenanceMenuItem.Items.Add(compactMenuItem);
maintenanceMenuItem.Items.Add(BuildVerifyMenuItem(databaseMenuCommandParameters, cecmd));
maintenanceMenuItem.Items.Add(BuildRepairDeleteMenuItem(databaseMenuCommandParameters, cecmd));
maintenanceMenuItem.Items.Add(BuildRepairRecoverAllMenuItem(databaseMenuCommandParameters, cecmd));
maintenanceMenuItem.Items.Add(BuildRepairRecoverPossibleMenuItem(databaseMenuCommandParameters, cecmd));
if (isSqlCe)
{
Items.Add(maintenanceMenuItem);
Items.Add(new Separator());
}
if (dbType == DatabaseType.SQLite)
{
maintenanceMenuItem.Items.Clear();
compactMenuItem.Header = "Vacuum";
compactMenuItem.ToolTip = "Rebuilds the database file, repacking it into a minimal amount of disk space";
shrinkMenuItem.Header = "Re-index";
shrinkMenuItem.ToolTip = "Deletes and recreates indexes";
maintenanceMenuItem.Items.Add(compactMenuItem);
maintenanceMenuItem.Items.Add(shrinkMenuItem);
Items.Add(maintenanceMenuItem);
Items.Add(new Separator());
}
Items.Add(BuildScriptDatabaseExportMenuItem(databaseMenuCommandParameters, dcmd));
if (dbType == DatabaseType.SQLCE35 &&
DataConnectionHelper.IsV40Installed())
{
Items.Add(BuildScriptUpgradeMenuItem(databaseMenuCommandParameters, cecmd));
}
Items.Add(new Separator());
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(BuildScriptDatabaseGraphMenuItem(databaseMenuCommandParameters, dcmd));
}
Items.Add(BuildDocDatabaseMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(new Separator());
var generateCodeRootMenuItem = new MenuItem
{
Header = "Generate Code",
Icon = ImageHelper.GetImageFromResource("../resources/Schema_16xLG.png"),
};
#if SSMS
#else
if (dbType != DatabaseType.SQLCE35)
{
generateCodeRootMenuItem.Items.Add(BuildEfCoreModelMenuItem(databaseMenuCommandParameters, dcmd));
}
#endif
if (dbType == DatabaseType.SQLite)
{
generateCodeRootMenuItem.Items.Add(BuildScriptModelMenuItem(databaseMenuCommandParameters, dcmd));
}
if (isSqlCe && SqlCeToolboxPackage.VsSupportsEf6())
{
generateCodeRootMenuItem.Items.Add(BuildScriptEfPocoMenuItem(databaseMenuCommandParameters, dcmd));
}
#if SSMS
#else
var scriptDcCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
cecmd.GenerateDataContextInProject);
if (isSqlCe)
{
generateCodeRootMenuItem.Items.Add(BuildScriptDcMenuItem(databaseMenuCommandParameters, scriptDcCommandBinding));
}
if (isSqlCe)
{
generateCodeRootMenuItem.Items.Add(BuildScriptWpdcMenuItem(databaseMenuCommandParameters, scriptDcCommandBinding, dbType));
}
if (isSqlCe)
{
generateCodeRootMenuItem.Items.Add(new Separator());
}
#endif
var syncFxRootMenuItem = new MenuItem
{
Header = "Sync Framework Tools",
Icon = ImageHelper.GetImageFromResource("../resources/Synchronize_16xLG.png"),
};
var isSyncFxInstalled = DataConnectionHelper.IsSyncFx21Installed();
syncFxRootMenuItem.Items.Add(BuildSyncFxProvisionMenuItem(databaseMenuCommandParameters, cecmd, dbType, isSyncFxInstalled));
syncFxRootMenuItem.Items.Add(BuildSyncFxDeprovisionMenuItem(databaseMenuCommandParameters, cecmd, dbType, isSyncFxInstalled));
syncFxRootMenuItem.Items.Add(BuildSyncFxGenerateSnapshotMenuItem(databaseMenuCommandParameters, cecmd, dbType, isSyncFxInstalled));
if (isSqlCe)
{
generateCodeRootMenuItem.Items.Add(BuildSyncFxMenuItem(databaseMenuCommandParameters, cecmd, dbType, isSyncFxInstalled));
}
if (isSqlCe)
{
generateCodeRootMenuItem.Items.Add(syncFxRootMenuItem);
}
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(generateCodeRootMenuItem);
}
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(new Separator());
}
if (isSqlCe)
{
Items.Add(BuildAddDescriptionMenuItem(databaseMenuCommandParameters, dcmd));
}
Items.Add(BuildGenerateInfoMenuItem(databaseMenuCommandParameters, dcmd));
Items.Add(new Separator());
Items.Add(BuildCopyConnectionMenuItem(databaseMenuCommandParameters, cecmd));
if (!databaseMenuCommandParameters.DatabaseInfo.FromServerExplorer)
{
Items.Add(BuildRenameConnectionMenuItem(databaseMenuCommandParameters, dcmd));
}
Items.Add(BuildRemoveCeConnectionMenuItem(databaseMenuCommandParameters, dcmd));
}
public TableMenuCommandsHandler(ExplorerToolWindow parent) : base(parent)
{
}
public SqlServerDatabaseContextMenu(DatabaseMenuCommandParameters databaseMenuCommandParameters, ExplorerToolWindow parent)
{
var dcmd = new SqlServerDatabaseMenuCommandsHandler(parent);
var dbcmd = new DatabaseMenuCommandsHandler(parent);
var isSqlCe40Installed = DataConnectionHelper.IsV40Installed();
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(BuildScriptDatabaseGraphMenuItem(databaseMenuCommandParameters, dcmd));
}
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(new Separator());
}
var scriptDatabaseRootMenuItem = new MenuItem
{
Header = "Script Database",
Icon = ImageHelper.GetImageFromResource("../resources/script_16xLG.png"),
};
var toolTip = new ToolTip
{
Content = "Generate a SQL Server Compact compatible database script from SQL Server 2005+"
};
var scriptDatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand, dcmd.ScriptServerDatabase);
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseSchemaMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseDataMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseSchemaDataMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseSchemaDataSqLiteMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseSchemaSqLiteMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
scriptDatabaseRootMenuItem.Items.Add(BuildScriptDatabaseSchemaDataBlobMenuItem(databaseMenuCommandParameters, toolTip, scriptDatabaseCommandBinding));
Items.Add(scriptDatabaseRootMenuItem);
Items.Add(new Separator());
#if SSMS
#else
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(BuildEfCoreModelMenuItem(databaseMenuCommandParameters, dbcmd));
}
#endif
#if VS2010
#else
if (SqlCeToolboxPackage.VsSupportsEf6())
{
Items.Add(BuildScriptEfPocoDacPacMenuItem(databaseMenuCommandParameters, dcmd));
}
#endif
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(new Separator());
}
Items.Add(BuildExportServerMenuItem(databaseMenuCommandParameters, dcmd, isSqlCe40Installed));
Items.Add(BuildExportServerToLiteMenuItem(databaseMenuCommandParameters, dcmd));
}
public SubscriptionsMenuCommandsHandler(ExplorerToolWindow parent)
{
_parentWindow = parent;
}
public TablesContextMenu(DatabaseMenuCommandParameters menuCommandParameters, ExplorerToolWindow parent)
{
var dcmd = new DatabaseMenuCommandsHandler(parent);
var createTableCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.BuildTable);
var createTableMenuItem = new MenuItem
{
Header = "Build Table (beta)...",
Icon = ImageHelper.GetImageFromResource("../resources/AddTable_5632.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = menuCommandParameters
};
createTableMenuItem.CommandBindings.Add(createTableCommandBinding);
Items.Add(createTableMenuItem);
Items.Add(new Separator());
var refreshCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.RefreshTables);
var refreshMenuItem = new MenuItem
{
Header = "Refresh",
Icon = ImageHelper.GetImageFromResource("../resources/refresh_16xLG.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = menuCommandParameters
};
refreshMenuItem.CommandBindings.Add(refreshCommandBinding);
Items.Add(refreshMenuItem);
}
public CommonMenuCommandHandler(ExplorerToolWindow parent) : base(parent)
{
}
public DatabaseMenuCommandsHandler(ExplorerToolWindow parent)
{
_parentWindow = parent;
package = _parentWindow.Package as SqlCeToolboxPackage;
}
public SqlServerDatabaseContextMenu(DatabaseMenuCommandParameters databaseMenuCommandParameters, ExplorerToolWindow parent)
{
var dcmd = new DatabasesMenuCommandsHandler(parent);
bool isSqlCe40Installed = DataConnectionHelper.IsV40Installed();
var scriptGraphCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.GenerateServerDgmlFiles);
var scriptDatabaseGraphMenuItem = new MenuItem
{
Header = "Create SQL Server Database Graph (DGML)...",
Icon = ImageHelper.GetImageFromResource("../resources/Diagram_16XLG.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
};
scriptDatabaseGraphMenuItem.CommandBindings.Add(scriptGraphCommandBinding);
Items.Add(scriptDatabaseGraphMenuItem);
Items.Add(new Separator());
var scriptDatabaseRootMenuItem = new MenuItem
{
Header = "Script SQL Server Database",
Icon = ImageHelper.GetImageFromResource("../resources/script_16xLG.png"),
};
var toolTip = new ToolTip();
toolTip.Content = "Generate a SQL Server Compact compatible database script from SQL Server 2005+";
var scriptDatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.ScriptServerDatabase);
var scriptDatabaseSchemaMenuItem = new MenuItem
{
Header = "Script SQL Server Database Schema...",
Icon = ImageHelper.GetImageFromResource("../resources/script_16xLG.png"),
ToolTip = toolTip,
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
Tag = SqlCeScripting.Scope.Schema
};
scriptDatabaseSchemaMenuItem.CommandBindings.Add(scriptDatabaseCommandBinding);
scriptDatabaseRootMenuItem.Items.Add(scriptDatabaseSchemaMenuItem);
var scriptDatabaseDataMenuItem = new MenuItem
{
Header = "Script SQL Server Database Data...",
Icon = ImageHelper.GetImageFromResource("../resources/script_16xLG.png"),
ToolTip = toolTip,
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
Tag = SqlCeScripting.Scope.DataOnly
};
scriptDatabaseDataMenuItem.CommandBindings.Add(scriptDatabaseCommandBinding);
scriptDatabaseRootMenuItem.Items.Add(scriptDatabaseDataMenuItem);
var scriptDatabaseSchemaDataMenuItem = new MenuItem
{
Header = "Script SQL Server Database Schema and Data...",
Icon = ImageHelper.GetImageFromResource("../resources/script_16xLG.png"),
ToolTip = toolTip,
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
Tag = SqlCeScripting.Scope.SchemaData
};
scriptDatabaseSchemaDataMenuItem.CommandBindings.Add(scriptDatabaseCommandBinding);
scriptDatabaseRootMenuItem.Items.Add(scriptDatabaseSchemaDataMenuItem);
var scriptDatabaseSchemaDataSqLiteMenuItem = new MenuItem
{
Header = "Script SQL Server Database Schema and Data for SQLite...",
Icon = ImageHelper.GetImageFromResource("../resources/script_16xLG.png"),
ToolTip = toolTip,
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
Tag = SqlCeScripting.Scope.SchemaDataSQLite
};
scriptDatabaseSchemaDataSqLiteMenuItem.CommandBindings.Add(scriptDatabaseCommandBinding);
scriptDatabaseRootMenuItem.Items.Add(scriptDatabaseSchemaDataSqLiteMenuItem);
var scriptDatabaseSchemaSqLiteMenuItem = new MenuItem
{
Header = "Script SQL Server Database Schema for SQLite...",
Icon = ImageHelper.GetImageFromResource("../resources/script_16xLG.png"),
ToolTip = toolTip,
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
Tag = SqlCeScripting.Scope.SchemaSQLite
};
scriptDatabaseSchemaSqLiteMenuItem.CommandBindings.Add(scriptDatabaseCommandBinding);
scriptDatabaseRootMenuItem.Items.Add(scriptDatabaseSchemaSqLiteMenuItem);
var scriptDatabaseSchemaDataBlobMenuItem = new MenuItem
{
Header = "Script SQL Server Database Schema and Data with BLOBs...",
ToolTip = toolTip,
Icon = ImageHelper.GetImageFromResource("../resources/script_16xLG.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
Tag = SqlCeScripting.Scope.SchemaDataBlobs
};
scriptDatabaseSchemaDataBlobMenuItem.CommandBindings.Add(scriptDatabaseCommandBinding);
scriptDatabaseRootMenuItem.Items.Add(scriptDatabaseSchemaDataBlobMenuItem);
Items.Add(scriptDatabaseRootMenuItem);
Items.Add(new Separator());
var exportServerCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.ExportServerDatabaseTo40);
var exportServerMenuItem = new MenuItem
{
Header = "Export SQL Server to SQL Server Compact 4.0...",
Icon = ImageHelper.GetImageFromResource("../resources/ExportReportData_10565.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters
};
exportServerMenuItem.CommandBindings.Add(exportServerCommandBinding);
exportServerMenuItem.IsEnabled = (isSqlCe40Installed);
Items.Add(exportServerMenuItem);
var exportServerToLiteCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.ExportServerDatabaseToSqlite);
var exportServerToLiteMenuItem = new MenuItem
{
Header = "Export SQL Server to SQLite... (beta)",
Icon = ImageHelper.GetImageFromResource("../resources/ExportReportData_10565.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters
};
exportServerToLiteMenuItem.CommandBindings.Add(exportServerToLiteCommandBinding);
Items.Add(exportServerToLiteMenuItem);
}
