private MenuItem BuildAddCe35DatabaseMenuItem(DatabaseMenuCommandParameters databaseMenuCommandParameters,
DatabasesMenuCommandsHandler dcmd, SqlCeToolboxPackage pkg, bool ver35IsInstalled)
{
// Add 3.5 database menu
var addCe35DatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.AddCe35Database);
var addCe35DatabaseMenuItem = new MenuItem
{
Header = "Add SQL Server Compact 3.5 Connection...",
Icon = ImageHelper.GetImageFromResource("../resources/AddDatabase_16x.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
};
if (pkg != null && pkg.VsSupportsDdex35())
{
addCe35DatabaseMenuItem.CommandBindings.Add(addCe35DatabaseCommandBinding);
addCe35DatabaseMenuItem.IsEnabled = ver35IsInstalled;
}
else
{
var addCe3511DatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.AddPrivateCe35Database);
addCe35DatabaseMenuItem.CommandBindings.Add(addCe3511DatabaseCommandBinding);
addCe35DatabaseMenuItem.IsEnabled = ver35IsInstalled;
}
return(addCe35DatabaseMenuItem);
}
private MenuItem BuildAddSqlServerDatabaseMenuItem(DatabaseMenuCommandParameters databaseMenuCommandParameters,
DatabasesMenuCommandsHandler dcmd)
{
var addSqlServerDatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.AddSqlServerDatabase);
var addSqlServerDatabaseMenuItem = new MenuItem
{
Header = "Add SQL Server Connection...",
Icon = ImageHelper.GetImageFromResource("../resources/AddDatabase_16x.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
};
addSqlServerDatabaseMenuItem.CommandBindings.Add(addSqlServerDatabaseCommandBinding);
return(addSqlServerDatabaseMenuItem);
}
private MenuItem BuildVersionDetectMenuItem(DatabaseMenuCommandParameters databaseMenuCommandParameters,
DatabasesMenuCommandsHandler dcmd)
{
var detectDatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.CheckCeVersion);
var versionDetectMenuItem = new MenuItem
{
Header = "Detect SQL Server Compact file version...",
Icon = ImageHelper.GetImageFromResource("../resources/Find_5650.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
};
versionDetectMenuItem.CommandBindings.Add(detectDatabaseCommandBinding);
return(versionDetectMenuItem);
}
private MenuItem BuildDesignDatabaseMenuItem(DatabaseMenuCommandParameters databaseMenuCommandParameters,
DatabasesMenuCommandsHandler dcmd)
{
var designDatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.DesignDatabase);
var designDatabaseMenuItem = new MenuItem
{
Header = "Database designer (alpha)...",
Icon = ImageHelper.GetImageFromResource("../resources/Schema_16xLG.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
};
designDatabaseMenuItem.CommandBindings.Add(designDatabaseCommandBinding);
return(designDatabaseMenuItem);
}
private static MenuItem BuildFixConnectionsMenuItem(DatabaseMenuCommandParameters databaseMenuCommandParameters,
DatabasesMenuCommandsHandler dcmd)
{
var fixConnectionsCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.FixConnections);
var fixConnectionsMenuItem = new MenuItem
{
Header = "Remove broken connections",
Icon = ImageHelper.GetImageFromResource("../resources/action_Cancel_16xLG.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
ToolTip = "Remove invalid connections",
CommandParameter = databaseMenuCommandParameters,
};
fixConnectionsMenuItem.CommandBindings.Add(fixConnectionsCommandBinding);
return(fixConnectionsMenuItem);
}
private MenuItem BuildAddFromSolutionMenuItem(DatabaseMenuCommandParameters databaseMenuCommandParameters,
DatabasesMenuCommandsHandler dcmd)
{
var addFromSolutionCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.ScanConnections);
var addFromSolutionMenuItem = new MenuItem
{
Header = "Add Connections from Solution",
Icon = ImageHelper.GetImageFromResource("../resources/AddConnection_477.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
ToolTip = "Scan current Solution for SQL Compact and SQLite files",
CommandParameter = databaseMenuCommandParameters,
};
addFromSolutionMenuItem.CommandBindings.Add(addFromSolutionCommandBinding);
return(addFromSolutionMenuItem);
}
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(BuildAddPrivateSqlServerDatabaseMenuItem(databaseMenuCommandParameters, dcmd));
}
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(BuildAddFromSolutionMenuItem(databaseMenuCommandParameters, dcmd));
}
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));
}
private MenuItem BuildLocalDatabaseCacheMenuItem(DatabaseMenuCommandParameters databaseMenuCommandParameters,
DatabasesMenuCommandsHandler dcmd, bool ver35IsInstalled)
{
var localDatabaseCacheCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.SyncFxGenerateLocalDatabaseCacheCode);
var localDatabaseCacheMenuItem = new MenuItem
{
Header = "Generate Local Database Cache code...",
Icon = ImageHelper.GetImageFromResource("../resources/Synchronize_16xLG.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
Tag = SqlCeScripting.Scope.SchemaDataBlobs
};
localDatabaseCacheMenuItem.CommandBindings.Add(localDatabaseCacheCommandBinding);
localDatabaseCacheMenuItem.IsEnabled = (ver35IsInstalled && DataConnectionHelper.IsSyncFx21Installed());
return(localDatabaseCacheMenuItem);
}
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);
}
private void AddSqliteDb_OnClick(object sender, RoutedEventArgs e)
{
var dbsCommandHandler = new DatabasesMenuCommandsHandler(_parentWindow);
dbsCommandHandler.AddSqLiteDatabase(null, null);
}
private void AddConnections_OnClick(object sender, RoutedEventArgs e)
{
var dbsCommandHandler = new DatabasesMenuCommandsHandler(_parentWindow);
dbsCommandHandler.ScanConnections(null, null);
}
public DatabasesContextMenu(DatabaseMenuCommandParameters databaseMenuCommandParameters, ExplorerToolWindow parent)
{
var dcmd = new DatabasesMenuCommandsHandler(parent);
// Add 4.0 database menu
bool ver40IsInstalled = DataConnectionHelper.IsV40Installed();
bool ver35IsInstalled = DataConnectionHelper.IsV35Installed();
var addCe4DatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.AddPrivateCe40Database);
var addCeDatabaseMenuItem = new MenuItem
{
Header = "Add SQL Server Compact 4.0 Connection...",
Icon = ImageHelper.GetImageFromResource("../resources/AddConnection_477.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
};
var pkg = parent.Package as SqlCeToolboxPackage;
if (pkg != null && pkg.VsSupportsDdex40())
{
var addCe40DatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.AddCe40Database);
addCeDatabaseMenuItem.CommandBindings.Add(addCe40DatabaseCommandBinding);
addCeDatabaseMenuItem.IsEnabled = ver40IsInstalled;
Items.Add(addCeDatabaseMenuItem);
}
else
{
addCeDatabaseMenuItem.CommandBindings.Add(addCe4DatabaseCommandBinding);
addCeDatabaseMenuItem.IsEnabled = ver40IsInstalled;
Items.Add(addCeDatabaseMenuItem);
}
// Add 3.5 database menu
var addCe35DatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.AddCe35Database);
var addCe35DatabaseMenuItem = new MenuItem
{
Header = "Add SQL Server Compact 3.5 Connection...",
Icon = ImageHelper.GetImageFromResource("../resources/AddConnection_477.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
};
if (pkg != null && pkg.VsSupportsDdex35())
{
addCe35DatabaseMenuItem.CommandBindings.Add(addCe35DatabaseCommandBinding);
addCe35DatabaseMenuItem.IsEnabled = ver35IsInstalled;
Items.Add(addCe35DatabaseMenuItem);
}
else
{
var addCe3511DatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.AddPrivateCe35Database);
addCe35DatabaseMenuItem.CommandBindings.Add(addCe3511DatabaseCommandBinding);
addCe35DatabaseMenuItem.IsEnabled = ver35IsInstalled;
Items.Add(addCe35DatabaseMenuItem);
}
// Add SQLite database menu
var addSqLiteDatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.AddSqLiteDatabase);
var addSqLiteDatabaseMenuItem = new MenuItem
{
Header = "Add SQLite Connection...",
Icon = ImageHelper.GetImageFromResource("../resources/AddConnection_477.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
};
addSqLiteDatabaseMenuItem.CommandBindings.Add(addSqLiteDatabaseCommandBinding);
Items.Add(addSqLiteDatabaseMenuItem);
// Add from solution
var addFromSolutionCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.ScanConnections);
var addFromSolutionMenuItem = new MenuItem
{
Header = "Add Connections from Solution",
Icon = ImageHelper.GetImageFromResource("../resources/AddConnection_477.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
ToolTip = "Scan current Solution for SQL Compact and SQLite files",
CommandParameter = databaseMenuCommandParameters,
};
addFromSolutionMenuItem.CommandBindings.Add(addFromSolutionCommandBinding);
addFromSolutionMenuItem.IsEnabled = ver40IsInstalled || ver35IsInstalled;
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(addFromSolutionMenuItem);
}
// Fix connections
var fixConnectionsCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.FixConnections);
var fixConnectionsMenuItem = new MenuItem
{
Header = "Remove broken connections",
Icon = ImageHelper.GetImageFromResource("../resources/action_Cancel_16xLG.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
ToolTip = "Remove invalid connections",
CommandParameter = databaseMenuCommandParameters,
};
fixConnectionsMenuItem.CommandBindings.Add(fixConnectionsCommandBinding);
Items.Add(fixConnectionsMenuItem);
Items.Add(new Separator());
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);
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(scriptDatabaseGraphMenuItem);
}
var designDatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.DesignDatabase);
var designDatabaseMenuItem = new MenuItem
{
Header = "Database designer (alpha)...",
Icon = ImageHelper.GetImageFromResource("../resources/Schema_16xLG.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
};
designDatabaseMenuItem.CommandBindings.Add(designDatabaseCommandBinding);
Items.Add(designDatabaseMenuItem);
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 = (ver40IsInstalled);
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);
Items.Add(new Separator());
//TODO Enable in next release
//var scriptEfDacPacCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
// dcmd.GenerateEfPocoFromDacPacInProject);
//var scriptEfPocoDacPacMenuItem = new MenuItem
//{
// Header = "Add Entity Data Model (Code First from Dacpac) to current Project... (alpha)",
// Icon = ImageHelper.GetImageFromResource("../resources/Schema_16xLG.png"),
// Command = DatabaseMenuCommands.DatabaseCommand,
// CommandParameter = databaseMenuCommandParameters,
//};
//scriptEfPocoDacPacMenuItem.CommandBindings.Add(scriptEfDacPacCommandBinding);
//if (SqlCeToolboxPackage.VsSupportsEf6()) Items.Add(scriptEfPocoDacPacMenuItem);
var localDatabaseCacheCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.SyncFxGenerateLocalDatabaseCacheCode);
var localDatabaseCacheMenuItem = new MenuItem
{
Header = "Generate Local Database Cache code...",
Icon = ImageHelper.GetImageFromResource("../resources/Synchronize_16xLG.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
Tag = SqlCeScripting.Scope.SchemaDataBlobs
};
localDatabaseCacheMenuItem.CommandBindings.Add(localDatabaseCacheCommandBinding);
localDatabaseCacheMenuItem.IsEnabled = (ver35IsInstalled && DataConnectionHelper.IsSyncFx21Installed());
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(localDatabaseCacheMenuItem);
}
if (SqlCeToolboxPackage.IsVsExtension)
{
Items.Add(new Separator());
}
var detectDatabaseCommandBinding = new CommandBinding(DatabaseMenuCommands.DatabaseCommand,
dcmd.CheckCeVersion);
var versionDetectMenuItem = new MenuItem
{
Header = "Detect SQL Server Compact file version...",
Icon = ImageHelper.GetImageFromResource("../resources/Find_5650.png"),
Command = DatabaseMenuCommands.DatabaseCommand,
CommandParameter = databaseMenuCommandParameters,
};
versionDetectMenuItem.CommandBindings.Add(detectDatabaseCommandBinding);
Items.Add(versionDetectMenuItem);
}
