make EF map byte array to binary instead of varbinary

Question

By default c# data type byte[] in POCO object is mapped to sql type varbinary. Is it possible to map it to binary type using dataannotations or fluent API?

Thanx.

1. Do you use code-first or ObjectContext (i assume CF)? 2. Do you use EF-Migrations? In this case you can set the type of the column explicitly... — Stephen Reindl
– Stephen Reindl, Commented Mar 15, 2015 at 23:25

kalan · Accepted Answer · 2015-03-16 11:05:10Z

2

I have found the answer myself. It can be done using Fluent API the following way

 protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);

            modelBuilder.Entity<MyEntity>().Property(x => x.BinaryProperty).HasMaxLength(LengthOfBinaryField).IsFixedLength();          
        }

answered Mar 16, 2015 at 11:05

kalan

1,8524 gold badges22 silver badges35 bronze badges

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

1 Comment

Steven Rands Over a year ago

Can also be done using data annotation attributes as per this answer.

Collectives™ on Stack Overflow

make EF map byte array to binary instead of varbinary

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related