public void PrimaryAndForeignKeyGeneratesCorrectSql() { var sql = new ColumnTestDatabase("").CreateTableSql("item", new Column("itemId", DataType.BIGINT).AsPrimaryKey().AsForeignKey("FK_item", "item", "itemId"), new Column("remoteId", DataType.GUID).AsForeignKey("FK_remote", "remote", "remoteId") ); sql.ShouldBe("CREATE TABLE dbo.item ([itemId] bigint NOT NULL, [remoteId] uniqueidentifier NULL, CONSTRAINT PK_item PRIMARY KEY CLUSTERED ([itemId]),CONSTRAINT FK_item FOREIGN KEY ([itemId]) REFERENCES dbo.[item] (itemId),CONSTRAINT FK_remote FOREIGN KEY ([remoteId]) REFERENCES dbo.[remote] (remoteId))"); }
public void PrimaryKeyGeneratesCorrectSql() { var column = new Column("itemId", DataType.GUID).AsPrimaryKey(); var sql = new ColumnTestDatabase("").CreateTableSql("item", new List <Column> { column }); sql.ShouldBe("CREATE TABLE dbo.item ([itemId] uniqueidentifier NOT NULL, CONSTRAINT PK_item PRIMARY KEY CLUSTERED ([itemId]))"); }