使用mono连接SQLServer需要注意什么?

Question

Jexus专业版 6.2

Mono/6.8.0.105, Build: 2020.03.05

Jexus/6.2.1.12 Linux

 

目前使用的是ADO.NET , 按理来说应该是完全支持的
项目在Windows下面的时候没问题
(最后直接使用DBHelper进行数据链接进行排查,在SqlCommand实例化的时候就会报错)

报错信息如下
(主要是不清楚这种情况是要修改什么东西来适配,还望告知,万分感谢)

System.ArgumentException
Keyword not supported: 'version'.
Description: HTTP 500.Error processing request.

Details: Non-web exception. Exception origin (name of application or object):System.Data.

Exception stack trace:

at System.Data.Common.DbConnectionOptions.ParseInternal (System.Collections.Generic.Dictionary`2[TKey,TValue] parsetable, System.String connectionString, System.Boolean buildChain, System.Collections.Generic.Dictionary`2[TKey,TValue] synonyms, System.Boolean firstKey) [0x0005f] in <50a6f8536b7b49b4a290cd95548dae1e>:0 
  at System.Data.Common.DbConnectionOptions..ctor (System.String connectionString, System.Collections.Generic.Dictionary`2[TKey,TValue] synonyms) [0x00030] in <50a6f8536b7b49b4a290cd95548dae1e>:0 
  at System.Data.SqlClient.SqlConnectionString..ctor (System.String connectionString) [0x00007] in <50a6f8536b7b49b4a290cd95548dae1e>:0 
  at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions (System.String connectionString, System.Data.Common.DbConnectionOptions previous) [0x00000] in <50a6f8536b7b49b4a290cd95548dae1e>:0 
  at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup (System.Data.Common.DbConnectionPoolKey key, System.Data.ProviderBase.DbConnectionPoolGroupOptions poolOptions, System.Data.Common.DbConnectionOptions& userConnectionOptions) [0x0003e] in <50a6f8536b7b49b4a290cd95548dae1e>:0 
  at System.Data.SqlClient.SqlConnection.ConnectionString_Set (System.Data.Common.DbConnectionPoolKey key) [0x00008] in <50a6f8536b7b49b4a290cd95548dae1e>:0 
  at System.Data.SqlClient.SqlConnection.set_ConnectionString (System.String value) [0x00042] in <50a6f8536b7b49b4a290cd95548dae1e>:0 
  at System.Data.SqlClient.SqlConnection..ctor (System.String connectionString) [0x00006] in <50a6f8536b7b49b4a290cd95548dae1e>:0 
  at (wrapper remoting-invoke-with-check) System.Data.SqlClient.SqlConnection..ctor(string)

Answer 1

参考 https://www.mono-project.com/docs/database-access/providers/sqlclient/