public void Sets_KeyColumns_To_Empty_List_When_No_Primary_Key() { var path = Path.Combine(Environment.CurrentDirectory, "dacServicesTest.dac"); if (File.Exists(path)) { File.Delete(path); } using (TSqlModel model = new TSqlModel(SqlServerVersion.Sql110, new TSqlModelOptions { })) { model.AddObjects("CREATE TABLE t1 (c1 NVARCHAR(30) NOT NULL, id int)", new TSqlObjectOptions()); DacPackageExtensions.BuildPackage(path, model, new PackageMetadata() { Description = "Test Package", Name = "ssss", Version = "1" }); } var dac = new DacServices.DacParser(path); Assert.AreEqual(1, dac.GetTableDefinitions().Count); var table = dac.GetTableDefinitions().FirstOrDefault(); Assert.AreEqual(0, table.KeyColumns.Count); }
public void Gets_Column_Definition() { var path = Path.Combine(Environment.CurrentDirectory, "dacServicesTest.dac"); if (File.Exists(path)) { File.Delete(path); } using (TSqlModel model = new TSqlModel(SqlServerVersion.Sql110, new TSqlModelOptions { })) { model.AddObjects("CREATE TABLE t1 (c1 NVARCHAR(30) NOT NULL, id int primary key clustered)", new TSqlObjectOptions()); DacPackageExtensions.BuildPackage(path, model, new PackageMetadata() { Description = "Test Package", Name = "ssss", Version = "1" }); } var dac = new DacServices.DacParser(path); Assert.AreEqual(1, dac.GetTableDefinitions().Count); var table = dac.GetTableDefinitions().FirstOrDefault(); Assert.AreEqual("c1", table.Columns.FirstOrDefault().Name.Value); Assert.AreEqual(LiteralType.String, table.Columns.FirstOrDefault().LiteralType); }
public void Sets_KeyColumns_To_Empty_List_When_No_Primary_Key() { var path = Path.Combine(Environment.CurrentDirectory, "dacServicesTest.dac"); if (File.Exists(path)) File.Delete(path); using (TSqlModel model = new TSqlModel(SqlServerVersion.Sql110, new TSqlModelOptions { })) { model.AddObjects("CREATE TABLE t1 (c1 NVARCHAR(30) NOT NULL, id int)", new TSqlObjectOptions()); DacPackageExtensions.BuildPackage(path, model, new PackageMetadata() { Description = "Test Package", Name = "ssss", Version = "1" }); } var dac = new DacServices.DacParser(path); Assert.AreEqual(1, dac.GetTableDefinitions().Count); var table = dac.GetTableDefinitions().FirstOrDefault(); Assert.AreEqual(0, table.KeyColumns.Count); }
public void Gets_Column_Definition() { var path = Path.Combine(Environment.CurrentDirectory, "dacServicesTest.dac"); if(File.Exists(path)) File.Delete(path); using (TSqlModel model = new TSqlModel(SqlServerVersion.Sql110, new TSqlModelOptions {})) { model.AddObjects( "CREATE TABLE t1 (c1 NVARCHAR(30) NOT NULL, id int primary key clustered)", new TSqlObjectOptions()); DacPackageExtensions.BuildPackage(path, model, new PackageMetadata() {Description = "Test Package", Name = "ssss", Version = "1"}); } var dac = new DacServices.DacParser(path); Assert.AreEqual(1, dac.GetTableDefinitions().Count); var table = dac.GetTableDefinitions().FirstOrDefault(); Assert.AreEqual("c1", table.Columns.FirstOrDefault().Name.Value); Assert.AreEqual(LiteralType.String, table.Columns.FirstOrDefault().LiteralType); }