I acquired an issue with EF 4. I creating entity with "timestamp" column. Next, I attempt to create database.

In SQL script column appears like 'binary(8)' rather than timestamp.

How you can solve it ?

the issue solved: EF 4 could'n generate timestamp posts from edmx designer. The answer is simple:

  1. Set the kind to binary.
  2. Set nullable to false.
  3. Set StoreGeneratedPattern to Calculated.
  4. Set ConcurrencyMode to Fixed.
  5. Produce a copy of SSDLToSQL10.tt (typically present in C:Program Files (x86)Microsoft Visual Studio 10.0Common7IDEExtensionsMicrosoftEntity Framework ToolsDBGen). Let us refer to it as MySSDLToSQL10.tt.
  6. Edit the road (presently 151) that states:

[<#=Id(prop.Title)#>] <#=prop.ToStoreType()#> <#=WriteIdentity(prop, targetVersion)#> <#=WriteNullable(prop.Nullable)#><#=(p < entitySet.ElementType.Qualities.Count - 1) ? "," : ""#>

  1. Change it out to:

[<#=Id(prop.Title)#>] <#if (string.Compare(prop.Title,"TimeStamp",true) == ) else #> <#=WriteIdentity(prop, targetVersion)#> <#=WriteNullable(prop.Nullable)#><#=(p < entitySet.ElementType.Qualities.Count - 1) ? "," : ""#>