mySobek Home   |   Help
Skip Navigation Links.
Expand <a href='https://sobekrepository.org/sobekcm' title='Sobek home page'>Project Home</a>Project Home
Expand <a href='https://sobekrepository.org/help' title='Online user help'>User Help</a>User Help
Expand <a href='https://sobekrepository.org/sobekcm/technical' title='Sobek home page'>Technical Help</a>Technical Help
Expand <a href='https://sobekrepository.org/software' title='Center for downloading all SobekCM-related software'>Download Center</a>Download Center
Training Videos
Collapse <a href='https://sobekrepository.org/codehelp' title='Details on each of the different classes, interfaces, properties, etc..'>Code Details</a>Code Details
MISSING BANNER

AdoNetHelper Class



Contains static helper methods for ADO.Net objects including Fast Serialization


Namespace: SobekCM.Core.MemoryMgmt
Assembly: SobekCM_Core (in SobekCM_Core.dll) Version: 4.10.0.0 (4.10.0.0)

Syntax

C#
public class AdoNetHelper

Remarks

Code written by Simon Hewitt and dedicated to public domain (2006)

Inheritance Hierarchy

System..::..Object
  SobekCM.Core.MemoryMgmt..::..AdoNetHelper

Methods

  NameDescription
Public methodStatic memberDeserializeDataSet(array<Byte>[]()[][])
Creates a new DataSet and populates it from originally serialized data.
Public methodStatic memberDeserializeDataSet(DataSet, array<Byte>[]()[][])
Deserializes data and infrastructure into the supplied DataSet.
Public methodStatic memberDeserializeDataSet(Type, array<Byte>[]()[][])
Deserializes a DataSet or Typed DataSet from a byte[].
Public methodStatic memberDeserializeDataTable(array<Byte>[]()[][])
Creates a new DataTable and populates it with previously serialized data.
Public methodStatic memberDeserializeDataTable(DataTable, array<Byte>[]()[][])
Populates the supplied DataTable with previously serialized data.
Public methodStatic memberDeserializeSimpleTypedDataTable(DataTable, array<Byte>[]()[][])
Populates an existing Typed DataTable with row data previously serialized using SerializeSimpleTypedDataTable.
Public methodStatic memberDeserializeSimpleTypedDataTable(Type, array<Byte>[]()[][])
Create a new DataTable of the requested type and populates it with row data previously serialized using SerializeSimpleDataTable.
Public methodStatic memberDeserializeTypedDataSet(DataSet, array<Byte>[]()[][])
Deserializes a Typed DataSet from a byte[] containing serialized data only.
Public methodStatic memberDeserializeTypedDataSet(Type, array<Byte>[]()[][])
Deserializes a Typed DataSet from a byte[] containing serialized data only.
Public methodStatic memberDeserializeTypedDataTable(DataTable, array<Byte>[]()[][])
Deserializes a Typed DataTable from a byte[] containing serialized data only.
Public methodStatic memberDeserializeTypedDataTable(Type, array<Byte>[]()[][])
Deserializes a Typed DataTable from a byte[] containing serialized data only.
Public methodStatic memberGetDataSetDump
Create a simple string dump of the contents (each table) of a DataSet, including the key values for each row.
Public methodStatic memberGetKeyValuesFromRow(DataRow)
Gets an object[] holding the PrimaryKey column values. The Row must be in a DataTable.
Public methodStatic memberGetKeyValuesFromRow(DataRow, DataTable)
Gets an object[] holding the values from the columns having the same names as those of the PrimaryKey columns from the supplied DataTable.
Public methodStatic memberGetNullableDateTime
Maps DateTime.MinValue to DBNull.Value.
Public methodStatic memberGetTableDump
Gets the table dump (as a string) for a particular table
Public methodStatic memberGetUniqueColumnValues(array<DataRow>[]()[][], DataColumn)
Gets a list of unique values for a column from a list of rows.
Public methodStatic memberGetUniqueColumnValues(array<DataRow>[]()[][], Int32)
Gets a list of unique values for a column from a list of rows.
Public methodStatic memberGetUniqueColumnValues(array<DataRow>[]()[][], String)
Gets a list of unique values for a column from a list of rows.
Public methodStatic memberGetValuesFromRowVersion
Returns an object[] of all the row values for the specified version
Public methodStatic memberSerializeDataSet
Serializes a DataSet to a byte[].
Public methodStatic memberSerializeDataTable
Serializes a DataTable to a byte[].
Public methodStatic memberSerializeSimpleTypedDataTable
Serializes a simple Typed DataTable to a byte[] containing only data.
Public methodStatic memberSerializeTypedDataSet
Serializes a Typed DataSet to a byte[] containing only the data for each DataTable (ie no infrastructure)
Public methodStatic memberSerializeTypedDataTable
Serializes a Typed DataTable to a byte[] containing only the data (ie no infrastructure)

See Also



Version 4.10.0 ( last generated Monday, March 7, 2016 )