Class SearchCriteriaRecordDataExtensions

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

Inheritance
Object
SearchCriteriaRecordDataExtensions
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public static class SearchCriteriaRecordDataExtensions : Object

Methods

FromRecord(TargetedDataRecord<SearchCriteriaTableInfo>)

From a TargetedDataRecord<SearchCriteriaTableInfo>, create and populate a SearchCriteriaRecordData POCO object

Declaration
public static SearchCriteriaRecordData FromRecord(this TargetedDataRecord<SearchCriteriaTableInfo> record)
Parameters
Type Name Description
TargetedDataRecord<SearchCriteriaTableInfo> record
Returns
Type Description
SearchCriteriaRecordData
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 { SearchCriteriaItem = r.FromRecord(), /* fetch other fields here */ });

FromSelect(TargetedSelect<SearchCriteriaTableInfo>)

From a TargetedSelect<SearchCriteriaTableInfo>, execute it and return an IEnumerable<SearchCriteriaRecordData> with the results

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

ToInsert(SearchCriteriaRecordData)

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

Declaration
public static Insert ToInsert(this SearchCriteriaRecordData record)
Parameters
Type Name Description
SearchCriteriaRecordData record
Returns
Type Description
Insert

ToInserts(IEnumerable<SearchCriteriaRecordData>)

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

Declaration
public static IEnumerable<Insert> ToInserts(this IEnumerable<SearchCriteriaRecordData> records)
Parameters
Type Name Description
IEnumerable<SearchCriteriaRecordData> records
Returns
Type Description
IEnumerable<Insert>

ToRecordData(SearchCriteriaRow)

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

Declaration
public static SearchCriteriaRecordData ToRecordData(this SearchCriteriaRow row)
Parameters
Type Name Description
SearchCriteriaRow row
Returns
Type Description
SearchCriteriaRecordData