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 `recipe`. Extended Type: `RecipeRow` () : `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 `sample`. Extended Type: `SampleRow` () : `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 `process`. Extended Type: `ProcessRow` () : `unit` Returns: `SqlParameters`
`this.ToParameters` Full Usage: `this.ToParameters` Parameters: () : `unit` Returns: `SqlParameters`	Encodes the row to SqlParameters for INSERT/UPDATE on `annotation`. Extended Type: `AnnotationRow` () : `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 `sample_additional_property`. Extended Type: `SampleAdditionalPropertyRow` () : `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`
`RecipeRow.ofRow row` Full Usage: `RecipeRow.ofRow row` Parameters: row : `SqlRow` Returns: `RecipeRow`	Decodes a RecipeRow from a `recipe` result row. Extended Type: `RecipeRow` row : `SqlRow` Returns: `RecipeRow`
`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`
`SampleRow.ofRow row` Full Usage: `SampleRow.ofRow row` Parameters: row : `SqlRow` Returns: `SampleRow`	Decodes a SampleRow from a `sample` result row. Extended Type: `SampleRow` row : `SqlRow` Returns: `SampleRow`
`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`
`ProcessRow.ofRow row` Full Usage: `ProcessRow.ofRow row` Parameters: row : `SqlRow` Returns: `ProcessRow`	Decodes a ProcessRow from a `process` result row. Extended Type: `ProcessRow` row : `SqlRow` Returns: `ProcessRow`
`AnnotationRow.ofRow row` Full Usage: `AnnotationRow.ofRow row` Parameters: row : `SqlRow` Returns: `AnnotationRow`	Decodes a AnnotationRow from a `annotation` result row. Extended Type: `AnnotationRow` row : `SqlRow` Returns: `AnnotationRow`
`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`
`SampleAdditionalPropertyRow.ofRow row` Full Usage: `SampleAdditionalPropertyRow.ofRow row` Parameters: row : `SqlRow` Returns: `SampleAdditionalPropertyRow`	Decodes a SampleAdditionalPropertyRow from a `sample_additional_property` result row. Extended Type: `SampleAdditionalPropertyRow` row : `SqlRow` Returns: `SampleAdditionalPropertyRow`
`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`
`AnnotationOrphanRow.ofRow row` Full Usage: `AnnotationOrphanRow.ofRow row` Parameters: row : `SqlRow` Returns: `AnnotationOrphanRow`	Decodes a AnnotationOrphanRow from a `annotation_orphans` view row. Read-only. Extended Type: `AnnotationOrphanRow` row : `SqlRow` Returns: `AnnotationOrphanRow`