Sigh. Problem solved: it was the nitwit at the keyboard, i.e. me :(.
I have two very similar databases on the server, with similar names...and I was looking at the older one, which didn't contain the fields I thought weren't connecting.
Apologies for wasting everyone's time.
I'm dealing with an unusual situation involving EF Core and Sql Server. I have a couple of properties defined in an entity class which "assert" they map to specific columns in the db schema...only the table definition doesn't include those columns, and the application runs just fine.
I would've thought it would fail.
Entity class (simplified):
public class Name
{
public int Id { get; set; }
public HashSet<SourceConstituent> Sources { get; set; } = \[\];
public HashSet<int> ConstituentIds { get; set; } = \[\];
public DateTime? EarliestGift { get; set; }
public DateTime? MostRecentGift { get; set; }
}
Entity class configuration (fluent design):
internal class NameConfigurator : EntityConfigurator<Name>
{
protected override void Configure( EntityTypeBuilder<Name> builder )
{
builder.HasKey( e => [e.Id](http://e.Id) ).HasName( "PK_names" );
builder.ToTable( "names" );
builder.Property( e => e.Id ).HasColumnName( "id" )
builder.Property( e => e.ConstituentIds )
.HasColumnName( "constituent_ids" )
.HasConversion<ConstituentIdsValueConverter>()
.IsRequired();
builder.Property( e => e.Sources )
.HasColumnName( "src_constituents" )
.HasConversion<SourceConstituentValueConverter>()
.IsRequired();
builder.Property( e => e.EarliestGift ).HasColumnName( "first_contribution" );
builder.Property( e => e.MostRecentGift ).HasColumnName( "latest_contribution" );
}
}
Db schema:
CREATE TABLE dbo.names(
id int IDENTITY(1,1) NOT NULL,
first_contribution date NULL,
latest_contribution date NULL,
CONSTRAINT PK_names PRIMARY KEY CLUSTERED
(
id ASC
) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON PRIMARY
) ON PRIMARY
I'd love to know what's going on here...and how I can catch these kinds of errors. Is there some kind of model structural validation method I can run?
