Exemplos de Xtensive.Sql.Model UniqueConstraint em C# (CSharp)

Exemplo n.º 1

        public void Test158()
        {
            var t = Catalog.Schemas["main"].Tables["customer"];

            Xtensive.Sql.Model.UniqueConstraint uc = t.CreateUniqueConstraint("newUniqueConstraint", t.TableColumns["Phone"]);
            SqlAlterTable stmt = SqlDdl.Alter(t, SqlDdl.AddConstraint(uc));

            Assert.Throws <NotSupportedException>(() => Console.Write(Compile(stmt)));
        }

Exemplo n.º 2

Arquivo: SakilaExtractorTest.cs Projeto: vchirikov/dataobjects-net

        public void Test158()
        {
            var t = schema.Tables["customer"];

            Xtensive.Sql.Model.UniqueConstraint uc = t.CreateUniqueConstraint("newUniqueConstraint", t.TableColumns["email"]);
            SqlAlterTable stmt = SqlDdl.Alter(t, SqlDdl.AddConstraint(uc));

            Console.Write(Compile(stmt));
        }

Exemplo n.º 3

Arquivo: SakilaExtractorTest.cs Projeto: vchirikov/dataobjects-net

        public void Test159()
        {
            var t = Catalog.Schemas["Sakila"].Tables["customer"];

            Xtensive.Sql.Model.UniqueConstraint uc = t.CreateUniqueConstraint("newUniqueConstraint", t.TableColumns["email"]);
            SqlAlterTable stmt = SqlDdl.Alter(t, SqlDdl.DropConstraint(uc));

            Console.Write(Compile(stmt));
        }

Exemplo n.º 4

 /// <summary>
 /// Visits unique constraint.
 /// </summary>
 /// <param name="constraint">The constraint.</param>
 /// <returns>Visit result.</returns>
 protected abstract TResult VisitUniqueConstraint(UniqueConstraint constraint);