Type IProvider.GetColumnType(FoundationDbColumn dataColumnSchema)
{
var dbType = (DbType)dataColumnSchema.ProviderType;
Type type;
switch (dbType)
{
case DbType.DateTime:
type = typeof(DateTime);
break;
case DbType.String:
type = typeof(string);
break;
case DbType.Int32:
type = typeof(int);
break;
default:
type = typeof(object);
break;
}
return(type);
}
Type IProvider.GetColumnType(FoundationDbColumn column)
{
var oracleDbType = (OracleDbType)column.ProviderType;
Type type;
switch (oracleDbType)
{
case OracleDbType.Int16:
type = typeof(short);
break;
case OracleDbType.Int32:
type = typeof(int);
break;
case OracleDbType.Decimal:
type = typeof(object);
break;
case OracleDbType.Date:
type = typeof(object);
break;
case OracleDbType.Char:
case OracleDbType.Varchar2:
type = typeof(string);
break;
default:
type = typeof(object);
break;
}
return(type);
}
Type IProvider.GetColumnType(FoundationDbColumn column)
{
var oracleType = (OracleType)column.ProviderType;
var type = column.DataType;
return(type);
}
Type IProvider.GetColumnType(FoundationDbColumn dataColumnSchema)
{
// 11 INT int
// 12 BIGINT long
// 16 TEXT string
return(typeof(object));
}
Type IProvider.GetColumnType(FoundationDbColumn dataColumnSchema)
{
// TODO
//var dbType = (MySqlDbType)dataColumnSchema.ProviderType;
//int columnSize = dataColumnSchema.ColumnSize;
//Type type;
return(typeof(object));
}
Type IProvider.GetColumnType(FoundationDbColumn column)
{
var dbType = (SqlDbType)column.ProviderType;
var columnSize = column.ColumnSize;
Type type;
switch (dbType)
{
case SqlDbType.BigInt:
type = typeof(long);
break;
case SqlDbType.Bit:
type = typeof(bool);
break;
case SqlDbType.DateTime:
//type = typeof(DateTimeField); DataTableView does not work in edit mode
type = typeof(object);
break;
case SqlDbType.Int:
type = typeof(int);
break;
case SqlDbType.Char:
case SqlDbType.NChar:
case SqlDbType.VarChar:
case SqlDbType.NVarChar:
case SqlDbType.Text:
case SqlDbType.NText:
if (columnSize <= 8000)
{
type = typeof(string);
}
else
{
//type = typeof(StringField);
type = typeof(object);
}
break;
case SqlDbType.SmallInt:
type = typeof(short);
break;
default:
type = typeof(object);
break;
}
return(type);
}
Type IProvider.GetColumnType(FoundationDbColumn dataColumnSchema)
{
var dbType = (OleDbType)dataColumnSchema.ProviderType;
Type type;
switch (dbType)
{
default:
type = typeof(object);
break;
}
return(type);
}
Type IProvider.GetColumnType(FoundationDbColumn dataColumnSchema)
{
throw new NotImplementedException();
// System.Data.SqlServerCe.SqlCeType
// var sqlCeType = (SqlCeType)dataColumnSchema.ProviderType;
//SqlDbType sqlDbType = sqlCeType.SqlDbType;
//Type dataType;
//switch (sqlDbType)
//{
// case SqlDbType.Decimal:
// dataType = typeof (DecimalField);
// break;
// default:
// dataType = dataColumnSchema.DataType;
// break;
//}
//return dataType;
}
private static IDataFieldReader CreateDataFieldReader(IDataRecord dataRecord, FoundationDbColumn dataColumnSchema)
{
var columnOrdinal = dataColumnSchema.ColumnOrdinal;
var providerType = (SqlDbType)dataColumnSchema.ProviderType;
IDataFieldReader dataFieldReader;
switch (providerType)
{
case SqlDbType.BigInt:
case SqlDbType.Bit:
case SqlDbType.Udt:
case SqlDbType.Int:
case SqlDbType.SmallInt:
case SqlDbType.TinyInt:
case SqlDbType.UniqueIdentifier:
case SqlDbType.Real: //
dataFieldReader = new DefaultDataFieldReader(dataRecord, columnOrdinal);
break;
case SqlDbType.Float: //
dataFieldReader = new DoubleFieldReader(dataRecord, columnOrdinal);
break;
case SqlDbType.Char:
case SqlDbType.NChar:
case SqlDbType.VarChar:
case SqlDbType.NVarChar:
case SqlDbType.Text:
case SqlDbType.NText:
var columnSize = dataColumnSchema.ColumnSize;
if (columnSize <= SqlServerProvider.ShortStringSize)
{
dataFieldReader = new ShortStringFieldReader(dataRecord, columnOrdinal, providerType);
}
else
{
dataFieldReader = new LongStringFieldReader(dataRecord, columnOrdinal);
}
break;
case SqlDbType.Binary:
case SqlDbType.VarBinary:
case SqlDbType.Image:
case SqlDbType.Timestamp:
dataFieldReader = new BinaryDataFieldReader(dataRecord, columnOrdinal);
break;
case SqlDbType.Decimal:
dataFieldReader = new DefaultDataFieldReader(dataRecord, columnOrdinal);
break;
case SqlDbType.SmallDateTime:
dataFieldReader = new SmallDateTimeDataFieldReader(dataRecord, columnOrdinal);
break;
case SqlDbType.Date:
case SqlDbType.DateTime:
case SqlDbType.DateTime2:
dataFieldReader = new DateTimeDataFieldReader(dataRecord, columnOrdinal);
break;
case SqlDbType.DateTimeOffset:
dataFieldReader = new DateTimeOffsetDataFieldReader(dataRecord, columnOrdinal);
break;
case SqlDbType.Time:
dataFieldReader = new DefaultDataFieldReader(dataRecord, columnOrdinal);
break;
case SqlDbType.Money:
dataFieldReader = new MoneyDataFieldReader(dataRecord, columnOrdinal);
break;
case SqlDbType.Variant:
dataFieldReader = new VariantDataFieldReader(dataRecord, columnOrdinal);
break;
// case SqlDbType.Timestamp:
// dataFieldReader = new TimeStampDataFieldReader(dataRecord,columnOrdinal);
// break;
case SqlDbType.Xml:
dataFieldReader = new LongStringFieldReader(dataRecord, columnOrdinal);
break;
default:
throw new Exception();
}
return(dataFieldReader);
}
public Type GetColumnType(FoundationDbColumn dataColumnSchema)
{
throw new NotImplementedException();
}
Type IProvider.GetColumnType(FoundationDbColumn dataColumnSchema)
{
return(typeof(object));
}
private static DbQueryResultField ToField(FoundationDbColumn column)
{
return(new DbQueryResultField(column.ColumnName, column.DataType, column.AllowDbNull == true));
}
Type IProvider.GetColumnType(FoundationDbColumn dataColumnSchema) => dataColumnSchema.DataType;
Type IProvider.GetColumnType(FoundationDbColumn column)
{
throw new NotImplementedException();
}
Type IProvider.GetColumnType(FoundationDbColumn dataColumnSchema)
{
return(dataColumnSchema.DataType);
}