WarningsConfiguration is not propagated correctly in SQL Server provider #29069
Description
Relational warnings configuration is lost when applying SQL Server-specific warnings.
coreOptionsExtension = RelationalOptionsExtension.WithDefaultWarningConfiguration(coreOptionsExtension)
.WithWarningsConfiguration(
coreOptionsExtension.WarningsConfiguration.TryWithExplicit(
SqlServerEventId.ConflictingValueGenerationStrategiesWarning, WarningBehavior.Throw));Notice that the result of WithDefaultWarningConfiguration is not used to call coreOptionsExtension.WarningsConfiguration.TryWithExplicit.