Interface IRowComparerCommand<T>

Commands for specifying which columns to include and how to compare two rows of the same type.

Also see RowComparer<T> and Compare Dataflow Columns.

Use IRowComparerCommand<TLeft, TRight> instead if either the rows have different types, or they are the same type and you also need to compare different columns (e.g. column "A" in one row with column "B" in the other row, even though the rows are the same type).

Inherited Members

IFluentInterface.GetType()

IFluentInterface.GetHashCode()

IFluentInterface.ToString()

IFluentInterface.Equals(Object)

Namespace: actionETL

Assembly: actionETL.dll

Syntax

public interface IRowComparerCommand<T> : IFluentInterface where T : class

Type Parameters

Name	Description
T	The type of the rows.

Methods

Asc(String)

Includes the specified column in the comparison, with values evaluated in ascending order.

While string columns use case sensitive comparisons with the current culture, do instead use overloads that specifies a StringComparer explicitly.

Declaration

IRowComparerCommand<T> Asc(string columnName)

Parameters

Type	Name	Description
String	columnName	Name of the column. Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Returns

Type	Description
IRowComparerCommand<T>	The instance itself, for chaining multiple commands together.

Exceptions

Type	Condition
ArgumentException	Column cannot be null or whitespace. No matching column found.
InvalidOperationException	Found more than one member match in type. No .NET CLR Type information available. RowComparer: column type has no CompareTo() method.

Asc(String, StringComparer)

Includes the specified column in the comparison, with values evaluated in ascending order.

Declaration

IRowComparerCommand<T> Asc(string columnName, StringComparer stringComparer)

Parameters

Type	Name	Description
String	columnName	Name of the column. Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.
StringComparer	stringComparer	The string comparer.

Returns

Type	Description
IRowComparerCommand<T>	The instance itself, for chaining multiple commands together.

Exceptions

Type	Condition
ArgumentException	Column cannot be null or whitespace. No matching column found.
ArgumentNullException	stringComparer
InvalidOperationException	Found more than one member match in type. No .NET CLR Type information available.

Asc<TColumn>(String, Comparison<TColumn>)

Includes the specified column in the comparison, with values evaluated in ascending order.

Declaration

IRowComparerCommand<T> Asc<TColumn>(string columnName, Comparison<TColumn> columnComparison)

Parameters

Type	Name	Description
String	columnName	Name of the column. Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.
Comparison<TColumn>	columnComparison	The column comparison.

Returns

Type	Description
IRowComparerCommand<T>	The instance itself, for chaining multiple commands together.

Type Parameters

Name	Description
TColumn	The type of the column.

Exceptions

Type	Condition
ArgumentException	Column cannot be null or whitespace. No matching column found.
ArgumentNullException	columnComparison
InvalidOperationException	Found more than one member match in type. No .NET CLR Type information available.

Desc(String)

Includes the specified column in the comparison, with values evaluated in descending order.

While string columns use case sensitive comparisons with the current culture, do instead use overloads that specifies a StringComparer explicitly.

Declaration

IRowComparerCommand<T> Desc(string columnName)

Parameters

Type	Name	Description
String	columnName	Name of the column. Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Returns

Type	Description
IRowComparerCommand<T>	The instance itself, for chaining multiple commands together.

Exceptions

Type	Condition
ArgumentException	Column cannot be null or whitespace. No matching column found.
InvalidOperationException	Found more than one member match in type. No .NET CLR Type information available. RowComparer: column type has no CompareTo() method.

Desc(String, StringComparer)

Includes the specified column in the comparison, with values evaluated in descending order.

Declaration

IRowComparerCommand<T> Desc(string columnName, StringComparer stringComparer)

Parameters

Type	Name	Description
String	columnName	Name of the column. Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.
StringComparer	stringComparer	The string comparer.

Returns

Type	Description
IRowComparerCommand<T>	The instance itself, for chaining multiple commands together.

Exceptions

Type	Condition
ArgumentException	Column cannot be null or whitespace. No matching column found.
ArgumentNullException	stringComparer
InvalidOperationException	Found more than one member match in type. No .NET CLR Type information available.

Desc<TColumn>(String, Comparison<TColumn>)

Includes the specified column in the comparison, with values evaluated in descending order.

Declaration

IRowComparerCommand<T> Desc<TColumn>(string columnName, Comparison<TColumn> columnComparison)

Parameters

Type	Name	Description
String	columnName	Name of the column. Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.
Comparison<TColumn>	columnComparison	The column comparison.

Returns

Type	Description
IRowComparerCommand<T>	The instance itself, for chaining multiple commands together.

Type Parameters

Name	Description
TColumn	The type of the column.

Exceptions

Type	Condition
ArgumentException	Column cannot be null or whitespace. No matching column found.
ArgumentNullException	columnComparison
InvalidOperationException	Found more than one member match in type. No .NET CLR Type information available.