Ejemplos de Sql.AddForeignKey en C# (CSharp)

Ejemplo n.º 1

Archivo: Create.cs Proyecto: ttrider/fluid-sql

        public void Create_ForeignKey()
        {
            var statement = Sql.AddForeignKey("FK_State_City", "ach.State", "ach.City", checkIfNotExists: true)
                            .AddColumn("CapitalCityId", "CityId");

            var command = Utilities.GetCommand(statement);

            Assert.NotNull(command);

            Assert.Equal("IF OBJECT_ID ( N'[ach].[FK_State_City]', N'F' ) IS NULL\r\nBEGIN;\r\nALTER TABLE [ach].[State] ADD CONSTRAINT [FK_State_City] FOREIGN KEY ( [CapitalCityId] ) REFERENCES [ach].[City] ( [CityId] )\r\nEND;",
                         command.CommandText);
        }