How do I define RowVersion in a C# class when using SQL Server and Entity Framework

Question

I have created a SQL table and an EF Fluent mapping as follows:

CREATE TABLE [dbo].[Application] (
    [ApplicationId]   INT            IDENTITY (1, 1) NOT NULL,
    [Name] NVARCHAR (50) Not NULL,
    [DataVersion] ROWVERSION,
    CONSTRAINT [PK_dbo.Application] PRIMARY KEY CLUSTERED ([ApplicationId] ASC)
);

My EF Fluent API looks like this:

public class ApplicationConfiguration : EntityTypeConfiguration<Application>
    {
        public ApplicationConfiguration()
        {
            Property(a => a.Name)
                .IsRequired()
                .HasMaxLength(35);

            Property(p => p.RowVersion).IsRowVersion();

        }
    }

My Class looks like this:

public class Application
{
    public int ApplicationId { get; set; }
    public string Name { get; set; }
    public virtual ICollection<TestAccount> TestAccounts { get; set; }
    xxxxxxx
}

Can someone tell me how I can define the RowVersion in my class?

What version of EF are you using?

Rui Jarimba
– Rui Jarimba

2013-03-07 14:44:48 +00:00
Commented Mar 7, 2013 at 14:44 — Rui Jarimba
– Rui Jarimba, Commented Mar 7, 2013 at 14:44

Rui Jarimba · Accepted Answer · 2013-03-07 14:49:22Z

3

This works for me - I'm using EF4:

public class Application
{
    public int ApplicationId { get; set; }
    public string Name { get; set; }
    public virtual ICollection<TestAccount> TestAccounts { get; set; }

    public virtual byte[] RowVersion { get; set; }
}

Mapping:

public class ApplicationConfiguration : EntityTypeConfiguration<Application>
{
    public ApplicationConfiguration()
    {
        Property(a => a.Name)
            .IsRequired()
            .HasMaxLength(35);

        Property(p => p.RowVersion).HasColumnName("DataVersion").IsRowVersion();
    }
}

PS: The datatype of my database colum is timestamp (I'm using SQL Server 2005)

answered Mar 7, 2013 at 14:49

Rui Jarimba

18.5k11 gold badges64 silver badges101 bronze badges

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

Comments

Neil Thompson · Accepted Answer · 2013-03-07 14:43:08Z

2

I think it's

public class Application
{
    public int ApplicationId { get; set; }
    public string Name { get; set; }
    public virtual ICollection<TestAccount> TestAccounts { get; set; }
    public virtual byte[] DataVersion { get; set; }
}

answered Mar 7, 2013 at 14:43

Neil Thompson

6,4652 gold badges33 silver badges55 bronze badges

Collectives™ on Stack Overflow

How do I define RowVersion in a C# class when using SQL Server and Entity Framework

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related