Timestamp in C# for persistence in Sqlserver

Question

Is there any typing that already treats this in C# to perform persistence in Sqlserver database?

I need to resolve the Createdat and Updatedat property. For each change, it will be stored in the database.

public class UserBaseEntity
{
    [Key]
    [ScaffoldColumn(false)]
    public int Id { get; set; }

    [Timestamp]
    public DateTime CreatedAt { get; set; }

    public DateTime UpdatedAt { get; set; }
}

The signature on the property would solve this case?

Answer 1

You can use the type Byte[], following Microsoft’s own standard.

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

Defining the type of your field as Byte[] and using the attribute [Timestamp] it will be recorded with the SQL Server rowversion (timestamp).

timestamp is synonymous with the type of rowversion data and is subject to behavior synonymous with data type. In DDL instructions, use rowversion instead of timestamp whenever possible. To get more information, see Data type synonyms (Transact-SQL).

Updating the database with the parameter -Verbose you will have the following SQL to generate the table (changing only its field CreatedAt as shown above):

CREATE TABLE [dbo].[UserBaseEntities] (
    [Id] [int] NOT NULL IDENTITY,
    [CreatedAt] rowversion NOT NULL,
    [UpdatedAt] [varbinary](max),
    CONSTRAINT [PK_dbo.UserBaseEntities] PRIMARY KEY ([Id])
)