Class EjselResultSetRecordDataExtensions

Extension methods to make it easy to fetch EjselResultSetRecordData objects from the database, using the TargetedSelect infrastructure

Inheritance
object
EjselResultSetRecordDataExtensions
Inherited Members
Namespace: SuperOfficeCRMRows
Assembly: SoDataBase.dll
Syntax
public static class EjselResultSetRecordDataExtensions

Methods

FromRecord(TargetedDataRecord<EjselResultSetTableInfo>)

From a TargetedDataRecord<EjselResultSetTableInfo>, create and populate a EjselResultSetRecordData POCO object

Declaration
public static EjselResultSetRecordData FromRecord(this TargetedDataRecord<EjselResultSetTableInfo> record)
Parameters
Type Name Description
TargetedDataRecordEjselResultSetTableInfo record
Returns
Type Description
EjselResultSetRecordData
Examples
var s = S.NewSelect<DataRightTableInfo>( /* add meaningful restrictions here, or later */ );
/* add joins, return fields etc. as you wish */
s.ReturnFields.Add(s.Table.All);
var result = s.Records().Select(r => new { EjselResultSetItem = r.FromRecord(), /* fetch other fields here */ });

FromSelect(TargetedSelect<EjselResultSetTableInfo>)

From a TargetedSelect<EjselResultSetTableInfo>, execute it and return an IEnumerable<EjselResultSetRecordData> with the results

Declaration
public static IEnumerable<EjselResultSetRecordData> FromSelect(this TargetedSelect<EjselResultSetTableInfo> select)
Parameters
Type Name Description
TargetedSelectEjselResultSetTableInfo select
Returns
Type Description
IEnumerableEjselResultSetRecordData
Examples
var s = S.NewSelect<DataRightTableInfo>( /* add meaningful restrictions here, or later */ );
var result = s.FromSelect();

FromSelectAsync(TargetedSelect<EjselResultSetTableInfo>, CancellationToken)

From a TargetedSelect<EjselResultSetTableInfo>, execute it and return an IEnumerable<EjselResultSetRecordData> with the results

Declaration
[CreateSyncVersion(OmitNullableDirective = true)]
public static IAsyncEnumerable<EjselResultSetRecordData> FromSelectAsync(this TargetedSelect<EjselResultSetTableInfo> select, CancellationToken cancellationToken = default)
Parameters
Type Name Description
TargetedSelectEjselResultSetTableInfo select
CancellationToken cancellationToken
Returns
Type Description
IAsyncEnumerableEjselResultSetRecordData
Examples
var s = S.NewSelect<DataRightTableInfo>( /* add meaningful restrictions here, or later */ );
var result = s.FromSelect();

ToInsertAsync(EjselResultSetRecordData, CancellationToken)

Declaration
public static Task<Insert> ToInsertAsync(this EjselResultSetRecordData record, CancellationToken cancellationToken = default)
Parameters
Type Name Description
EjselResultSetRecordData record
CancellationToken cancellationToken
Returns
Type Description
TaskInsert

ToInsertsAsync(IEnumerable<EjselResultSetRecordData>, CancellationToken)

Declaration
public static IAsyncEnumerable<Insert> ToInsertsAsync(this IEnumerable<EjselResultSetRecordData> records, CancellationToken cancellationToken = default)
Parameters
Type Name Description
IEnumerableEjselResultSetRecordData records
CancellationToken cancellationToken
Returns
Type Description
IAsyncEnumerableInsert

ToRecordData(EjselResultSetRow)

Declaration
public static EjselResultSetRecordData ToRecordData(this EjselResultSetRow row)
Parameters
Type Name Description
EjselResultSetRow row
Returns
Type Description
EjselResultSetRecordData