Class TableAlias
Column accessors for a table addressed by name instead of by a mapped entity type (the
From("table") mode).
public class TableAlias
- Inheritance
-
TableAlias
- Inherited Members
- Extension Methods
Properties
this[string]
Gets the strongly typed accessor for columnName, or sets a value on the
column. Like the other members it is only meaningful inside a query expression.
public TableColumn this[string columnName] { get; set; }
Parameters
columnNamestringName of the column to read or write.
Property Value
Methods
GetBoolean(string)
Reads columnName as a Boolean in a query expression.
public bool GetBoolean(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetByte(string)
Reads columnName as an 8-bit unsigned integer in a query expression.
public byte GetByte(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetBytes(string)
Reads columnName as a byte array in a query expression.
public byte[] GetBytes(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
- byte[]
GetColumn(string)
Reads columnName as an untyped object in a query expression.
public object GetColumn(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetDateTime(string)
Reads columnName as a date/time value in a query expression.
public DateTime GetDateTime(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetDecimal(string)
Reads columnName as a decimal value in a query expression.
public decimal GetDecimal(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetDouble(string)
Reads columnName as a double-precision number in a query expression.
public double GetDouble(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetGuid(string)
Reads columnName as a GUID in a query expression.
public Guid GetGuid(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetInt16(string)
Reads columnName as a 16-bit integer in a query expression.
public short GetInt16(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetInt32(string)
Reads columnName as a 32-bit integer in a query expression.
public int GetInt32(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetInt64(string)
Reads columnName as a 64-bit integer in a query expression.
public long GetInt64(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetNullableBoolean(string)
Reads columnName as a nullable Boolean (null for a NULL value).
public bool? GetNullableBoolean(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
- bool?
GetNullableByte(string)
Reads columnName as a nullable 8-bit unsigned integer (null for a NULL value).
public byte? GetNullableByte(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
- byte?
GetNullableBytes(string)
Reads columnName as a nullable byte array (null for a NULL value).
public byte[]? GetNullableBytes(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
- byte[]
GetNullableDateTime(string)
Reads columnName as a nullable date/time value (null for a NULL value).
public DateTime? GetNullableDateTime(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetNullableDecimal(string)
Reads columnName as a nullable decimal value (null for a NULL value).
public decimal? GetNullableDecimal(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetNullableDouble(string)
Reads columnName as a nullable double-precision number (null for a NULL value).
public double? GetNullableDouble(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetNullableGuid(string)
Reads columnName as a nullable GUID (null for a NULL value).
public Guid? GetNullableGuid(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
- Guid?
GetNullableInt16(string)
Reads columnName as a nullable 16-bit integer (null for a NULL value).
public short? GetNullableInt16(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetNullableInt32(string)
Reads columnName as a nullable 32-bit integer (null for a NULL value).
public int? GetNullableInt32(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
- int?
GetNullableInt64(string)
Reads columnName as a nullable 64-bit integer (null for a NULL value).
public long? GetNullableInt64(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
- long?
GetNullableSingle(string)
Reads columnName as a nullable single-precision number (null for a NULL value).
public float? GetNullableSingle(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetNullableString(string)
Reads columnName as a nullable string (null for a NULL value).
public string? GetNullableString(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetSingle(string)
Reads columnName as a single-precision number in a query expression.
public float GetSingle(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetStream(string)
Selects columnName as a streaming binary column in a query expression. This
member is a query-expression marker only: the expression visitor recognises the call by its
MethodInfo and never invokes it. The projected column is read by
the ToStream terminal (a single LOB column) or by a row projection consumed by
ToAsyncEnumerable, both of which open the provider's GetStream accessor instead of
buffering the value. Invoking the member outside such a query throws.
public Stream GetStream(string columnName)
Parameters
columnNamestringName of the binary column to stream.
Returns
- Stream
Never returns; the call is only valid inside a query expression.
Remarks
The resulting stream is valid only until the enumerator advances to the next row
(MoveNext): the underlying reader is owned by the enumerator/command, so the value must
be consumed before the next step. On SQLite the command appends a trailing rowid
locator, so the source must be a rowid-bearing table; a provider without sequential access
throws NotSupportedException when the query is executed.
Exceptions
- NotSupportedException
Always thrown when the member is invoked directly rather than translated by a streaming terminal.
GetString(string)
Reads columnName as a string in a query expression.
public string GetString(string columnName)
Parameters
columnNamestringName of the column to read.
Returns
GetTextReader(string)
Selects columnName as a streaming text column in a query expression. This
member is a query-expression marker only: the expression visitor recognises the call by its
MethodInfo and never invokes it. The projected column is read by
the ToTextReader terminal (a single LOB column) or by a row projection consumed by
ToAsyncEnumerable, both of which open the provider's GetTextReader accessor instead
of buffering the value. Invoking the member outside such a query throws.
public TextReader GetTextReader(string columnName)
Parameters
columnNamestringName of the text column to stream.
Returns
- TextReader
Never returns; the call is only valid inside a query expression.
Remarks
The resulting reader is valid only until the enumerator advances to the next row
(MoveNext): the underlying reader is owned by the enumerator/command, so the value must
be consumed before the next step. A provider without sequential access throws
NotSupportedException when the query is executed. Chunked character reads
(GetChars) are intentionally not exposed yet: they need the provider's buffer/offset
overload, which is tracked separately (#100).
Exceptions
- NotSupportedException
Always thrown when the member is invoked directly rather than translated by a streaming terminal.