Entity:
public class NormativeReference
{
[Key, MaxLength (50)]
public string NormativeReferenceId { get; set; }
public string Name { get; set; }
}
SQL (SQL Server 2014):
CREATE TABLE [dbo].[NormativeReferences] (
[NormativeReferenceId] NVARCHAR (50) NOT NULL,
[Name] NVARCHAR (MAX) NULL,
CONSTRAINT [PK_NormativeReferences] PRIMARY KEY CLUSTERED ([NormativeReferenceId] ASC)
);
CompareEfWithDb returns:
DIFFERENT: NormativeReference->Property 'NormativeReferenceId', value generated. Expected = OnAdd, found = Never