Entity Framework code first with TimeStamp type

Question

I am using SQL Server 2008 R2 and Entity Framework 5.0. When the database is generated, I cannot add my property of type TimeStamp without having the following error: There is no store type corresponding to the conceptual side type

'Edm.Time(Nullable=True,DefaultValue=,Precision=)' of primitive type 'Time'.

I have set the Entity Configuration to the type time or timestamp without success

Property(x => x.RestBetweenSet).HasColumnType("timestamp");

When I go in the Sql Server Management Studio and edit the table I can set a column of timestamp.

What do I need to do to have Entity Framework code first be able to generate this column?

Thank you

FakeCaleb · Accepted Answer · 2016-10-18 12:47:14Z

15

You should declare your time stamp property as follows in your code first class:

[Timestamp] 
public Byte[] MyTimestamp { get; set; }

edited Oct 18, 2016 at 12:47

FakeCaleb

9838 silver badges19 bronze badges

answered Sep 26, 2012 at 23:33

Eric J.

151k65 gold badges353 silver badges563 bronze badges

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

1 Comment

Patrick Desjardins Over a year ago

Hi, the problem is that we cannot use anymore all timestamp method if it's a Byte.

Community · Accepted Answer · 2017-05-23 11:54:37Z

3

For the moment, I map to a INT64 and ignore the TimeStamp. Like in this post.

If they are better solutions, feel free to add. I won't accept my answer yet.

edited May 23, 2017 at 11:54

CommunityBot

11 silver badge

answered Oct 1, 2012 at 13:12

Patrick Desjardins

142k89 gold badges299 silver badges346 bronze badges

1 Comment

Tony Edgecombe Over a year ago

So you wanted to store a Timespan rather than a Timestamp?

user3402754 · Accepted Answer · 2017-03-16 09:44:36Z

1

I am not sure I understand your question so well, but this how I generate timestamp fields using code first approach and entity framework

[Required, DatabaseGenerated(DatabaseGeneratedOption.Computed)]
public DateTime CreatedAt { get; set; }

answered Mar 16, 2017 at 9:44

user3402754

3,1052 gold badges21 silver badges33 bronze badges

Collectives™ on Stack Overflow

Entity Framework code first with TimeStamp type

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related