Class TableValuedParameterHelper
Contains helper methods for working with table valued parameters.
Inheritance
System.Object
TableValuedParameterHelper
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: TimeCockpit.Data.Database
Assembly: TimeCockpit.Data.dll
Syntax
public class TableValuedParameterHelperConstructors
TableValuedParameterHelper()
Declaration
public TableValuedParameterHelper()Methods
BuildDataTable(Object[])
Builds a System.Data.DataTable for the given values.
Declaration
public static DataTable BuildDataTable(object[] values)Parameters
| Type | Name | Description |
|---|---|---|
| System.Object[] | values | The values to fill the table with. |
Returns
| Type | Description |
|---|---|
| System.Data.DataTable | Returns the System.Data.DataTable. |
GetTypeName(String, DataTable)
Creates the qualified type name for a table.
Declaration
public static string GetTypeName(string schema, DataTable table)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | schema | The schema name. |
| System.Data.DataTable | table | The table. |
Returns
| Type | Description |
|---|---|
| System.String | Returns the name of the type to use for a parameter. |
Remarks
The type name is stored in the table name (done correctly if table was created using BuildDataTable(Object[])).