public void SyncFxGenerateLocalDatabaseCacheCode(object sender, ExecutedRoutedEventArgs e)
{
// http://www.mztools.com/articles/2007/MZ2007011.aspx
var menuItem = sender as MenuItem;
if (menuItem == null)
{
return;
}
Scope scope = (Scope)menuItem.Tag;
var dte = package.GetServiceHelper(typeof(EnvDTE.DTE)) as EnvDTE.DTE;
var dteH = new Helpers.EnvDTEHelper();
var project = dteH.GetProject(dte);
if (project == null)
{
EnvDTEHelper.ShowError("Please select a project in Solution Explorer, where you want the SyncFx classes to be placed");
return;
}
if (!dteH.AllowedProjectKinds.Contains(new Guid(project.Kind)))
{
EnvDTEHelper.ShowError("The selected project type does not support Sync Framework (please let me know if I am wrong)");
return;
}
if (project.CodeModel.Language != CodeModelLanguageConstants.vsCMLanguageCSharp)
{
EnvDTEHelper.ShowError("Unsupported code language, only C# is currently supported");
return;
}
if (project.Properties.Item("TargetFrameworkMoniker") == null)
{
EnvDTEHelper.ShowError("The selected project type does not support Sync Framework - missing TargetFrameworkMoniker");
return;
}
if (!project.Properties.Item("TargetFrameworkMoniker").Value.ToString().Contains(".NETFramework"))
{
EnvDTEHelper.ShowError("The selected project type does not support .NET Desktop - wrong TargetFrameworkMoniker: " + project.Properties.Item("TargetFrameworkMoniker").Value.ToString());
return;
}
try
{
string serverConnectionString = DataConnectionHelper.PromptForConnectionString(package);
if (!string.IsNullOrEmpty(serverConnectionString))
{
string clientConnectionString = string.Empty;
//grab target SQL CE Database
var dialog = new ConnectionDialog();
dialog.DbType = DatabaseType.SQLCE35;
bool?result = dialog.ShowModal();
if (result.HasValue && result.Value == true && !string.IsNullOrWhiteSpace(dialog.ConnectionString))
{
clientConnectionString = dialog.ConnectionString;
}
else
{
return;
}
string model = string.Empty;
SyncFxDialog sfd = new SyncFxDialog();
int totalCount = 0;
var databaseInfo = new DatabaseMenuCommandParameters
{
DatabaseInfo = new DatabaseInfo
{
ConnectionString = serverConnectionString,
DatabaseType = DatabaseType.SQLServer
}
};
totalCount = SyncFxGetObjectsForSync(sfd, databaseInfo);
sfd.ModelName = model;
bool?res = sfd.ShowModal();
if (res.HasValue && res.Value == true && (sfd.Tables.Count > 0) && !string.IsNullOrWhiteSpace(sfd.ModelName))
{
model = sfd.ModelName;
var defaultNamespace = project.Properties.Item("DefaultNamespace").Value.ToString();
var columns = sfd.Columns.Where(c => sfd.Tables.Contains(c.TableName)).ToList();
var classes = new SyncFxHelper().GenerateCodeForScope(serverConnectionString, clientConnectionString, "SQL", model, columns, defaultNamespace);
var projectPath = project.Properties.Item("FullPath").Value.ToString();
foreach (var item in classes)
{
string fileName = Path.Combine(projectPath, item.Key + ".cs");
if (File.Exists(fileName))
{
File.Delete(fileName);
}
File.WriteAllText(fileName, item.Value);
project.ProjectItems.AddFromFile(fileName);
}
//Adding references - http://blogs.msdn.com/b/murat/archive/2008/07/30/envdte-adding-a-refernce-to-a-project.aspx
EnvDTEHelper.AddReference(project, "System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.AddReference(project, "Microsoft.Synchronization, Version=2.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.AddReference(project, "Microsoft.Synchronization.Data, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.AddReference(project, "Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.AddReference(project, "Microsoft.Synchronization.Data.SqlServerCe, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.ShowMessage("Scope: " + model + " code generated.");
Helpers.DataConnectionHelper.LogUsage("DatabasesSyncAddLocalDBCache");
}
}
}
catch (Exception ex)
{
Helpers.DataConnectionHelper.SendError(ex, DatabaseType.SQLServer);
}
}
public void SyncFxGenerateLocalDatabaseCacheCode(object sender, ExecutedRoutedEventArgs e)
{
// http://www.mztools.com/articles/2007/MZ2007011.aspx
var menuItem = sender as MenuItem;
if (menuItem == null) return;
Scope scope = (Scope)menuItem.Tag;
var dte = package.GetServiceHelper(typeof(EnvDTE.DTE)) as EnvDTE.DTE;
var dteH = new Helpers.EnvDTEHelper();
var project = dteH.GetProject(dte);
if (project == null)
{
EnvDTEHelper.ShowError("Please select a project in Solution Explorer, where you want the SyncFx classes to be placed");
return;
}
if (!dteH.AllowedProjectKinds.Contains(new Guid(project.Kind)))
{
EnvDTEHelper.ShowError("The selected project type does not support Sync Framework (please let me know if I am wrong)");
return;
}
if (project.CodeModel.Language != CodeModelLanguageConstants.vsCMLanguageCSharp)
{
EnvDTEHelper.ShowError("Unsupported code language, only C# is currently supported");
return;
}
if (project.Properties.Item("TargetFrameworkMoniker") == null)
{
EnvDTEHelper.ShowError("The selected project type does not support Sync Framework - missing TargetFrameworkMoniker");
return;
}
if (!project.Properties.Item("TargetFrameworkMoniker").Value.ToString().Contains(".NETFramework"))
{
EnvDTEHelper.ShowError("The selected project type does not support .NET Desktop - wrong TargetFrameworkMoniker: " + project.Properties.Item("TargetFrameworkMoniker").Value.ToString());
return;
}
try
{
string serverConnectionString = DataConnectionHelper.PromptForConnectionString(package);
if (!string.IsNullOrEmpty(serverConnectionString))
{
string clientConnectionString = string.Empty;
//grab target SQL CE Database
var dialog = new ConnectionDialog();
dialog.DbType = DatabaseType.SQLCE35;
bool? result = dialog.ShowModal();
if (result.HasValue && result.Value == true && !string.IsNullOrWhiteSpace(dialog.ConnectionString))
{
clientConnectionString = dialog.ConnectionString;
}
else
{
return;
}
string model = string.Empty;
SyncFxDialog sfd = new SyncFxDialog();
int totalCount = 0;
var databaseInfo = new DatabaseMenuCommandParameters
{
DatabaseInfo = new DatabaseInfo
{
ConnectionString = serverConnectionString,
DatabaseType = DatabaseType.SQLServer
}
};
totalCount = SyncFxGetObjectsForSync(sfd, databaseInfo);
sfd.ModelName = model;
bool? res = sfd.ShowModal();
if (res.HasValue && res.Value == true && (sfd.Tables.Count > 0) && !string.IsNullOrWhiteSpace(sfd.ModelName))
{
model = sfd.ModelName;
var defaultNamespace = project.Properties.Item("DefaultNamespace").Value.ToString();
var columns = sfd.Columns.Where(c => sfd.Tables.Contains(c.TableName)).ToList();
var classes = new SyncFxHelper().GenerateCodeForScope(serverConnectionString, clientConnectionString, "SQL", model, columns, defaultNamespace);
var projectPath = project.Properties.Item("FullPath").Value.ToString();
foreach (var item in classes)
{
string fileName = Path.Combine(projectPath, item.Key + ".cs");
if (File.Exists(fileName))
{
File.Delete(fileName);
}
File.WriteAllText(fileName, item.Value);
project.ProjectItems.AddFromFile(fileName);
}
//Adding references - http://blogs.msdn.com/b/murat/archive/2008/07/30/envdte-adding-a-refernce-to-a-project.aspx
EnvDTEHelper.AddReference(project, "System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.AddReference(project, "Microsoft.Synchronization, Version=2.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.AddReference(project, "Microsoft.Synchronization.Data, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.AddReference(project, "Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.AddReference(project, "Microsoft.Synchronization.Data.SqlServerCe, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.ShowMessage("Scope: " + model + " code generated.");
Helpers.DataConnectionHelper.LogUsage("DatabasesSyncAddLocalDBCache");
}
}
}
catch (Exception ex)
{
Helpers.DataConnectionHelper.SendError(ex, DatabaseType.SQLServer);
}
}
public void GenerateDataContextInProject(object sender, ExecutedRoutedEventArgs e)
{
var databaseInfo = ValidateMenuInfo(sender);
if (databaseInfo == null) return;
var isDesktop = (bool)((MenuItem)sender).Tag;
if (package == null) return;
var dte = package.GetServiceHelper(typeof(EnvDTE.DTE)) as EnvDTE.DTE;
if (dte == null) return;
if (dte.Mode == vsIDEMode.vsIDEModeDebug)
{
EnvDTEHelper.ShowError("Cannot generate code while debugging");
return;
}
var helper = DataConnectionHelper.CreateEngineHelper(databaseInfo.DatabaseInfo.DatabaseType);
if (!helper.IsV35DbProviderInstalled())
{
EnvDTEHelper.ShowError("This feature requires the SQL Server Compact 3.5 SP2 DbProvider to be properly installed");
return;
}
var dteH = new Helpers.EnvDTEHelper();
var project = dteH.GetProject(dte);
if (project == null)
{
EnvDTEHelper.ShowError("Please select a project in Solution Explorer, where you want the DataContext to be placed");
return;
}
if (!isDesktop && !dteH.AllowedWPProjectKinds.Contains(new Guid(project.Kind)))
{
EnvDTEHelper.ShowError("The selected project type does not support Windows Phone (please let me know if I am wrong)");
return;
}
if (isDesktop && !dteH.AllowedProjectKinds.Contains(new Guid(project.Kind)))
{
EnvDTEHelper.ShowError("The selected project type does not support LINQ to SQL (please let me know if I am wrong)");
return;
}
if (project.Properties.Item("TargetFrameworkMoniker") == null)
{
EnvDTEHelper.ShowError("The selected project type does not support Windows Phone - missing TargetFrameworkMoniker");
return;
}
if (!isDesktop)
{
if (project.Properties.Item("TargetFrameworkMoniker").Value.ToString() == "Silverlight,Version=v4.0,Profile=WindowsPhone71"
|| project.Properties.Item("TargetFrameworkMoniker").Value.ToString() == "WindowsPhone,Version=v8.0"
|| project.Properties.Item("TargetFrameworkMoniker").Value.ToString() == "WindowsPhone,Version=v8.1"
)
{ }
else
{
EnvDTEHelper.ShowError("The selected project type does not support Windows Phone 7.1/8.0 - wrong TargetFrameworkMoniker: " + project.Properties.Item("TargetFrameworkMoniker").Value.ToString());
return;
}
}
if (isDesktop && !project.Properties.Item("TargetFrameworkMoniker").Value.ToString().Contains(".NETFramework"))
{
EnvDTEHelper.ShowError("The selected project type does not support .NET Desktop - wrong TargetFrameworkMoniker: " + project.Properties.Item("TargetFrameworkMoniker").Value.ToString());
return;
}
if (!isDesktop && databaseInfo.DatabaseInfo.DatabaseType != DatabaseType.SQLCE35)
{
EnvDTEHelper.ShowError("Sorry, only version 3.5 databases are supported for now");
return;
}
string sqlMetalPath = string.Empty;
var sqlMetalPaths = ProbeSqlMetalRegPaths();
if (sqlMetalPaths.Count == 0)
{
EnvDTEHelper.ShowError("Could not find SQLMetal location in registry");
return;
}
foreach (var path in sqlMetalPaths)
{
if (File.Exists(path))
{
sqlMetalPath = path;
break;
}
}
if (string.IsNullOrEmpty(sqlMetalPath))
{
EnvDTEHelper.ShowError("Could not find SQLMetal file location");
return;
}
var sdfFileName = string.Empty;
try
{
using (IRepository repository = Helpers.DataConnectionHelper.CreateRepository(databaseInfo.DatabaseInfo))
{
var tables = repository.GetAllTableNames();
var pks = repository.GetAllPrimaryKeys();
string checkedTables = string.Empty;
foreach (string tableName in tables)
{
var pk = pks.Where(k => k.TableName == tableName).FirstOrDefault();
if (pk.TableName == null)
{
checkedTables += tableName + Environment.NewLine;
}
}
if (!string.IsNullOrEmpty(checkedTables))
{
string message = string.Format("The tables below do not have Primary Keys defined,{0}and will not be generated properly:{1}{2}", Environment.NewLine, Environment.NewLine, checkedTables);
EnvDTEHelper.ShowError(message);
}
List<KeyValuePair<string, string>> dbInfo = repository.GetDatabaseInfo();
foreach (var kvp in dbInfo)
{
if (kvp.Key == "Database")
{
sdfFileName = kvp.Value;
break;
}
}
sdfFileName = Path.GetFileName(sdfFileName);
}
string model = Path.GetFileNameWithoutExtension(databaseInfo.DatabaseInfo.Caption).Replace(" ", string.Empty).Replace("#", string.Empty).Replace(".", string.Empty).Replace("-", string.Empty);
model = model + "Context";
DataContextDialog dcDialog = new DataContextDialog();
dcDialog.ModelName = model;
dcDialog.IsDesktop = isDesktop;
dcDialog.ProjectName = project.Name;
dcDialog.NameSpace = project.Properties.Item("DefaultNamespace").Value.ToString();
if (EnvDTEHelper.VBProject == new Guid(project.Kind))
{
dcDialog.CodeLanguage = "VB";
}
else
{
dcDialog.CodeLanguage = "C#";
}
bool? result = dcDialog.ShowModal();
if (result.HasValue && result.Value == true && (!string.IsNullOrWhiteSpace(dcDialog.ModelName)))
{
if (dcDialog.AddRowversionColumns)
{
AddRowVersionColumns(databaseInfo);
}
string sdfPath = databaseInfo.DatabaseInfo.ConnectionString;
//If version 4.0, create a 3.5 schema sdf, and use that as connection string
if (isDesktop && databaseInfo.DatabaseInfo.DatabaseType == DatabaseType.SQLCE40)
{
var tempFile = Path.GetTempFileName();
using (IRepository repository = Helpers.DataConnectionHelper.CreateRepository(databaseInfo.DatabaseInfo))
{
var generator = Helpers.DataConnectionHelper.CreateGenerator(repository, tempFile, databaseInfo.DatabaseInfo.DatabaseType);
generator.ScriptDatabaseToFile(Scope.Schema);
}
sdfPath = Path.Combine(Path.GetTempPath(), sdfFileName);
using (Stream stream = new MemoryStream(Resources.SqlCe35AddinStore))
{
// Create a FileStream object to write a stream to a file
using (FileStream fileStream = File.Create(sdfPath, (int)stream.Length))
{
// Fill the bytes[] array with the stream data
byte[] bytesInStream = new byte[stream.Length];
stream.Read(bytesInStream, 0, (int)bytesInStream.Length);
// Use FileStream object to write to the specified file
fileStream.Write(bytesInStream, 0, bytesInStream.Length);
}
}
DatabaseInfo info = new DatabaseInfo();
info.ConnectionString = "Data Source=" + sdfPath;
info.DatabaseType = DatabaseType.SQLCE35;
using (IRepository repository = Helpers.DataConnectionHelper.CreateRepository(info))
{
string script = File.ReadAllText(tempFile);
repository.ExecuteSql(script);
}
sdfPath = info.ConnectionString;
}
int versionNumber = GetVersionTableNumber(databaseInfo.DatabaseInfo, isDesktop);
model = dcDialog.ModelName;
string dcPath = Path.Combine(Path.GetTempPath(), model + ".cs");
if (dcDialog.CodeLanguage == "VB")
{
dcPath = Path.Combine(Path.GetTempPath(), model + ".vb");
}
string parameters = " /provider:SQLCompact /code:\"" + dcPath + "\"";
parameters += " /conn:\"" + sdfPath + "\"";
parameters += " /context:" + model;
if (dcDialog.Pluralize)
{
parameters += " /pluralize";
}
if (!string.IsNullOrWhiteSpace(dcDialog.NameSpace))
{
parameters += " /namespace:" + dcDialog.NameSpace;
}
var dcH = new ErikEJ.SqlCeScripting.DataContextHelper();
string sqlmetalResult = dcH.RunSqlMetal(sqlMetalPath, parameters);
if (!File.Exists(dcPath))
{
EnvDTEHelper.ShowError("Error during SQL Metal run: " + sqlmetalResult);
return;
}
if (!isDesktop)
{
using (IRepository repository = Helpers.DataConnectionHelper.CreateRepository(databaseInfo.DatabaseInfo))
{
if (dcDialog.CodeLanguage == "VB")
{
DataContextHelper.FixDataContextVB(dcPath, model, dcDialog.NameSpace, sdfFileName, repository);
}
else
{
DataContextHelper.FixDataContextCS(dcPath, model, dcDialog.NameSpace, sdfFileName, repository);
}
}
}
if (dcDialog.MultipleFiles)
{
Dictionary<string, string> classes = DataContextHelper.SplitIntoMultipleFiles(dcPath, dcDialog.NameSpace, model);
string projectPath = project.Properties.Item("FullPath").Value.ToString();
foreach (var item in classes)
{
string fileName = Path.Combine(projectPath, item.Key + ".cs");
if (File.Exists(fileName))
{
File.Delete(fileName);
}
File.WriteAllText(fileName, item.Value);
ProjectItem classItem = dteH.GetProjectDataContextClass(project, fileName);
if (classItem != null)
{
classItem.Delete();
}
project.ProjectItems.AddFromFile(fileName);
}
}
else
{
string extension = ".cs";
if (dcDialog.CodeLanguage == "VB")
extension = ".vb";
ProjectItem dcItem = dteH.GetProjectDC(project, model, extension);
if (dcItem == null)
{
project.ProjectItems.AddFromFileCopy(dcPath);
}
else
{
if (EnvDTEHelper.ShowMessageBox("The Data Context class already exists in the project, do you wish to replace it?", OLEMSGBUTTON.OLEMSGBUTTON_YESNO, OLEMSGDEFBUTTON.OLEMSGDEFBUTTON_SECOND, OLEMSGICON.OLEMSGICON_QUERY) == System.Windows.Forms.DialogResult.Yes)
{
dcItem.Delete();
project.ProjectItems.AddFromFileCopy(dcPath);
}
}
}
EnvDTEHelper.AddReference(project, "System.Data.Linq");
if (dcDialog.AddConnectionStringBuilder)
{
string projectPath = project.Properties.Item("FullPath").Value.ToString();
string fileName = "LocalDatabaseConnectionStringBuilder.cs";
string filePath = Path.Combine(projectPath, fileName);
if (File.Exists(filePath))
{
File.Delete(filePath);
}
using (Stream stream = new MemoryStream(Resources.LocalDatabaseConnectionStringBuilder))
{
// Create a FileStream object to write a stream to a file
using (FileStream fileStream = File.Create(filePath, (int)stream.Length))
{
// Fill the bytes[] array with the stream data
byte[] bytesInStream = new byte[stream.Length];
stream.Read(bytesInStream, 0, (int)bytesInStream.Length);
// Use FileStream object to write to the specified file
fileStream.Write(bytesInStream, 0, bytesInStream.Length);
}
}
project.ProjectItems.AddFromFile(filePath);
}
// Creates __Version table and adds one row if desired
if (dcDialog.AddVersionTable)
{
using (IRepository repository = Helpers.DataConnectionHelper.CreateRepository(databaseInfo.DatabaseInfo))
{
var list = repository.GetAllTableNames();
if (!list.Contains("__VERSION"))
{
repository.ExecuteSql(string.Format(@"
CREATE TABLE [__VERSION] (
[SchemaVersion] int NOT NULL
, [DateUpdated] datetime NOT NULL DEFAULT (GETDATE())
);
GO
CREATE INDEX [IX_SchemaVersion] ON [__VERSION] ([SchemaVersion] DESC);
GO
INSERT INTO [__VERSION] ([SchemaVersion]) VALUES ({0});
GO", versionNumber));
}
}
}
Helpers.DataConnectionHelper.LogUsage("DatabaseCreateDC");
}
}
catch (Exception ex)
{
Helpers.DataConnectionHelper.SendError(ex, databaseInfo.DatabaseInfo.DatabaseType, false);
}
}
public void GenerateEdmxInProject(object sender, ExecutedRoutedEventArgs e)
{
var databaseInfo = ValidateMenuInfo(sender);
if (databaseInfo == null) return;
bool isEF6 = package.VSSupportsEF6();
if (databaseInfo.DatabaseInfo.DatabaseType == DatabaseType.SQLite && !isEF6)
{
EnvDTEHelper.ShowError("Only Entity Framework 6.x is supported with SQLite");
return;
}
try
{
if (package == null) return;
var dte = package.GetServiceHelper(typeof(EnvDTE.DTE)) as EnvDTE.DTE;
if (dte.Mode == vsIDEMode.vsIDEModeDebug)
{
EnvDTEHelper.ShowError("Cannot generate code while debugging");
return;
}
var dteH = new Helpers.EnvDTEHelper();
var project = dteH.GetProject(dte);
if (project == null)
{
EnvDTEHelper.ShowError("Please select a project in Solution Explorer, where you want the EDM to be placed");
return;
}
if (dte.Solution.SolutionBuild.BuildState == vsBuildState.vsBuildStateNotStarted)
{
EnvDTEHelper.ShowError("Please build the project before proceeding");
return;
}
if (isEF6)
{
if (databaseInfo.DatabaseInfo.DatabaseType == DatabaseType.SQLCE40 && !dteH.ContainsEFSqlCeReference(project))
{
EnvDTEHelper.ShowError("Please add the EntityFramework.SqlServerCompact NuGet package to the project");
return;
}
if (databaseInfo.DatabaseInfo.DatabaseType == DatabaseType.SQLCE35 && !dteH.ContainsEFSqlCeLegacyReference(project))
{
EnvDTEHelper.ShowError("Please add the EntityFramework.SqlServerCompact.Legacy NuGet package to the project");
return;
}
if (databaseInfo.DatabaseInfo.DatabaseType == DatabaseType.SQLite && !dteH.ContainsEFSQLiteReference(project))
{
EnvDTEHelper.ShowError("Please add the System.Data.SQLite.EF6 NuGet package to the project");
return;
}
if (!File.Exists(Path.Combine(dteH.GetVisualStudioInstallationDir(SqlCeToolboxPackage.VisualStudioVersion), "ItemTemplates\\CSharp\\Data\\1033\\DbCtxCSEF6\\CSharpDbContext.Context.tt")))
{
EnvDTEHelper.ShowError("Please install the Entity Framework 6 Tools in order to proceed");
return;
}
}
if (!dteH.AllowedProjectKinds.Contains(new Guid(project.Kind)))
{
EnvDTEHelper.ShowError("The selected project type does not support Entity Framework (please let me know if I am wrong)");
return;
}
if (project.Properties.Item("TargetFrameworkMoniker") == null)
{
EnvDTEHelper.ShowError("The selected project type does not have a TargetFrameworkMoniker");
return;
}
if (!project.Properties.Item("TargetFrameworkMoniker").Value.ToString().Contains(".NETFramework"))
{
EnvDTEHelper.ShowError("The selected project type does not support .NET Desktop - wrong TargetFrameworkMoniker: " + project.Properties.Item("TargetFrameworkMoniker").Value.ToString());
return;
}
string provider = Resources.SqlCompact40InvariantName;
if (databaseInfo.DatabaseInfo.DatabaseType == DatabaseType.SQLCE35)
provider = Resources.SqlCompact35InvariantName;
if (databaseInfo.DatabaseInfo.DatabaseType == DatabaseType.SQLite)
provider = Resources.SQLiteEF6InvariantName;
string model = Remove(Path.GetFileNameWithoutExtension(databaseInfo.DatabaseInfo.Caption), new List<char> { '#', '.', '+', '-', ' ' });
EdmxDialog edmxDialog = new EdmxDialog();
edmxDialog.ModelName = model;
edmxDialog.ProjectName = project.Name;
if (isEF6)
edmxDialog.HideAddPrivateConfig();
using (IRepository repository = Helpers.DataConnectionHelper.CreateRepository(databaseInfo.DatabaseInfo))
{
var tables = repository.GetAllTableNames();
var pks = repository.GetAllPrimaryKeys();
var checkedTables = new List<string>();
foreach (string tableName in tables)
{
var pk = pks.Where(k => k.TableName == tableName).FirstOrDefault();
if (pk.TableName != null)
{
checkedTables.Add(tableName);
}
}
edmxDialog.Tables = checkedTables;
}
bool? result = edmxDialog.ShowModal();
if (result.HasValue && result.Value == true && (!string.IsNullOrWhiteSpace(edmxDialog.ModelName)))
{
model = edmxDialog.ModelName;
string edmxPath = Path.Combine(Path.GetTempPath(), model + ".edmx");
Version ver = new Version(2, 0, 0, 0);
if (isEF6)
{
ver = new Version(3, 0, 0, 0);
}
EdmGen2.EdmGen2.ModelGen(databaseInfo.DatabaseInfo.ConnectionString, provider, model, Path.GetTempPath(), edmxDialog.ForeignKeys, edmxDialog.Pluralize, edmxDialog.Tables, ver);
if (EdmGen2.EdmGen2.Errors.Count > 0)
{
var sb = new System.Text.StringBuilder();
foreach (var item in EdmGen2.EdmGen2.Errors)
{
sb.AppendLine(item);
}
EnvDTEHelper.ShowError("Errors encountered during edmx generation" + System.Environment.NewLine + sb.ToString());
}
if (!File.Exists(edmxPath))
{
return;
}
bool proceed = true;
ProjectItem edmxItem = dteH.GetProjectEdmx(project, model);
if (edmxItem == null)
{
project.ProjectItems.AddFromFileCopy(edmxPath);
}
else
{
if (EnvDTEHelper.ShowMessageBox("The Entity Data Model already exists in the project, do you wish to replace it?", OLEMSGBUTTON.OLEMSGBUTTON_YESNO, OLEMSGDEFBUTTON.OLEMSGDEFBUTTON_SECOND, OLEMSGICON.OLEMSGICON_QUERY) == System.Windows.Forms.DialogResult.Yes)
{
proceed = true;
edmxItem.Delete();
project.ProjectItems.AddFromFileCopy(edmxPath);
}
else
{
proceed = false;
}
}
if (isEF6)
{
ProjectItem addedItem = dteH.GetProjectEdmx(project, model);
if (addedItem != null)
{
if (project.CodeModel.Language == CodeModelLanguageConstants.vsCMLanguageCSharp)
{
var template = File.ReadAllText(Path.Combine(dteH.GetVisualStudioInstallationDir(SqlCeToolboxPackage.VisualStudioVersion), "ItemTemplates\\CSharp\\Data\\1033\\DbCtxCSEF6\\CSharpDbContext.Context.tt"));
template = template.Replace("$edmxInputFile$", model + ".edmx");
File.WriteAllText(Path.Combine(Path.GetTempPath(), model + ".Context.tt"), template);
addedItem.ProjectItems.AddFromFileCopy(Path.Combine(Path.GetTempPath(), model + ".Context.tt"));
template = File.ReadAllText(Path.Combine(dteH.GetVisualStudioInstallationDir(SqlCeToolboxPackage.VisualStudioVersion), "ItemTemplates\\CSharp\\Data\\1033\\DbCtxCSEF6\\CSharpDbContext.Types.tt"));
template = template.Replace("$edmxInputFile$", model + ".edmx");
File.WriteAllText(Path.Combine(Path.GetTempPath(), model + ".tt"), template);
addedItem.ProjectItems.AddFromFileCopy(Path.Combine(Path.GetTempPath(), model + ".tt"));
}
if (project.CodeModel.Language == CodeModelLanguageConstants.vsCMLanguageVB)
{
var template = File.ReadAllText(Path.Combine(dteH.GetVisualStudioInstallationDir(SqlCeToolboxPackage.VisualStudioVersion), "ItemTemplates\\VisualBasic\\Data\\1033\\DbCtxVBEF6\\VBDbContext.Context.tt"));
template = template.Replace("$edmxInputFile$", model + ".edmx");
File.WriteAllText(Path.Combine(Path.GetTempPath(), model + ".Context.tt"), template);
addedItem.ProjectItems.AddFromFileCopy(Path.Combine(Path.GetTempPath(), model + ".Context.tt"));
template = File.ReadAllText(Path.Combine(dteH.GetVisualStudioInstallationDir(SqlCeToolboxPackage.VisualStudioVersion), "ItemTemplates\\VisualBasic\\Data\\1033\\DbCtxVBEF6\\VBDbContext.Types.tt"));
template = template.Replace("$edmxInputFile$", model + ".edmx");
File.WriteAllText(Path.Combine(Path.GetTempPath(), model + ".tt"), template);
addedItem.ProjectItems.AddFromFileCopy(Path.Combine(Path.GetTempPath(), model + ".tt"));
}
string diagramPath = Path.Combine(Path.GetTempPath(), model + "edmx.diagram");
File.WriteAllText(diagramPath, EdmGen2.EdmGen2.GetEDMXDiagram());
addedItem.ProjectItems.AddFromFileCopy(diagramPath);
}
project.Save();
}
if (edmxDialog.SaveConfig && proceed)
{
string prefix = "App";
string configPath = Path.Combine(Path.GetTempPath(), prefix + ".config");
ProjectItem item = dteH.GetProjectConfig(project);
if (item == null)
{
//Add app.config file to project
var cfgSb = new System.Text.StringBuilder();
cfgSb.AppendLine("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
cfgSb.AppendLine("<configuration>");
cfgSb.AppendLine("</configuration>");
File.WriteAllText(configPath, cfgSb.ToString());
item = project.ProjectItems.AddFromFileCopy(configPath);
}
if (item != null)
{
Helpers.AppConfigHelper.BuildConfig(databaseInfo.DatabaseInfo.ConnectionString, project.FullName, provider, model, prefix, item.Name);
if (edmxDialog.AddPrivateConfig)
{
Helpers.AppConfigHelper.WriteSettings(item.FileNames[0], databaseInfo.DatabaseInfo.DatabaseType);
}
}
}
Helpers.DataConnectionHelper.LogUsage("DatabaseCreateEDMX");
}
}
// EDM end
catch (Exception ex)
{
Helpers.DataConnectionHelper.SendError(ex, databaseInfo.DatabaseInfo.DatabaseType, false);
}
}
public void SyncFxGenerateSyncCodeInProject(object sender, ExecutedRoutedEventArgs e)
{
var databaseInfo = ValidateMenuInfo(sender);
if (databaseInfo == null) return;
if (package == null) return;
var dte = package.GetServiceHelper(typeof(EnvDTE.DTE)) as EnvDTE.DTE;
var dteH = new Helpers.EnvDTEHelper();
var project = dteH.GetProject(dte);
if (project == null)
{
EnvDTEHelper.ShowError("Please select a project in Solution Explorer, where you want the SyncFx classes to be placed");
return;
}
if (!dteH.AllowedProjectKinds.Contains(new Guid(project.Kind)))
{
EnvDTEHelper.ShowError("The selected project type does not support Sync Framework (please let me know if I am wrong)");
return;
}
if (project.CodeModel.Language != CodeModelLanguageConstants.vsCMLanguageCSharp)
{
EnvDTEHelper.ShowError("Unsupported code language, only C# is currently supported");
return;
}
if (project.Properties.Item("TargetFrameworkMoniker") == null)
{
EnvDTEHelper.ShowError("The selected project type does not support Sync Framework - missing TargetFrameworkMoniker");
return;
}
if (!project.Properties.Item("TargetFrameworkMoniker").Value.ToString().Contains(".NETFramework"))
{
EnvDTEHelper.ShowError("The selected project type does not support .NET Desktop - wrong TargetFrameworkMoniker: " + project.Properties.Item("TargetFrameworkMoniker").Value.ToString());
return;
}
if (databaseInfo.DatabaseInfo.DatabaseType != DatabaseType.SQLCE35)
{
EnvDTEHelper.ShowError("Sorry, only version 3.5 databases are supported for now");
return;
}
try
{
string model = Path.GetFileNameWithoutExtension(databaseInfo.DatabaseInfo.Caption).Replace(" ", string.Empty).Replace("#", string.Empty).Replace(".", string.Empty).Replace("-", string.Empty);
SyncFxDialog sfd = new SyncFxDialog();
int totalCount = 0;
totalCount = SyncFxGetObjectsForSync(sfd, databaseInfo);
sfd.ModelName = model;
bool? res = sfd.ShowModal();
if (res.HasValue && res.Value == true && (sfd.Tables.Count > 0))
{
model = sfd.ModelName;
var defaultNamespace = project.Properties.Item("DefaultNamespace").Value.ToString();
var classes = new Dictionary<string, string>();
classes = new SyncFxHelper().GenerateCodeForScope(string.Empty, databaseInfo.DatabaseInfo.ConnectionString, "SQLCE", model, sfd.Columns.Where(c => sfd.Tables.Contains(c.TableName)).ToList(), defaultNamespace);
var projectPath = project.Properties.Item("FullPath").Value.ToString();
foreach (var item in classes)
{
string fileName = Path.Combine(projectPath, item.Key + ".cs");
if (File.Exists(fileName))
{
File.Delete(fileName);
}
File.WriteAllText(fileName, item.Value);
project.ProjectItems.AddFromFile(fileName);
}
//Adding references - http://blogs.msdn.com/b/murat/archive/2008/07/30/envdte-adding-a-refernce-to-a-project.aspx
EnvDTEHelper.AddReference(project, "System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.AddReference(project, "Microsoft.Synchronization, Version=2.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.AddReference(project, "Microsoft.Synchronization.Data, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.AddReference(project, "Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.AddReference(project, "Microsoft.Synchronization.Data.SqlServerCe, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91");
EnvDTEHelper.ShowMessage("Scope: " + model + " code generated.");
Helpers.DataConnectionHelper.LogUsage("DatabaseSyncCodegen");
}
}
catch (Exception ex)
{
Helpers.DataConnectionHelper.SendError(ex, databaseInfo.DatabaseInfo.DatabaseType, false);
}
}
public void GenerateModelCodeInProject(object sender, ExecutedRoutedEventArgs e)
{
var databaseInfo = ValidateMenuInfo(sender);
if (databaseInfo == null) return;
if (package == null) return;
var dte = package.GetServiceHelper(typeof(EnvDTE.DTE)) as EnvDTE.DTE;
var dteH = new Helpers.EnvDTEHelper();
var project = dteH.GetProject(dte);
if (project == null)
{
EnvDTEHelper.ShowError("Please select a project in Solution Explorer, where you want the DataAccess.cs to be placed");
return;
}
if (!dteH.AllowedProjectKinds.Contains(new Guid(project.Kind)))
{
EnvDTEHelper.ShowError(string.Format("The selected project type {0} does not support sqlite-net (please let me know if I am wrong)", project.Kind));
return;
}
if (project.CodeModel != null && project.CodeModel.Language != CodeModelLanguageConstants.vsCMLanguageCSharp)
{
EnvDTEHelper.ShowError("Unsupported code language, only C# is currently supported");
return;
}
if (databaseInfo.DatabaseInfo.DatabaseType != DatabaseType.SQLite)
{
EnvDTEHelper.ShowError("Sorry, only SQLite databases are supported");
return;
}
try
{
var defaultNamespace = "Model";
if (project.Properties.Item("DefaultNamespace") != null)
{
defaultNamespace = project.Properties.Item("DefaultNamespace").Value.ToString();
}
var projectPath = project.Properties.Item("FullPath").Value.ToString();
using (IRepository repository = Helpers.DataConnectionHelper.CreateRepository(databaseInfo.DatabaseInfo))
{
var generator = Helpers.DataConnectionHelper.CreateGenerator(repository, databaseInfo.DatabaseInfo.DatabaseType);
generator.GenerateSqliteNetModel(defaultNamespace);
string fileName = Path.Combine(projectPath, "DataAccess.cs");
if (File.Exists(fileName))
{
File.Delete(fileName);
}
string warning = @"//This code was generated by a tool.
//Changes to this file will be lost if the code is regenerated."
+ Environment.NewLine +
"// See the blog post here for help on using the generated code: http://erikej.blogspot.dk/2014/10/database-first-with-sqlite-in-universal.html"
+ Environment.NewLine;
File.WriteAllText(fileName, warning + generator.GeneratedScript);
project.ProjectItems.AddFromFile(fileName);
EnvDTEHelper.ShowMessage("DataAccess.cs generated.");
Helpers.DataConnectionHelper.LogUsage("DatabaseSqliteNetCodegen");
}
}
catch (Exception ex)
{
Helpers.DataConnectionHelper.SendError(ex, databaseInfo.DatabaseInfo.DatabaseType);
}
}
