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

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 13.0.131
Syntax
C#
public static IEnumerable<SqlDataRecord> BuildStringTable(
	IEnumerable<string> strings
)

Parameters

strings
Type: System.Collections.GenericIEnumerableString

Return Value

Type: IEnumerableSqlDataRecord
Remarks
Returns empty enumeration if there are no values provided. 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 an empty enumeration at first and do not add the parameter at all in that case.
See Also