Is there a SQL Server equivalent to the Oracle concept of a 'table of integer'?
是否有一个SQL Server等同于'整数表'的Oracle概念？
If so, what is the best way to represent this object in C#?
如果是这样，在C＃中表示此对象的最佳方法是什么？
Oracle seems to provide the following:
Oracle似乎提供以下内容：
OracleParameter parameter = new OracleParameter(data.parameterName, data.databaseDataType);
parameter.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
I'm aiming to modify this code to work with a DbParameter instead of an OracleParameter and create a SQL Server stored procedure that behaves in the same way as the Oracle SP I'm working with.
我的目标是修改此代码以使用DbParameter而不是OracleParameter，并创建一个SQL Server存储过程，其行为方式与我正在使用的Oracle SP相同。
1 个解决方案
#1
3
I think that what you may be looking for is a SQL Server table-valued parameter, which would map to SqlDbtype.Structured for a SqlParameter. The relevant DbType would be Object.
我认为您可能正在寻找的是一个SQL Server表值参数，它将映射到SqlParameter的SqlDbtype.Structured。相关的DbType将是Object。
#1
3
I think that what you may be looking for is a SQL Server table-valued parameter, which would map to SqlDbtype.Structured for a SqlParameter. The relevant DbType would be Object.
我认为您可能正在寻找的是一个SQL Server表值参数，它将映射到SqlParameter的SqlDbtype.Structured。相关的DbType将是Object。