IsRowVersion can only be configured for Byte array properties

c# ef-code-first entity-framework entity-framework-6

Question

I recently upgraded from EntityFramework 5 to 6 via the NuGet updater. Everything seemed to go well and I built and executed my application. When I tried to retrieve the first entity from the database, I received this error:

The property 'UpdatedDate' is not a Byte array. IsRowVersion can only be configured for Byte array properties.

Here is the piece of code it is referring to:

[Timestamp]
public virtual DateTime UpdatedDate { get; set; }

I tried removing the timestamp attribute, but got the same error regardless. How do I fix this so I can run my application with EF6?

1
5
12/4/2013 6:35:25 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Attributes in EF

If you use [TimeStamp] attribute, then the property should be byte[]
This is then mapped to Rowversion in SQL server

If you want some other field type as a concurrency field. The use the attribute [ConcurrencyCheck]

10
12/12/2013 3:08:01 PM

Related Questions

Error with Entity Framework Associations Because the attributes of the Dependent Role are not the most important ones.

If you have a link table with a column with identity specification, remove that (it would restrict the link table to only one copy of the ID for that linked table).
c# dns domain-driven-design entity entity-framework
asked by Graham Laight

How to avoid Lazy Loading when accessing foreign key ID property through navigation property?

I'm in the process of converting a project from NHibernate to Entity Framework 6....Given this simple model: ...public class User { public int ID { get; set; } public string FullName { get; set; } public virtual Organization Organization { get; set; } // [...] } public class Organization { public int ID { get; set; } public...
c# ef-code-first entity-framework entity-framework-6
asked by ECC-Dan

Entity Framework will only set related entity property to "null" if I first get the property

Edit... This seems to occur for ...any... Entity property that references another entity in one direction. In other words, for the below example, the fact that ...Bar... overrides Equality appears to be irrelevant....Suppose I have the following classes:...public class Foo { public int? Id { get; set; } public virtual Bar { get; set; } }...
c# entity-framework entity-framework-6
asked by Nathan

Storing DateTime property instead of byte array in SQL table using Code-First MVC5 EF6

When I try to initialize my database using EF6 in MVC5 I get the error: ...The property 'Timestamp' is not a Byte array. IsRowVersion can only be configured for Byte array properties.... Is there a way I can override the IsRowVersion using FluentAPI or is there another method to store DateTime using MVC5 EF6 or is this simply the result of using th...
asp.net-mvc-5 c# datetime entity-framework-6 sql
asked by yardpenalty.com

Comparing byte array in Entity Framework where clause

Is it possible to compare a byte array in the where clause using Entity Framework?...I've got a list of bytes like this:...List<byte[]> VisitorIDList ...I need to pull some data like this:...var VisitorList = context.Visitors .Where(a => VisitorIDList.Contains(a.VisitorID)) .ToList(); ...The ...VisitorID... field is interpreted as a ...by...
c# entity-framework entity-framework-6
asked by Ricketts

After upgrade to EF6 - The property cannot be configured as a navigation property

I have a following class:...[Table("TagSource")] public class TagSource { public TagSource() { this.DataSources = new HashSet<DataSource>(); } [Key] public int TagSourceId { get; set; } ... public bool IsHistorical { get; set; } public Nullable<int> ModifiedEntryId { get; set; } ... public int? Attac...
asp.net-mvc-5 entity-framework entity-framework-6
asked by christof

The property cannot be configured as navigation property

I am trying to implement a domain model like this: ...This is an entity framework mvc application. The code for the model looks like this:...public class Login { [Key] public int LoginID { get; set; } public virtual Therapist Therapist { get; set; } public virtual Patient Patient { get; set; } } public class Patient { [Key] ...
c# entity-framework
asked by Tomek

rowVersion gets mapped to byte[8] in Entityframe work but when manually casting it's byte[18]

I am getting ...rowVersion... from database as ...byte[8]...var rowVersion= new MyContext().Employee.FirstOrDefault(x => x.Id).rowVersion; // suppose above the actual databse values is 0x0000000000038B8C var rowVersionToLong = BitConverter.ToInt64(rowVersion,0); ...Now if i manually do this:...String rowversionStr = "0x0000000000038B8C"; byte[] myb...
c#-4.0 entity-framework-6 rowversion
asked by InTheWorldOfCodingApplications

To sqldbtype, convert the byte[] array. Using Dapper for Varbinary

I've found a code snipped on the Internet that inserts a document as a byte array in the database. It is as follows:... public void databaseFilePut(string varFilePath) { byte[] file; using (var stream = new FileStream(varFilePath, FileMode.Open, FileAccess.Read)) { using (var reader = new BinaryReader(stre...
c# dapper entity-framework sql sql-server
asked by Longshadow

Entity Framework not comparing byte arrays

I am inserting data, using EF, which contains a SHA512 Hash. I am then looking up the same data like this, but no results are returned: ...var searchHash = requestToFind.GetSelfSha512Hash(); var foundRequest = _complianceContext.ScoreResults .Where(sr => sr.SearchHash == searchHash); ...Both ...sr.SearchHash... and ...searchHash... are ...byte[...
c# entity-framework entity-framework-6 hash
asked by FailedUnitTest

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow