Example #1
0
        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);
        }
Example #2
0
        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);
        }