Repository (ProcessCore)

Repository Module

Namespace: ProcessCore.SQL
Assembly: ProcessCore.dll

Static catalogue of Table{TRow} descriptors, one per persisted table in the data model.

Each value bundles the table's name, column list, primary key and row codecs so that the CRUD façades (DefinedTerm, Recipe, …) and external callers can build statements without hard-coding column lists.

Functions and values

Function or value	Description
`Repository.Annotation` Full Usage: `Repository.Annotation` Returns: `Table<AnnotationRow>`	Descriptor for the `annotation` table. Primary key: `id`. Returns: `Table<AnnotationRow>`
`Repository.AssociationTables ()` Full Usage: `Repository.AssociationTables ()` Parameters: () : `unit` Returns: `string[]`	Names of the association tables (rows that link two or more entities, typically with an ordering position), in canonical declaration order. () : `unit` Returns: `string[]`
`Repository.Data` Full Usage: `Repository.Data` Returns: `Table<DataRow>`	Descriptor for the `data` table. Primary key: `id`. Returns: `Table<DataRow>`
`Repository.DataAdditionalProperty` Full Usage: `Repository.DataAdditionalProperty` Returns: `Table<DataAdditionalPropertyRow>`	Descriptor for the `data_additional_property` association table. Primary key: `(data_id, position)`. Returns: `Table<DataAdditionalPropertyRow>`
`Repository.Dataset` Full Usage: `Repository.Dataset` Returns: `Table<DatasetRow>`	Descriptor for the `dataset` table. Primary key: `id`. Returns: `Table<DatasetRow>`
`Repository.DatasetAdditionalProperty` Full Usage: `Repository.DatasetAdditionalProperty` Returns: `Table<DatasetAdditionalPropertyRow>`	Descriptor for the `dataset_additional_property` association table. Primary key: `(dataset_id, position)`. Returns: `Table<DatasetAdditionalPropertyRow>`
`Repository.DatasetHasPart` Full Usage: `Repository.DatasetHasPart` Returns: `Table<DatasetHasPartRow>`	Descriptor for the `dataset_has_part` association table. Primary key: `(dataset_id, position)`. Returns: `Table<DatasetHasPartRow>`
`Repository.DatasetProcess` Full Usage: `Repository.DatasetProcess` Returns: `Table<DatasetProcessRow>`	Descriptor for the `dataset_process` association table. Primary key: `(dataset_id, position)`. Returns: `Table<DatasetProcessRow>`
`Repository.DefinedTerm` Full Usage: `Repository.DefinedTerm` Returns: `Table<DefinedTermRow>`	Descriptor for the `defined_term` table. Primary key: `id`. Returns: `Table<DefinedTermRow>`
`Repository.EntityTables ()` Full Usage: `Repository.EntityTables ()` Parameters: () : `unit` Returns: `string[]`	Names of the entity tables (independent rows with their own primary key), in canonical declaration order. Useful for schema introspection, fixture loading and bulk truncate. () : `unit` Returns: `string[]`
`Repository.FormalParameter` Full Usage: `Repository.FormalParameter` Returns: `Table<FormalParameterRow>`	Descriptor for the `formal_parameter` table. Primary key: `id`. Returns: `Table<FormalParameterRow>`
`Repository.Process` Full Usage: `Repository.Process` Returns: `Table<ProcessRow>`	Descriptor for the `process` table. Primary key: `id`. Returns: `Table<ProcessRow>`
`Repository.ProcessIo` Full Usage: `Repository.ProcessIo` Returns: `Table<ProcessIoRow>`	Descriptor for the `process_io` association table. Primary key: `(process_id, direction, position)`. Returns: `Table<ProcessIoRow>`
`Repository.ProcessParameterValue` Full Usage: `Repository.ProcessParameterValue` Returns: `Table<ProcessParameterValueRow>`	Descriptor for the `process_parameter_value` association table. Primary key: `(process_id, position)`. Returns: `Table<ProcessParameterValueRow>`
`Repository.ProtocolAdditionalProperty` Full Usage: `Repository.ProtocolAdditionalProperty` Returns: `Table<ProtocolAdditionalPropertyRow>`	Descriptor for the `protocol_additional_property` association table. Primary key: `(protocol_id, position)`. Returns: `Table<ProtocolAdditionalPropertyRow>`
`Repository.ProtocolParameter` Full Usage: `Repository.ProtocolParameter` Returns: `Table<ProtocolParameterRow>`	Descriptor for the `protocol_parameter` association table. Primary key: `(protocol_id, position)`. Returns: `Table<ProtocolParameterRow>`
`Repository.Recipe` Full Usage: `Repository.Recipe` Returns: `Table<RecipeRow>`	Descriptor for the `recipe` table. Primary key: `id`. Returns: `Table<RecipeRow>`
`Repository.Sample` Full Usage: `Repository.Sample` Returns: `Table<SampleRow>`	Descriptor for the `sample` table. Primary key: `id`. Returns: `Table<SampleRow>`
`Repository.SampleAdditionalProperty` Full Usage: `Repository.SampleAdditionalProperty` Returns: `Table<SampleAdditionalPropertyRow>`	Descriptor for the `sample_additional_property` association table. Primary key: `(sample_id, position)`. Returns: `Table<SampleAdditionalPropertyRow>`