Class BulkUpdateResults

Inheritance
object
BulkUpdateResults
Inherited Members
Namespace: SuperOffice.CRM.ArchiveLists
Assembly: SoDataBase.BusinessLogic.dll
Syntax
[ArchiveProvider("BulkUpdateResults", 715827882)]
public class BulkUpdateResults : IArchiveProvider, IArchiveProviderHasRows, IArchiveProviderHasColumns, IArchiveProviderHasEntities

Constructors

BulkUpdateResults()

Declaration
public BulkUpdateResults()

Fields

AllowOrderBy

Declaration
protected const bool AllowOrderBy = true
Field Value
Type Description
bool

Invisible

Declaration
protected const bool Invisible = false
Field Value
Type Description
bool

ProviderName

Declaration
public const string ProviderName = "BulkUpdateResults"
Field Value
Type Description
string

Visible

Declaration
protected const bool Visible = true
Field Value
Type Description
bool

_colAssocId

Declaration
protected ArchiveColumnInfo _colAssocId
Field Value
Type Description
ArchiveColumnInfo

_colAssocName

Declaration
protected ArchiveColumnInfo _colAssocName
Field Value
Type Description
ArchiveColumnInfo

_colDate

Declaration
protected ArchiveColumnInfo _colDate
Field Value
Type Description
ArchiveColumnInfo

_colDbRecordId

Declaration
protected ArchiveColumnInfo _colDbRecordId
Field Value
Type Description
ArchiveColumnInfo

_colEntityType

Declaration
protected ArchiveColumnInfo _colEntityType
Field Value
Type Description
ArchiveColumnInfo

_colResult

Declaration
protected ArchiveColumnInfo _colResult
Field Value
Type Description
ArchiveColumnInfo

_colResultCount

Declaration
protected ArchiveColumnInfo _colResultCount
Field Value
Type Description
ArchiveColumnInfo

Methods

Close()

Call this method after the last desired row has been read; this gives the provider the chance to close and free any underlying queries

Declaration
public void Close()

GetAvailableColumns()

Get the list of columns handled by this provider

Declaration
public List<ArchiveColumnInfo> GetAvailableColumns()
Returns
Type Description
List<ArchiveColumnInfo>

GetAvailableEntities()

Get the list of entities supported by this provider

Declaration
public List<ArchiveRowTypeInfo> GetAvailableEntities()
Returns
Type Description
List<ArchiveRowTypeInfo>

GetReaderAsync(string, CancellationToken)

Start the reader and return an IDataReader (which, as we remember, also inherits IDataRecord for access to individual data fields). This provides an alternative, more generic and more standards-based interface to data. Use either GetRows or GetReader on any particular archive provider instance.

Declaration
public Task<DbDataReader> GetReaderAsync(string i_Options, CancellationToken cancellationToken = default)
Parameters
Type Name Description
string i_Options
CancellationToken cancellationToken
Returns
Type Description
Task<DbDataReader>

GetResultInformationAsync()

Get additional information about the result, such as row count or other optional items. This method should be called after GetRowsAsync(string, CancellationToken), but before Close.

Declaration
public Task<ArchiveResultInformation> GetResultInformationAsync()
Returns
Type Description
Task<ArchiveResultInformation>

GetRowsAsync(string, CancellationToken)

Start the query and return an iterator. The .Current property will be a valid ArchiveRow containing one row, as long as a previous call to .MoveNext returned true. This is the standard semantics for an iterator. Do remember to call Close afterwards, to clean up all resources.

Declaration
public IAsyncEnumerable<ArchiveRow> GetRowsAsync(string options, CancellationToken _ = default)
Parameters
Type Name Description
string options

A set of options, using the query string format (name=value&...). Can be null or empty.

OptionPurpose/effect
countrows=truePrepare to return a count of the full result set
Options set here may trigger additional, asynchronous processing that will prepare results for the GetInformation method, if possible.
CancellationToken _
Returns
Type Description
IAsyncEnumerable<ArchiveRow>

An iterator, following the usual conventions. MoveNext will return false when there are no more rows, which can either be because the result set is exhausted, or because the page size has been reached
Remarks

You can use the await foreach keyword to iterate over rows, like this:

IArchiveProvider provider = ArchiveProviderFactory.Create("person");
// not shown - set desired columns, entities, restrictions, paging
await foreach( ArchiveRow row in provider.GetRowsAsync() )
{
	// process row here
}
provider.Close();

SetDesiredColumns(params string[])

Set which columns should actually be returned, must be a subset of the GetAvailableColumns result

Declaration
public void SetDesiredColumns(params string[] i_Columns)
Parameters
Type Name Description
string[] i_Columns

SetDesiredEntities(params string[])

Declaration
public void SetDesiredEntities(params string[] i_Entities)
Parameters
Type Name Description
string[] i_Entities

SetOrderBy(params ArchiveOrderByInfo[])

Declaration
public void SetOrderBy(params ArchiveOrderByInfo[] i_OrderBys)
Parameters
Type Name Description
ArchiveOrderByInfo[] i_OrderBys

SetPagingInfo(int, int)

Set the paging properties of the provider. The default is to fetch page zero, of one thousand (1000) rows. A more reasonable page size is probably around 100. Note that the query processing strategy may change for very large pages (more than 1000) and give significantly longer response times. Performance is improved by setting the page size low, as long as you don't set it lower than what you realistically expect to need (fetching multiple pages is more expensive than fetching one).

Declaration
public void SetPagingInfo(int i_PageSize, int i_PageNumber)
Parameters
Type Name Description
int i_PageSize
int i_PageNumber

SetRestriction(params ArchiveRestrictionInfo[])

Set query restriction globally, supersedes previous restrictions

Declaration
public bool SetRestriction(params ArchiveRestrictionInfo[] i_Restrictions)
Parameters
Type Name Description
ArchiveRestrictionInfo[] i_Restrictions
Returns
Type Description
bool

true if at least one of the restrictions matched one of the available columns of the provider

Implements

Extension Methods