RowCodecExtensions (ProcessCore)

RowCodecExtensions Module

Namespace: ProcessCore.SQL
Assembly: ProcessCore.dll

Bidirectional codecs between row records and the on-the-wire SqlRow / SqlParameters representations consumed by ISqliteDriver.

Each entity type defined in Tables.fs is augmented with two members:

static member ofRow : SqlRow -> row — decodes a query result row, raising with a fully qualified table.column tag if a required column is missing or has the wrong storage class.
member this.ToParameters : unit -> SqlParameters — encodes the row to the parameter array consumed by the repository's INSERT/UPDATE statements.

The module is AutoOpen, so consumers obtain these members simply by opening the ProcessCore.SQL namespace.

Type extensions

Type extension	Description
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `defined_term`. Extended Type: `DefinedTermRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `lab_protocol`. Extended Type: `LabProtocolRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `formal_parameter`. Extended Type: `FormalParameterRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `dataset`. Extended Type: `DatasetRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `material`. Extended Type: `MaterialRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `data`. Extended Type: `DataRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `lab_process`. Extended Type: `LabProcessRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `property_value`. Extended Type: `PropertyValueRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `dataset_has_part`. Extended Type: `DatasetHasPartRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `dataset_process`. Extended Type: `DatasetProcessRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `dataset_additional_property`. Extended Type: `DatasetAdditionalPropertyRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `protocol_parameter`. Extended Type: `ProtocolParameterRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `process_io`. Extended Type: `ProcessIoRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `process_parameter_value`. Extended Type: `ProcessParameterValueRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `protocol_additional_property`. Extended Type: `ProtocolAdditionalPropertyRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `material_additional_property`. Extended Type: `MaterialAdditionalPropertyRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `data_additional_property`. Extended Type: `DataAdditionalPropertyRow` () : `unit` Returns: `SqlParameters`
`DefinedTermRow.ofRow row` Full Usage: `DefinedTermRow.ofRow row` Parameters: row : `SqlRow` Returns: `DefinedTermRow`	Decodes a DefinedTermRow from a `defined_term` result row. Extended Type: `DefinedTermRow` row : `SqlRow` Returns: `DefinedTermRow`
`LabProtocolRow.ofRow row` Full Usage: `LabProtocolRow.ofRow row` Parameters: row : `SqlRow` Returns: `LabProtocolRow`	Decodes a LabProtocolRow from a `lab_protocol` result row. Extended Type: `LabProtocolRow` row : `SqlRow` Returns: `LabProtocolRow`
`FormalParameterRow.ofRow row` Full Usage: `FormalParameterRow.ofRow row` Parameters: row : `SqlRow` Returns: `FormalParameterRow`	Decodes a FormalParameterRow from a `formal_parameter` result row. Extended Type: `FormalParameterRow` row : `SqlRow` Returns: `FormalParameterRow`
`DatasetRow.ofRow row` Full Usage: `DatasetRow.ofRow row` Parameters: row : `SqlRow` Returns: `DatasetRow`	Decodes a DatasetRow from a `dataset` result row. Extended Type: `DatasetRow` row : `SqlRow` Returns: `DatasetRow`
`MaterialRow.ofRow row` Full Usage: `MaterialRow.ofRow row` Parameters: row : `SqlRow` Returns: `MaterialRow`	Decodes a MaterialRow from a `material` result row. Extended Type: `MaterialRow` row : `SqlRow` Returns: `MaterialRow`
`DataRow.ofRow row` Full Usage: `DataRow.ofRow row` Parameters: row : `SqlRow` Returns: `DataRow`	Decodes a DataRow from a `data` result row. Extended Type: `DataRow` row : `SqlRow` Returns: `DataRow`
`LabProcessRow.ofRow row` Full Usage: `LabProcessRow.ofRow row` Parameters: row : `SqlRow` Returns: `LabProcessRow`	Decodes a LabProcessRow from a `lab_process` result row. Extended Type: `LabProcessRow` row : `SqlRow` Returns: `LabProcessRow`
`PropertyValueRow.ofRow row` Full Usage: `PropertyValueRow.ofRow row` Parameters: row : `SqlRow` Returns: `PropertyValueRow`	Decodes a PropertyValueRow from a `property_value` result row. Extended Type: `PropertyValueRow` row : `SqlRow` Returns: `PropertyValueRow`
`DatasetHasPartRow.ofRow row` Full Usage: `DatasetHasPartRow.ofRow row` Parameters: row : `SqlRow` Returns: `DatasetHasPartRow`	Decodes a DatasetHasPartRow from a `dataset_has_part` result row. Extended Type: `DatasetHasPartRow` row : `SqlRow` Returns: `DatasetHasPartRow`
`DatasetProcessRow.ofRow row` Full Usage: `DatasetProcessRow.ofRow row` Parameters: row : `SqlRow` Returns: `DatasetProcessRow`	Decodes a DatasetProcessRow from a `dataset_process` result row. Extended Type: `DatasetProcessRow` row : `SqlRow` Returns: `DatasetProcessRow`
`DatasetAdditionalPropertyRow.ofRow row` Full Usage: `DatasetAdditionalPropertyRow.ofRow row` Parameters: row : `SqlRow` Returns: `DatasetAdditionalPropertyRow`	Decodes a DatasetAdditionalPropertyRow from a `dataset_additional_property` result row. Extended Type: `DatasetAdditionalPropertyRow` row : `SqlRow` Returns: `DatasetAdditionalPropertyRow`
`ProtocolParameterRow.ofRow row` Full Usage: `ProtocolParameterRow.ofRow row` Parameters: row : `SqlRow` Returns: `ProtocolParameterRow`	Decodes a ProtocolParameterRow from a `protocol_parameter` result row. Extended Type: `ProtocolParameterRow` row : `SqlRow` Returns: `ProtocolParameterRow`
`ProcessIoRow.ofRow row` Full Usage: `ProcessIoRow.ofRow row` Parameters: row : `SqlRow` Returns: `ProcessIoRow`	Decodes a ProcessIoRow from a `process_io` result row, including the direction tag. Extended Type: `ProcessIoRow` row : `SqlRow` Returns: `ProcessIoRow`
`ProcessParameterValueRow.ofRow row` Full Usage: `ProcessParameterValueRow.ofRow row` Parameters: row : `SqlRow` Returns: `ProcessParameterValueRow`	Decodes a ProcessParameterValueRow from a `process_parameter_value` result row. Extended Type: `ProcessParameterValueRow` row : `SqlRow` Returns: `ProcessParameterValueRow`
`ProtocolAdditionalPropertyRow.ofRow row` Full Usage: `ProtocolAdditionalPropertyRow.ofRow row` Parameters: row : `SqlRow` Returns: `ProtocolAdditionalPropertyRow`	Decodes a ProtocolAdditionalPropertyRow from a `protocol_additional_property` result row. Extended Type: `ProtocolAdditionalPropertyRow` row : `SqlRow` Returns: `ProtocolAdditionalPropertyRow`
`MaterialAdditionalPropertyRow.ofRow row` Full Usage: `MaterialAdditionalPropertyRow.ofRow row` Parameters: row : `SqlRow` Returns: `MaterialAdditionalPropertyRow`	Decodes a MaterialAdditionalPropertyRow from a `material_additional_property` result row. Extended Type: `MaterialAdditionalPropertyRow` row : `SqlRow` Returns: `MaterialAdditionalPropertyRow`
`DataAdditionalPropertyRow.ofRow row` Full Usage: `DataAdditionalPropertyRow.ofRow row` Parameters: row : `SqlRow` Returns: `DataAdditionalPropertyRow`	Decodes a DataAdditionalPropertyRow from a `data_additional_property` result row. Extended Type: `DataAdditionalPropertyRow` row : `SqlRow` Returns: `DataAdditionalPropertyRow`
`ProcessEdgeRow.ofRow row` Full Usage: `ProcessEdgeRow.ofRow row` Parameters: row : `SqlRow` Returns: `ProcessEdgeRow`	Decodes a ProcessEdgeRow from a `process_edges` view row. Read-only — there is no `ToParameters`. Extended Type: `ProcessEdgeRow` row : `SqlRow` Returns: `ProcessEdgeRow`
`PropertyValueOrphanRow.ofRow row` Full Usage: `PropertyValueOrphanRow.ofRow row` Parameters: row : `SqlRow` Returns: `PropertyValueOrphanRow`	Decodes a PropertyValueOrphanRow from a `property_value_orphans` view row. Read-only. Extended Type: `PropertyValueOrphanRow` row : `SqlRow` Returns: `PropertyValueOrphanRow`