Class DataTableExtensions

Inheritance
object
DataTableExtensions
Inherited Members
Namespace: PayrollEngine.Data
Assembly: PayrollEngine.Core.dll
Syntax
public static class DataTableExtensions

Methods

AsDictionary(DataTable)

Declaration
public static List<Dictionary<string, object>> AsDictionary(this DataTable dataTable)
Parameters
Type Name Description
DataTable dataTable
Returns
Type Description
List<Dictionary<string, object>>

GetValues<T>(DataTable, string, T)

Declaration
public static List<T> GetValues<T>(this DataTable dataTable, string column, T defaultValue = default)
Parameters
Type Name Description
DataTable dataTable
string column
T defaultValue
Returns
Type Description
List<T>
Type Parameters
Name Description
T

Json(DataTable, JsonNamingPolicy, bool)

Declaration
public static string Json(this DataTable dataTable, JsonNamingPolicy namingPolicy = null, bool ignoreNull = true)
Parameters
Type Name Description
DataTable dataTable
JsonNamingPolicy namingPolicy
bool ignoreNull
Returns
Type Description
string

RemovePrimaryKey(DataTable)

Declaration
public static void RemovePrimaryKey(this DataTable table)
Parameters
Type Name Description
DataTable table

SetPrimaryKey(DataTable, string)

Declaration
public static void SetPrimaryKey(this DataTable table, string columnName)
Parameters
Type Name Description
DataTable table
string columnName