Oracle 不能指定版本导致 ORA-00933:SQL命令未正确结束

> 特别说明：如果 Issue 报告为问题且开发成员回复确认问题之后但**三天内**都不能得到反馈，则视为无效Issue。

### Furion 版本号

1.17.1

-----------

### Web 项目类型

- [x] WebApi
- [ ] Mvc
- [ ] Razor Pages
- [ ] Blazor Server

-----------

### 描述你的问题

```
var file = await _repository.DetachedEntities.FirstOrDefaultAsync(x => x.Id == fileId);
```
生成的SQL语句：

```
SELECT "l"."FILEID", "l"."CREATETIME", "l"."CREATEUSERID", "l"."CREATEUSERNAME", "l"."DELETEMARK", "l"."EQUIID", "l"."FILEEXTENSIONS", "l"."FILENAME", "l"."FILEPATH", "l"."FILESIZE", "l"."FILETYPE", "l"."PARENTID"
FROM "EQUI_FILEINFO" "l"
WHERE "l"."FILEID" = 'ab20b357-4760-44c9-9446-cd5a89242709'
FETCH FIRST 1 ROWS ONLY
```

-----------

### 异常堆栈信息

Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00933: SQL 命令未正确结束
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)

-----------

### 代码或代码仓库

什么代码导致？

-----------

### 数据库信息

- [ ] Sqlite
- [ ] SqlServer
- [ ] Mysql
- [x] Oracle
- [ ] PGSql
- [ ] Firebird
- [ ] Cosmos

-----------

### 期待结果

```
services.AddDbContextPool<DefaultDbContext>(options =>
            {
                options.UseOracle(GetConnectionString(configuration, DatabaseType.Oracle),b=>b.UseOracleSQLCompatibility("11"))
            }, poolSize: 64);

```

**通过类似 UseOracleSQLCompatibility方法，向配置中传递11指的是Oracle11g版本，如果是12g版本，传递12**

或者像Mysql一样
-----------

GVP dotNET China/Furion

内容风险标识

评论 (2)

GVPdotNET China/Furion

内容风险标识