EFcore Value does not fall within the expected range.

最新推荐文章于 2021-12-24 15:31:47 发布
最新推荐文章于 2021-12-24 15:31:47 发布
阅读量1k 收藏
点赞数
分类专栏： asp.net  core EF Core Oracle 文章标签： c# .netcore oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_41864148/article/details/122126473
版权

@ Value does not fall within the expected range.

System.ArgumentException: Value does not fall within the expected range.
   at Oracle.EntityFrameworkCore.Infrastructure.OracleDbContextOptionsBuilder.UseOracleSQLCompatibility(String useOracleSQLCompatibility)
   at PTS.API.Startup.<>c.<ConfigureServices>b__4_2(OracleDbContextOptionsBuilder b) in D:\workspacesCode\VisualStudio2019Code\PTS\PTS.API\Startup.cs:line 32
   at Microsoft.EntityFrameworkCore.OracleDbContextOptionsExtensions.UseOracle(DbContextOptionsBuilder optionsBuilder, String connectionString, Action`1 oracleOptionsAction)
   at PTS.API.Startup.<ConfigureServices>b__4_0(DbContextOptionsBuilder option) in D:\workspacesCode\VisualStudio2019Code\PTS\PTS.API\Startup.cs:line 32
   at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.<>c__DisplayClass1_0`2.<AddDbContext>b__0(IServiceProvider p, DbContextOptionsBuilder b)
   at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.CreateDbContextOptions[TContext](IServiceProvider applicationServiceProvider, Action`2 optionsAction)
   at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.<>c__DisplayClass17_0`1.<AddCoreServices>b__0(IServiceProvider p)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitFactory(FactoryCallSite factoryCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass1_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngine.GetService(Type serviceType, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
   at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.<>c__17`1.<AddCoreServices>b__17_1(IServiceProvider p)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitFactory(FactoryCallSite factoryCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitIEnumerable(IEnumerableCallSite enumerableCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass1_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngine.GetService(Type serviceType, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetServices[T](IServiceProvider provider)
   at Microsoft.EntityFrameworkCore.Design.Internal.DbContextOperations.FindContextTypes()
   at Microsoft.EntityFrameworkCore.Design.Internal.DbContextOperations.FindContextType(String name)
   at Microsoft.EntityFrameworkCore.Design.Internal.DbContextOperations.CreateContext(String contextType)
   at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.AddMigration(String name, String outputDir, String contextType, String namespace)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.AddMigrationImpl(String name, String outputDir, String contextType, String namespace)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.AddMigration.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
Value does not fall within the expected range.

** EFcore Value does not fall within the expected range.**

在使用EF core 连接Oracle 时报了这样的错.
Value does not fall within the expected range.
原因是因为 oracle 数据库的版本号，和我们声明的版本号不一致导致的。

检查了下连接字符串也没问题，其实问题出在了 Startup.cs 中，我使用的oracle 版本为：oracle 19C 所以，按照以下截图修改即可 UseOracleSQLCompatibility(“12”)
在这里插入图片描述
在运行生成迁移文件的命令，是不是问题消失了？
PS:
如果使用的是 orcale 11 那么就是UseOracleSQLCompatibility(“11”)
如果使用的是 orcale 20C 那么就是UseOracleSQLCompatibility(“13”)
以此类推。

写bug的精神小伙
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
Silverlight ComboBox Bug - Value does not fall within the expected range
James Zhou's blog
07-03 4496
Silverlight 2 Combobox 有一个bug, 今天被我遇到了，下面是IE错误信息： Error: Unhandled Error in Silverlight 2 Application Code: 4004    Category: ManagedRuntimeError       Message: System.ArgumentException: Val
在Hololens中开发TCP通信，错误“ArgumentException: Value does not fall within the expected range”的解决方案
皮皮#2500
08-01 2894
在Hololens中开发TCP通信，错误“ArgumentException: Value does not fall within the expected range”的解决方案问题描述解决方法参考链接 问题描述     在将异步TCP通信项目部署到Hololens2中运行时，出现错误“ArgumentException: Value does not fall within the expected range”，这是在5月15日发部的Win 10 SDK 10.0.19041.0与Unity2019
Value does not fall within the expected range 值不在预期的范围内
weixin_30545285的博客
07-16 1409
用vs2012 打开web.config时，提示如下错误：“Value does not fall within the expected range”; 中文提示：“值不在预期的范围内” 解决方案：删除解决方案同目录下的.suo 文件。 转载于:https://www.cnblogs.com/zhangzhi19861216/p/4651822.html...
C# (Microsoft.Office.Interop.Word) Value does not fall within the expected range
小鹰信息技术服务部
05-14 4979
C#读取Word模板操作表格（Microsoft.Office.Interop.Word），获取模板中的表格 测试document.Tables.Count, 结果是1， 也就是表格只有一个，按理说那就是Tables[0]了， Table table = document.Tables[0]; 但是这个写法报错：Value does not fall within the expect...
SharePoint Error : System.ArgumentException. Value does not fall within the expected range
swanabin的专栏
07-25 2605
转自VC错误:http://www.vcerror.com/?p=1914 问题描述： 做SharePoint的时候遇到这个错误： System.ArgumentException. Value does not fall within the expected range.     at Microsoft.SharePoint.Library.SPRequestInternalC
the cross-section of volatility and expected returns.pdf
09-07
本文《波动性与预期回报的横截面》（"the cross-section of volatility and expected returns.pdf"）深入探讨了股票收益率波动性对市场横截面上预期回报的影响。研究者Andrew Ang、Robert J. Hodrick、Yuhang Xing和...
Semiparametric GARCH models with long memory applied to value-at-risk and expected shortfall.xdf
最新发布
06-02
Semiparametric GARCH models with long memory applied to value-at-risk and expected shortfall.xdf
CMSIS.rar，解决缺少core_cmFunc.h和core_cmInstr.h
06-27
在描述中提到的问题是，在使用Keil IDE进行开发时遇到了编译错误，提示缺少`core_cmFunc.h`和`core_cmInstr.h`这两个头文件。这些文件是CMSIS的核心部分，它们包含了Cortex-M内核特定的功能定义，如中断服务例程...
hamcrest-core-1.3的压缩包，hamcrest-core-1.3.jar包 是一款hamcrest的核心包
05-16
例如，`is(not(equalTo("expected")))`表示判断传入的对象是否不等于"expected"。 3. 自定义匹配器：除了预定义的匹配器外，开发者还可以自定义匹配器以满足特定需求。这可以通过实现`Matcher`接口或使用`...
usb_windows.rar_AdbWinApi_AdbWinApi.dll_The Returned
09-14
Structure usb_handle describes our connection to the usb device via AdbWinApi.dll. This structure is returned usb_open() routine and is expected in each subsequent call that is accessing the device.
Value does not fall within the expected range exception while using ReportDataSource
weixin_30599769的博客
07-07 360
Here is my code which produce “Value does not fall within the expected range” exception. ReportDataSource objReportDataSource = new ReportDataSource(“CategoryProduct”); objReportDataSou...
wpf BitmapImage.EndInit() Value does not fall within the expected range.
n727158431的博客
07-25 624
一、报错环境：win7客户机，个别浮现 二、代码报错位置： System.ArgumentException: Value does not fall within the expected range. ---> System.ArgumentException: Value does not fall within the expected range. --- End of ...
SharePoint Designer 报错“ Value does not fall within the expected range”
weixin_30349597的博客
04-27 108
有朋友突然来问，SharePoint Designer 报错“ Value does not fall within the expected range” 。 Cause SPD does not open the site with name it was originally defined. For example, the site was created as http:...
Value does not fall within the expected range in excel word addin HResult 2147024809
码农, 农民工的程序人生
03-25 4935
这个错误“Value does notfall within the expected range ”在网上有很多种解释，但是都不能解决我遇到的问题。google能搜到一些具体的解决办法，但是由于国内代理的问题不能访问。当我想往一个Excel里加入一个CuntomTaskPane的时候（Globals.ThisAddIn.CustomTaskPanes.Add(control, title，win
[windows phone 8] Value does not fall within the expected range.这个错误有可能是xaml树中有重名的控件...
weixin_33994444的博客
12-11 92
[windows phone 8] Value does not fall within the expected range.这个错误有可能是xaml树中有重名的控件，要求所有的Name属性是唯一的。 但是xaml树中封装在UserControl中的元素可以与它所在的xaml中的其他元素重名。...
ABP Vnext 5.0 EF6Core适配Oracle 解决方案
HeBizhi1997的博客
12-24 1187
Abp 框架支持 Oracle 数据库
ef导入oracle数据类型不正确,EF Core操作Oracle踩坑记
weixin_39772388的博客
04-09 633
EF(Entity Framework)是微软标志性且成熟的ORM，从之前的.NET Framework时代就已经很常见了，但是给人的感觉还是偏“重”，性能被不少人吐槽，倒是像Dapper这类更轻量级的更受大家待见。但是进入.NET Core时代后，EF随之进化为EF Core(Entity Framework Core)，除了是为ASP.NET Core量身打造外，在性能和功能上微软也是做了很多...
The integer literal does not conform to the expected type BigInteger
04-05
The error message "The integer literal does not conform to the expected type BigInteger" usually occurs when a value is expected to be of the BigInteger type (a data type that can represent large ...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值