Interface IRowComparerCommand<TLeft, TRight>

Commands for specifying which columns to include and how to compare two rows of potentially different types.

Also see RowComparer<TLeft, TRight> and Compare Dataflow Columns. Use IRowComparerCommand<T> if the rows have the same type.

Inherited Members

IFluentInterface.GetType()

IFluentInterface.GetHashCode()

IFluentInterface.ToString()

IFluentInterface.Equals(Object)

Namespace: actionETL

Assembly: actionETL.dll

Syntax

public interface IRowComparerCommand<TLeft, TRight> : IFluentInterface where TLeft : class where TRight : class

Type Parameters

Name	Description
TLeft	The type of the left row.
TRight	The type of the right row.

Methods

Asc(String)

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

Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Columns must have identical types (although nullability can differ). If this is not the case, use an overload that specifies the comparison explicitly.

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

Declaration

IRowComparerCommand<TLeft, TRight> Asc(string columnName)

Parameters

Type	Name	Description
String	columnName	Name of the left and right columns.

Returns

Type	Description
IRowComparerCommand<TLeft, TRight>	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: columns have different types. RowComparer: column type has no CompareTo() method.

Asc(String, String)

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

Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Columns must have identical types (although nullability can differ). If this is not the case, use an overload that specifies the comparison explicitly.

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

Declaration

IRowComparerCommand<TLeft, TRight> Asc(string leftColumnName, string rightColumnName)

Parameters

Type	Name	Description
String	leftColumnName	Name of the left column.
String	rightColumnName	Name of the right column.

Returns

Type	Description
IRowComparerCommand<TLeft, TRight>	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: columns have different types. RowComparer: column type has no CompareTo() method.

Asc(String, String, StringComparer)

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

Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Declaration

IRowComparerCommand<TLeft, TRight> Asc(string leftColumnName, string rightColumnName, StringComparer stringComparer)

Parameters

Type	Name	Description
String	leftColumnName	Name of the left column.
String	rightColumnName	Name of the right column.
StringComparer	stringComparer	The StringComparer to use for the column comparison.

Returns

Type	Description
IRowComparerCommand<TLeft, TRight>	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(String, StringComparer)

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

Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Declaration

IRowComparerCommand<TLeft, TRight> Asc(string columnName, StringComparer stringComparer)

Parameters

Type	Name	Description
String	columnName	Name of the left and right columns.
StringComparer	stringComparer	The StringComparer to use for the column comparison.

Returns

Type	Description
IRowComparerCommand<TLeft, TRight>	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<TLeftColumn, TRightColumn>(String, Comparison<TLeftColumn, TRightColumn>)

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

Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Declaration

IRowComparerCommand<TLeft, TRight> Asc<TLeftColumn, TRightColumn>(string columnName, Comparison<TLeftColumn, TRightColumn> columnComparison)

Parameters

Type	Name	Description
String	columnName	Name of the left and right columns.
Comparison<TLeftColumn, TRightColumn>	columnComparison	The column comparison.

Returns

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

Type Parameters

Name	Description
TLeftColumn	The type of the left column.
TRightColumn	The type of the right 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.

Asc<TLeftColumn, TRightColumn>(String, String, Comparison<TLeftColumn, TRightColumn>)

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

Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Declaration

IRowComparerCommand<TLeft, TRight> Asc<TLeftColumn, TRightColumn>(string leftColumnName, string rightColumnName, Comparison<TLeftColumn, TRightColumn> columnComparison)

Parameters

Type	Name	Description
String	leftColumnName	Name of the left column.
String	rightColumnName	Name of the right column.
Comparison<TLeftColumn, TRightColumn>	columnComparison	The column comparison.

Returns

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

Type Parameters

Name	Description
TLeftColumn	The type of the left column.
TRightColumn	The type of the right 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 pair in the comparison, with values evaluated in descending order.

Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Columns must have identical types (although nullability can differ). If this is not the case, use an overload that specifies the comparison explicitly.

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

Declaration

IRowComparerCommand<TLeft, TRight> Desc(string columnName)

Parameters

Type	Name	Description
String	columnName	Name of the left and right columns.

Returns

Type	Description
IRowComparerCommand<TLeft, TRight>	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: columns have different types. RowComparer: column type has no CompareTo() method.

Desc(String, String)

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

Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Columns must have identical types (although nullability can differ). If this is not the case, use an overload that specifies the comparison explicitly.

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

Declaration

IRowComparerCommand<TLeft, TRight> Desc(string leftColumnName, string rightColumnName)

Parameters

Type	Name	Description
String	leftColumnName	Name of the left column.
String	rightColumnName	Name of the right column.

Returns

Type	Description
IRowComparerCommand<TLeft, TRight>	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: columns have different types. RowComparer: column type has no CompareTo() method.

Desc(String, String, StringComparer)

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

Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Declaration

IRowComparerCommand<TLeft, TRight> Desc(string leftColumnName, string rightColumnName, StringComparer stringComparer)

Parameters

Type	Name	Description
String	leftColumnName	Name of the left column.
String	rightColumnName	Name of the right column.
StringComparer	stringComparer	The StringComparer to use for the column comparison.

Returns

Type	Description
IRowComparerCommand<TLeft, TRight>	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(String, StringComparer)

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

Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Declaration

IRowComparerCommand<TLeft, TRight> Desc(string columnName, StringComparer stringComparer)

Parameters

Type	Name	Description
String	columnName	Name of the left and right columns.
StringComparer	stringComparer	The StringComparer to use for the column comparison.

Returns

Type	Description
IRowComparerCommand<TLeft, TRight>	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<TLeftColumn, TRightColumn>(String, Comparison<TLeftColumn, TRightColumn>)

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

Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Declaration

IRowComparerCommand<TLeft, TRight> Desc<TLeftColumn, TRightColumn>(string columnName, Comparison<TLeftColumn, TRightColumn> columnComparison)

Parameters

Type	Name	Description
String	columnName	Name of the left and right columns.
Comparison<TLeftColumn, TRightColumn>	columnComparison	The column comparison.

Returns

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

Type Parameters

Name	Description
TLeftColumn	The type of the left column.
TRightColumn	The type of the right 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<TLeftColumn, TRightColumn>(String, String, Comparison<TLeftColumn, TRightColumn>)

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

Column name matching is ordinal case insensitive, but a case sensitive match takes precedence over a case insensitive match.

Declaration

IRowComparerCommand<TLeft, TRight> Desc<TLeftColumn, TRightColumn>(string leftColumnName, string rightColumnName, Comparison<TLeftColumn, TRightColumn> columnComparison)

Parameters

Type	Name	Description
String	leftColumnName	Name of the left column.
String	rightColumnName	Name of the right column.
Comparison<TLeftColumn, TRightColumn>	columnComparison	The column comparison.

Returns

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

Type Parameters

Name	Description
TLeftColumn	The type of the left column.
TRightColumn	The type of the right 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.