[
http://tracker.firebirdsql.org/browse/DNET-811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jiri Cincura reopened DNET-811:
-------------------------------
> Can't use new created columns in SQL - Statement in Up() Migration
> ------------------------------------------------------------------
>
> Key: DNET-811
> URL: http://tracker.firebirdsql.org/browse/DNET-811
> Project: .NET Data provider
> Issue Type: Bug
> Components: Entity Framework
> Affects Versions: 5.9.1.0
> Reporter: Andreas Patock
> Assignee: Jiri Cincura
>
> If I have the following migration:
> public partial class AddDeviceType : DbMigration
> {
> public override void Up()
> {
> CreateTable(
> "dbo.DeviceType",
> c => new
> {
> Id = c.Int(nullable: false, identity: true),
> Name = c.String(nullable: false, maxLength: 128),
> ManufacturerId = c.Int(nullable: false),
> })
> .PrimaryKey(t => t.Id)
> .ForeignKey("dbo.Manufacturer", t => t.ManufacturerId,
> cascadeDelete: true)
> .Index(t => t.ManufacturerId);
>
> AddColumn("dbo.Device", "TempDeviceTypeId", c => c.Int());
> AddColumn("dbo.Device", "DeviceTypeId", c => c.Int(nullable:
> false));
> CreateIndex("dbo.Device", "DeviceTypeId");
> AddForeignKey("dbo.Device", "DeviceTypeId", "dbo.DeviceType",
> "Id", cascadeDelete: true);
> Sql("UPDATE \"Device\" d SET d.\"DeviceTypeId\" = (SELECT
> t.\"Id\" from \"DeviceType\" t where t.\"ManufacturerId\" =
> d.\"ManufacturerId\" ORDER BY t.\"Id\" ROWS 1)");
> }
> I can a Column unknown "DeviceTypeId" exception when running the migration.
> This can found on many examples in the internet and is working with mssql.
> I had the idea to do this in two migrations, but the "DeviceTypeId" is a not
> null field and so the first migration throws an exception also.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
