public void PrimaryKey() { var scriptPath = ".\\tableOne.sql"; if(File.Exists(scriptPath)) File.Delete(scriptPath); File.Copy("..\\..\\..\\ProjectWithConstraints\\TableOne.sql", scriptPath); //var namer = new ConstraintNamer(scriptPath, // "..\\..\\..\\ProjectWithConstraints\\bin\\Release\\ProjectWithConstraints.dacpac"); var namer = new ConstraintNamer(File.ReadAllText(scriptPath)); var changedText = namer.Go(); Assert.LessOrEqual(-1, changedText.IndexOf("[Id] INT NOT NULL PRIMARY KEY"), changedText); Assert.Greater( changedText.IndexOf("CONSTRAINT [PK_TableOne] PRIMARY KEY ([Id])"), -1, changedText); }
private void NameConstraintsCalled(object sender, EventArgs e) { try { var dte = (DTE) GetService(typeof (DTE)); if (null == dte || dte.ActiveDocument == null) { return; } var doc = dte.ActiveDocument.Object("TextDocument") as TextDocument; if (null == doc) { return; } var ep = doc.StartPoint.CreateEditPoint(); ep.EndOfDocument(); var length = ep.AbsoluteCharOffset; ep.StartOfDocument(); var originalText = ep.GetText(length); var namer = new ConstraintNamer(originalText); var modifiedText = namer.Go(); if (originalText != modifiedText) { ep.Delete(length); ep.Insert(modifiedText); } } catch (Exception ex) { OutputPane.WriteMessage("Exception naming constraints, error: {0}", ex.Message); } }