SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
MockDbContext using In Memory Database breaks during xUnit Test when a temporal table is in the context
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 45%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Connor Hicks
6
Reputation points
When scaffolding to create a dbcontext including a temporal table, the entity file created does not have the period start or period end columns, but they are set up in the context and can be accessed through EF.Property in Net6.
However, when accessing the MockDbContext from within the xUnit test, there is an error on the temporal table, saying that it expects the period start and end columns. This prevents me from successfully running any tests that use that context, even if i'm working with a different table.
Hoping for a workaround to this.
SQL Server
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,245 questions
{count} vote
-
Jack J Jun 24,286 Reputation points Microsoft Vendor2021-12-01T03:11:30.167+00:00 @Connor Hicks , we noted that you used xunit, it is a 3rd party product, I recommend that you could post your question in Github.
-
Connor Hicks 6 Reputation points
2021-12-01T13:23:44.04+00:00 This is the stack trace and I feel like i only see EF stuff mentioned. But if you still think it's an issue with something 3rd party I will post in github. Thanks for the response either way!
Message:
System.InvalidOperationException : The property 'InitialPlan.ValidFrom' could not be found. Ensure that the property exists and has been included in the model.Stack Trace:
IReadOnlyEntityType.GetProperty(String name)
IMutableEntityType.GetProperty(String name)
TemporalPeriodPropertyBuilder.HasColumnName(String name)
<>c.<OnModelCreating>b__14_7(TemporalTableBuilder1 ttb) line 35 SqlServerTableBuilderExtensions.IsTemporal[TEntity](TableBuilder1 tableBuilder, Action1 buildAction) <>c.<OnModelCreating>b__14_3(TableBuilder1 tb) line 32
RelationalEntityTypeBuilderExtensions.ToTableTEntity
<>c.<OnModelCreating>b__14_0(EntityTypeBuilder1 entity) line 32 ModelBuilder.Entity[TEntity](Action1 buildAction)
PlanDbContext.OnModelCreating(ModelBuilder modelBuilder) line 28
Sign in to comment