Search Results for

    Show / Hide Table of Contents

    Class NpgsqlDbColumn

    Provides schema information about a column.

    Inheritance
    Object
    DbColumn
    NpgsqlDbColumn
    Inherited Members
    DbColumn.IsExpression
    DbColumn.IsHidden
    DbColumn.IsIdentity
    Object.Equals(Object)
    Object.Equals(Object, Object)
    Object.GetHashCode()
    Object.GetType()
    Object.MemberwiseClone()
    Object.ReferenceEquals(Object, Object)
    Object.ToString()
    Namespace: Npgsql.Schema
    Assembly: Npgsql.dll
    Syntax
    public class NpgsqlDbColumn : DbColumn
    Remarks

    Note that this can correspond to a field returned in a query which isn't an actual table column

    See https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable(v=vs.110).aspx for information on the meaning of the different fields.

    Constructors

    NpgsqlDbColumn()

    Initializes a new instance of the NpgsqlDbColumn class.

    Declaration
    public NpgsqlDbColumn()

    Properties

    AllowDBNull

    Declaration
    public bool? AllowDBNull { get; protected set; }
    Property Value
    Type Description
    Nullable<Boolean>

    BaseCatalogName

    Declaration
    public string BaseCatalogName { get; protected set; }
    Property Value
    Type Description
    String

    BaseColumnName

    Declaration
    public string BaseColumnName { get; protected set; }
    Property Value
    Type Description
    String

    BaseSchemaName

    Declaration
    public string BaseSchemaName { get; protected set; }
    Property Value
    Type Description
    String

    BaseServerName

    Declaration
    public string BaseServerName { get; protected set; }
    Property Value
    Type Description
    String

    BaseTableName

    Declaration
    public string BaseTableName { get; protected set; }
    Property Value
    Type Description
    String

    ColumnAttributeNumber

    The column's position within its table. Note that this is different from ColumnOrdinal, which is the column's position within the resultset.

    Declaration
    public short? ColumnAttributeNumber { get; }
    Property Value
    Type Description
    Nullable<Int16>

    ColumnName

    Declaration
    public string ColumnName { get; protected set; }
    Property Value
    Type Description
    String

    ColumnOrdinal

    Declaration
    public int? ColumnOrdinal { get; protected set; }
    Property Value
    Type Description
    Nullable<Int32>

    ColumnSize

    Declaration
    public int? ColumnSize { get; protected set; }
    Property Value
    Type Description
    Nullable<Int32>

    DataType

    Declaration
    public Type DataType { get; protected set; }
    Property Value
    Type Description
    Type

    DataTypeName

    Declaration
    public string DataTypeName { get; protected set; }
    Property Value
    Type Description
    String

    DefaultValue

    The default SQL expression for this column.

    Declaration
    public string DefaultValue { get; }
    Property Value
    Type Description
    String

    IsAliased

    Declaration
    public bool? IsAliased { get; protected set; }
    Property Value
    Type Description
    Nullable<Boolean>

    IsAutoIncrement

    Declaration
    public bool? IsAutoIncrement { get; protected set; }
    Property Value
    Type Description
    Nullable<Boolean>

    IsKey

    Declaration
    public bool? IsKey { get; protected set; }
    Property Value
    Type Description
    Nullable<Boolean>

    IsLong

    Declaration
    public bool? IsLong { get; protected set; }
    Property Value
    Type Description
    Nullable<Boolean>

    IsReadOnly

    Declaration
    public bool? IsReadOnly { get; protected set; }
    Property Value
    Type Description
    Nullable<Boolean>

    IsUnique

    Declaration
    public bool? IsUnique { get; protected set; }
    Property Value
    Type Description
    Nullable<Boolean>

    Item[String]

    Declaration
    public override object this[string propertyName] { get; }
    Parameters
    Type Name Description
    String propertyName
    Property Value
    Type Description
    Object
    Overrides
    DbColumn.Item[String]

    NpgsqlDbType

    The NpgsqlDbType value for this column's type.

    Declaration
    public NpgsqlDbType? NpgsqlDbType { get; }
    Property Value
    Type Description
    Nullable<NpgsqlDbType>

    NumericPrecision

    Declaration
    public int? NumericPrecision { get; protected set; }
    Property Value
    Type Description
    Nullable<Int32>

    NumericScale

    Declaration
    public int? NumericScale { get; protected set; }
    Property Value
    Type Description
    Nullable<Int32>

    PostgresType

    The PostgresType describing the type of this column.

    Declaration
    public PostgresType PostgresType { get; }
    Property Value
    Type Description
    PostgresType

    TableOID

    The OID of the PostgreSQL table of this column.

    Declaration
    public uint TableOID { get; }
    Property Value
    Type Description
    UInt32

    TypeOID

    The OID of the type of this column in the PostgreSQL pg_type catalog table.

    Declaration
    public uint TypeOID { get; }
    Property Value
    Type Description
    UInt32

    UdtAssemblyQualifiedName

    Declaration
    public string UdtAssemblyQualifiedName { get; protected set; }
    Property Value
    Type Description
    String
    In This Article
    Back to top © Copyright 2022 The Npgsql Development Team