public sealed class SpannerDbTypeRepresents a Type that can be stored in a Spanner column or returned from a query.
Namespace
Google.Cloud.Spanner.DataAssembly
Google.Cloud.Spanner.Data.dll
Properties
Bool
public static SpannerDbType Bool { get; }true or false.
| Property Value | |
|---|---|
| Type | Description |
SpannerDbType | |
Bytes
public static SpannerDbType Bytes { get; }A byte array (byte[]).
| Property Value | |
|---|---|
| Type | Description |
SpannerDbType | |
Date
public static SpannerDbType Date { get; }A Date.
| Property Value | |
|---|---|
| Type | Description |
SpannerDbType | |
DbType
public DbType DbType { get; }The corresponding DbType for this Cloud Spanner type.
| Property Value | |
|---|---|
| Type | Description |
DbType | |
DefaultClrType
public Type DefaultClrType { get; }The default Type for this Cloud Spanner type.
| Property Value | |
|---|---|
| Type | Description |
Type | |
Float64
public static SpannerDbType Float64 { get; }64 bit floating point number. This is equivalent to Float8 in the PostgreSQL dialect.
| Property Value | |
|---|---|
| Type | Description |
SpannerDbType | |
Int64
public static SpannerDbType Int64 { get; }64 bit signed integer.
| Property Value | |
|---|---|
| Type | Description |
SpannerDbType | |
Json
public static SpannerDbType Json { get; }A JSON-formatted string as described in RFC 7159.
| Property Value | |
|---|---|
| Type | Description |
SpannerDbType | |
Numeric
public static SpannerDbType Numeric { get; }A fixed-point number with 29 decimal digits of precision in the whole component and 9 decimal digits of precision in the fractional component.
| Property Value | |
|---|---|
| Type | Description |
SpannerDbType | |
PgNumeric
public static SpannerDbType PgNumeric { get; }Representation of PostgreSQL numeric type. The PostgreSQL numeric type has max precision of 147,455 and a max scale of 16383.
| Property Value | |
|---|---|
| Type | Description |
SpannerDbType | |
Size
public int? Size { get; }The size of the Type, if set.
| Property Value | |
|---|---|
| Type | Description |
Nullable<Int32> | |
String
public static SpannerDbType String { get; }A string.
| Property Value | |
|---|---|
| Type | Description |
SpannerDbType | |
Timestamp
public static SpannerDbType Timestamp { get; }Date and Time.
| Property Value | |
|---|---|
| Type | Description |
SpannerDbType | |
Unspecified
public static SpannerDbType Unspecified { get; }Not specified.
| Property Value | |
|---|---|
| Type | Description |
SpannerDbType | |
Methods
ArrayOf(SpannerDbType)
public static SpannerDbType ArrayOf(SpannerDbType elementType)Creates an array of the specified type. This can be done on any arbitrary SpannerDbType.
You may use any type that implements IEnumerable as a source for the array. The type of each
item is determined by elementType.
When calling GetFieldValue<T>(String) the default type
is List<T>. You may, however, specify any type that implements IList which
has a default constructor.
| Parameter | |
|---|---|
| Name | Description |
elementType | SpannerDbTypeThe type of each item in the array. |
| Returns | |
|---|---|
| Type | Description |
SpannerDbType | |
FromClrType(Type)
public static SpannerDbType FromClrType(Type type)Returns a SpannerDbType given a ClrType. If the type cannot be determined, Unspecified is returned.
| Parameter | |
|---|---|
| Name | Description |
type | TypeThe clrType to convert. |
| Returns | |
|---|---|
| Type | Description |
SpannerDbType | The best Spanner representation of the given Clr Type. |
GetHashCode()
public override int GetHashCode()| Returns | |
|---|---|
| Type | Description |
Int32 | |
ToString()
public override string ToString()| Returns | |
|---|---|
| Type | Description |
String | |
TryParse(String, out SpannerDbType)
public static bool TryParse(string spannerType, out SpannerDbType spannerDbType)Given a string representation, returns an instance of SpannerDbType.
| Parameters | |
|---|---|
| Name | Description |
spannerType | StringA string representation of a SpannerDbType. See ToString(). |
spannerDbType | SpannerDbTypeIf parsing was successful, then an instance of SpannerDbType. Otherwise null. |
| Returns | |
|---|---|
| Type | Description |
Boolean | True if the parse was successful. |
WithSize(Int32)
public SpannerDbType WithSize(int size)| Parameter | |
|---|---|
| Name | Description |
size | Int32Represents the number of characters (for String) or bytes (for Bytes) |
| Returns | |
|---|---|
| Type | Description |
SpannerDbType | A new instance of SpannerDbType with the same Google.Cloud.Spanner.Data.SpannerDbType.TypeCode and new size. |