Breaking News: Grepper is joining You.com. Read the official announcement!

sql server data types to c# data type to oracle data type

PrashantUnity answered on January 19, 2023 Popularity 2/10 Helpfulness 9/10

answer sql server data types to c# data type to oracle data type

related oracle data type to c#

sql server data types to c# data type to oracle data type

Comment

Oracle          .Net Type       SqlServerType
BFile           byte[]          varbinary(max) With FileStream
Blob            byte[]          varbinary
Byte            byte            tinyint
Char            Char/String     char
Clob            String          varchar(max)
Date            DateTime        Date
Decimal         decimal         decimal/numeric
Double          double          float
Int16           Int16           smallint
Int32           int             int
Int64           long/Int64      bigint
Long            String          (n)varchar(max)
LongRaw         byte[]          varbinary(max)
NChar           String          nchar
NClob           String          nvarchar
NVarchar2       String          nvarchar
Raw             byte[]          varbinary
Single          single          real
TimeStamp       DateTime        datetime2
TimeStampLTZ    DateTime        datetimeoffset (i think)
TimeStampTZ     DateTime        datetimeoffset
Varchar2        String          varchar
XmlType         String          XML

Popularity 2/10 Helpfulness 9/10 Language sql

Source: stackoverflow.com

Tags: c# oracle sql sql-server types

Link to this answer
Share Copy Link

Contributed on Jan 19 2023

PrashantUnity

0 Answers Avg Quality 2/10

Closely Related Answers

oracle data type to c#

Comment

//suppose you are reading i th column then 
//you can acess data type like this
string baseColumnName = rdr.GetColumnSchema()[i].BaseColumnName;
string baseSchemaName = rdr.GetColumnSchema()[i].BaseSchemaName;

string baseTableName = rdr.GetColumnSchema()[i].BaseTableName;
string columnName = rdr.GetColumnSchema()[i].ColumnName;

int? columnSize = rdr.GetColumnSchema()[i].ColumnSize;
string dataType = rdr.GetColumnSchema()[i].DataType.Name;

bool? isAlias = rdr.GetColumnSchema()[i].IsAliased;
bool? isAutoIncrement = rdr.GetColumnSchema()[i].IsAutoIncrement;
bool? isExpression = rdr.GetColumnSchema()[i].IsExpression;
bool? isHidden = rdr.GetColumnSchema()[i].IsHidden;
bool? isIdentity = rdr.GetColumnSchema()[i].IsIdentity;
bool? isKey = rdr.GetColumnSchema()[i].IsKey;
bool? isLong = rdr.GetColumnSchema()[i].IsLong;
bool? isReadOnly = rdr.GetColumnSchema()[i].IsReadOnly;
bool? isUnique = rdr.GetColumnSchema()[i].IsUnique;
int? numericPrecision= rdr.GetColumnSchema()[i].NumericPrecision;
int? numericScale = rdr.GetColumnSchema()[i].NumericScale;
string? udtAssemblyQualifiedName = rdr.GetColumnSchema()[i].UdtAssemblyQualifiedName;

Popularity 1/10 Helpfulness 8/10 Language csharp

Source: Grepper

Tags: oracle c#

Link to this answer
Share Copy Link

Contributed on Jan 19 2023

PrashantUnity

0 Answers Avg Quality 2/10

sql server data types to c# data type to oracle data type

Contents

More Related Answers

sql server data types to c# data type to oracle data type

Closely Related Answers

oracle data type to c#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.