Click or drag to resize
SqlHelperBuildIntTable Method
Gets a table-valued parameter for database calls. Is intended for usage with [Type_CMS_IntegerTable] database type.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 11.0.0
Syntax
C#
public static IEnumerable<SqlDataRecord> BuildIntTable(
	IEnumerable<int> integers
)

Parameters

integers
Type: System.Collections.GenericIEnumerableInt32

Return Value

Type: IEnumerableSqlDataRecord
Remarks
Returns null, if the enumeration is empty. The database doesn't ever expect to get empty table, it needs not to add the parameter at all. So when calling this method to add an parameter to a query, check this for null at first and do not add the parameter at all in that case. For performance reuses returned SqlDataRecord, so it should be immediately consumed.
See Also