DapperMatic

Appearance

DmJoinSelect`1 ​

Namespace: MJCZone.DapperMatic.Dml

Assembly: MJCZone.DapperMatic

Summary ​

Joined rows read as something else: the rows' columns, their related rows' columns and values over related rows read by the database, and the rest of the selector run in .NET.

sealed public

Contents ​

Methods (9)

Methods ​

MethodSummary
DistinctReturns each distinct result once, as the database compares what the selector reads.
ToListAsyncReads the results.
FirstAsyncReads the first result: in the query's order, or the first model's key order if it has none.
SingleAsyncReads the one result the query returns.
ToSqlWrites the SQL that CancellationToken) runs, without running it....
GetType
ToString
Equals
GetHashCode

Distinct ​

Returns each distinct result once, as the database compares what the selector reads.

csharp
DmJoinSelect<TResult> Distinct()

Returns ​

Type: DmJoinSelect<TResult>

The query.

ToListAsync ​

Reads the results.

csharp
Task&lt;List&lt;TResult&gt;&gt; ToListAsync(
    IDbTransaction tx,
    CancellationToken cancellationToken)

Parameters ​

  • tx (IDbTransaction) - The transaction to use, or null.
  • cancellationToken (CancellationToken) - The cancellation token.

Returns ​

Type: Task&lt;List&lt;TResult&gt;&gt;

The results.

FirstAsync ​

Reads the first result: in the query's order, or the first model's key order if it has none.

csharp
Task&lt;TResult?&gt; FirstAsync(
    IDbTransaction tx,
    CancellationToken cancellationToken)

Parameters ​

  • tx (IDbTransaction) - The transaction to use, or null.
  • cancellationToken (CancellationToken) - The cancellation token.

Returns ​

Type: Task&lt;TResult?&gt;

The result, or the default if there is none.

SingleAsync ​

Reads the one result the query returns.

csharp
Task&lt;TResult?&gt; SingleAsync(
    IDbTransaction tx,
    CancellationToken cancellationToken)

Parameters ​

  • tx (IDbTransaction) - The transaction to use, or null.
  • cancellationToken (CancellationToken) - The cancellation token.

Returns ​

Type: Task&lt;TResult?&gt;

The result, or the default if there is none.

ToSql ​

Writes the SQL that CancellationToken) runs, without running it.

csharp
DmStatement ToSql()

Returns ​

Type: DmStatement

The SQL and its parameters.

GetType ​

csharp
GetType()

ToString ​

csharp
ToString()

Equals ​

csharp
Equals()

GetHashCode ​

csharp
GetHashCode()