Creating table in migration InitialCreate.cs

Question

I am trying to create a table inside up function.

public override void Up()
    {
        CreateTable(
            "dbo.CrimeReort",
            c => new
                {
                    ImageId = c.Int(nullable: false, identity: true),
                    ImageName = c.String(nullable: false),
                    ImageContent = c.Byte[](nullable: false),
                    Createdby=c.String(),
                    CreatedDt=c.DateTime(),
                    Updatedby =c.String(),
                    UpdatedDt=c.DateTime(),
                    flag = c.Boolean(nullable: false),
                })
            .PrimaryKey(t => t.ImageId);

    }

I want to declare a byte array byte[] but its giving me an error. Besides that this table has a one-one relationship with another table .I also need to cater that as well. I do not know how to make that relationship in migrations.

tallmaris.com/… will show you how to do the relationship. What error are you getting for the Byte[]? — RyanB
– RyanB, Commented May 23, 2014 at 19:35
ok and also tell me about the relationship between two tables. How do I mention that in migrations ? Also I want to create a relationship between existing membership tables with my new tables... — user3532152
– user3532152, Commented May 23, 2014 at 20:20
There's an example in the link in my first post. I added the key line to an answer below with the note about Byte[] as well. — RyanB
– RyanB, Commented May 23, 2014 at 20:25

RyanB · Accepted Answer · 2014-05-23 20:25:13Z

1

AddForeignKey("dbo.CrimeReport", "foreign_Id", "dbo.ForeignTable", "Id");

Also use c.Binary() instead of c.Byte[]

answered May 23, 2014 at 20:25

RyanB

7574 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating table in migration InitialCreate.cs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related