Microsoft.Extensions.Options.OptionsValidationException: A configuration validation error occurred. DataAnnotation validation failed for members: 'ConnectionString' with error: 'The ConnectionString field is required.'
ID: dotnet/aspnet-core-options-validation-failure
Version Compatibility
| Version | Status | Introduced | Deprecated | Notes |
|---|---|---|---|---|
| .NET 7.0 | active | — | — | — |
| .NET 8.0 | active | — | — | — |
| Microsoft.Extensions.Options.DataAnnotations 7.0.0 | active | — | — | — |
| Microsoft.Extensions.Options.DataAnnotations 8.0.0 | active | — | — | — |
Root Cause
Options validation fails when an application startup validates configuration objects via DataAnnotations and a required property is missing or invalid in appsettings.json or environment variables.
generic中文
当应用程序启动通过 DataAnnotations 验证配置对象且 appsettings.json 或环境变量中缺少必需属性或属性无效时,选项验证失败。
Official Documentation
https://learn.microsoft.com/en-us/aspnet/core/fundamentals/configuration/options?view=aspnetcore-8.0#options-validationWorkarounds
-
90% success Ensure the required configuration key exists in appsettings.json or environment variables. For example, add to appsettings.json: '"MyOptions": { "ConnectionString": "Server=myServer;Database=myDB;" }' or set environment variable 'MyOptions__ConnectionString' to a valid value.
Ensure the required configuration key exists in appsettings.json or environment variables. For example, add to appsettings.json: '"MyOptions": { "ConnectionString": "Server=myServer;Database=myDB;" }' or set environment variable 'MyOptions__ConnectionString' to a valid value. -
85% success If the property is intentionally optional, remove the '[Required]' attribute from the options class and handle null values in code, or provide a default value using 'options.DefaultValue = "..."' in the configuration.
If the property is intentionally optional, remove the '[Required]' attribute from the options class and handle null values in code, or provide a default value using 'options.DefaultValue = "..."' in the configuration.
中文步骤
确保 appsettings.json 或环境变量中存在所需的配置键。例如,在 appsettings.json 中添加:'"MyOptions": { "ConnectionString": "Server=myServer;Database=myDB;" }' 或设置环境变量 'MyOptions__ConnectionString' 为有效值。如果该属性是可选的,请从选项类中移除 '[Required]' 属性并在代码中处理 null 值,或在配置中使用 'options.DefaultValue = "..."' 提供默认值。
Dead Ends
Common approaches that don't work:
-
85% fail
Removing the 'ValidateDataAnnotations()' call in services configuration suppresses the error but bypasses safety checks, potentially causing runtime issues.
-
70% fail
Adding a default value to the property in the options class may hide the error if the default is invalid, leading to silent failures.
-
60% fail
Only checking appsettings.json while the value is overridden by environment variables with empty string can still trigger validation failure.