Class BinaryObjectRecordData

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the BinaryObject table.

Inheritance
object
BinaryObjectRecordData
Inherited Members
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class BinaryObjectRecordData
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Constructors

BinaryObjectRecordData()

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the BinaryObject table.

Declaration
public BinaryObjectRecordData()
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Fields

BinaryData

The binary data itself. Length is limited by the database, generally 1GB seems to be reliably available. Beyond that is database dependent.

Declaration
public Stream BinaryData
Field Value
Type Description
Stream
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

BinaryObjectId

Primary key

Declaration
public int BinaryObjectId
Field Value
Type Description
int
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

BlobSize

The length, in bytes, of the binary data AS STORED after any encryption and/or zipping. Important to get right, since some databases will not tell us just based on the blob itself!

Declaration
public uint BlobSize
Field Value
Type Description
uint
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ConceptualType

The type, for instance PHOTO, PERSONPHOTO, or whatever, that is descriptive of what kind of image or data this is

Declaration
public string ConceptualType
Field Value
Type Description
string
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Description

A description that is entered by the user, and visible to the user

Declaration
public string Description
Field Value
Type Description
string
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ExtraInfo

Extra information, spare field, can be used for anything that makes sense. Should not refer to any particular context, that is something for the BinaryObjectLInk

Declaration
public string ExtraInfo
Field Value
Type Description
string
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

IsEncrypted

Has the data been encrypted (support for this will come in HDB)

Declaration
public short IsEncrypted
Field Value
Type Description
short
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

IsZipped

Has the data been zipped (support for this will come in HDB)

Declaration
public short IsZipped
Field Value
Type Description
short
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

MimeType

Mime type, describing the technical type (image/jpeg) of the data

Declaration
public string MimeType
Field Value
Type Description
string
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

OriginalSize

Original size of the binary data, before encryption and/or zipping. This is what the ultimate client will get

Declaration
public uint OriginalSize
Field Value
Type Description
uint
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Registered

Registered when in UTC.

Declaration
public DateTime Registered
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

RegisteredAssociateId

Registered by whom

Declaration
public int RegisteredAssociateId
Field Value
Type Description
int
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Updated

Last updated when in UTC.

Declaration
public DateTime Updated
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdatedAssociateId

Last updated by whom

Declaration
public int UpdatedAssociateId
Field Value
Type Description
int
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdatedCount

Number of updates made to this record

Declaration
public short UpdatedCount
Field Value
Type Description
short
Remarks

Please use this class instead of a full BinaryObjectRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding BinaryObjectTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Extension Methods