This is a big problem because the .ssdl file is one of three that is included as meta-data and used by the Entity Framework to map things out. The net result of this bug is that the Entity Framework will not know that this particular property is supposed to get its value from the server and instead will attempt to provide the value from the client which in the case of a Guid winds up being '00000000-0000-0000-0000-000000000000' and you get a "Violation of PRIMARY KEY constraint" exception.
Here's an example of the .ssdl generated that has a property who's Store Generate Pattern set to Identity but is missing the StoreGeneratedPattern="Identity" in the output. If I manually add this to the .ssdl the "Violation of PRIMARY KEY constraint" exception goes away and Entity Framework once again knows that this property is supposed to get its value from the server.
Code: Select all
<EntityType Name="AnonymousUser">
<Key>
<PropertyRef Name="UserId" />
</Key>
<Property Name="UserId" Type="uniqueidentifier" Nullable="false" devart:DefaultValue="newsequentialid()" />
<Property Name="LastVisited" Type="datetime2" Nullable="false" devart:DefaultValue="sysutcdatetime()" />
<Property Name="CreatedOn" Type="datetime2" Nullable="false" devart:DefaultValue="sysutcdatetime()" />
<Property Name="IpAddress" Type="nvarchar" Nullable="false" MaxLength="50" />
</EntityType>Code: Select all
static string GetConnectionString()
{
var connectionBuilder = new SqlConnectionStringBuilder();
connectionBuilder.UserID = AppSettings.Instance.ConnectionSettings.DbUserName;
connectionBuilder.Password = AppSettings.Instance.ConnectionSettings.DbPassword;
connectionBuilder.InitialCatalog = AppSettings.Instance.ConnectionSettings.DbName;
connectionBuilder.DataSource = AppSettings.Instance.ConnectionSettings.Server;
EntityConnectionStringBuilder ecsb = new EntityConnectionStringBuilder();
ecsb.Provider = "System.Data.SqlClient";
ecsb.ProviderConnectionString = connectionBuilder.ConnectionString;
ecsb.Metadata = GetMetaData();
return ecsb.ConnectionString;
}
static string GetMetaData()
{
var modelPrefix = "MyApp.Data.Models.MyContext";
var metaData = new StringBuilder();
metaData.Append("res://*/" + modelPrefix + ".csdl|");
metaData.Append("res://*/" + modelPrefix + ".ssdl|");
metaData.Append("res://*/" + modelPrefix + ".msl");
return metaData.ToString();
}