protected static string GetCastSql(esCastType castType)
{
switch (castType)
{
case esCastType.Boolean: return("bool");
case esCastType.Byte: return("tinyint");
case esCastType.Char: return("char");
case esCastType.DateTime: return("timestamp");
case esCastType.Double: return("float8");
case esCastType.Decimal: return("numeric");
case esCastType.Guid: return("uuid");
case esCastType.Int16: return("int2");
case esCastType.Int32: return("int4");
case esCastType.Int64: return("int8");
case esCastType.Single: return("float4");
case esCastType.String: return("varchar");
default: return("error");
}
}
protected static string GetCastSql(esCastType castType)
{
switch (castType)
{
case esCastType.Boolean: return("bit");
case esCastType.Byte: return("tinyint");
case esCastType.Char: return("char");
case esCastType.DateTime: return("datetime");
case esCastType.Double: return("float");
case esCastType.Decimal: return("decimal");
case esCastType.Guid: return("uniqueidentifier");
case esCastType.Int16: return("smallint");
case esCastType.Int32: return("int");
case esCastType.Int64: return("bigint");
case esCastType.Single: return("real");
case esCastType.String: return("nvarchar");
default: return("error");
}
}
protected static string GetCastSql(esCastType castType)
{
switch (castType)
{
case esCastType.Boolean: return("Bit");
case esCastType.Byte: return("TinyInt");
case esCastType.Char: return("Char");
case esCastType.DateTime: return("DateTime");
case esCastType.Double: return("Float");
case esCastType.Decimal: return("Decimal");
case esCastType.Guid: return("UniqueIdentifier");
case esCastType.Int16: return("SmallInt");
case esCastType.Int32: return("Int");
case esCastType.Int64: return("BigInt");
case esCastType.Single: return("Real");
case esCastType.String: return("NVarChar");
default: return("error");
}
}
protected static string GetCastSql(esCastType castType)
{
switch (castType)
{
case esCastType.Char: return("CHAR");
case esCastType.DateTime: return("DATETIME");
case esCastType.Double: return("DECIMAL");
case esCastType.Decimal: return("DECIMAL");
case esCastType.Int16: return("SIGNED");
case esCastType.Int32: return("SIGNED");
case esCastType.Int64: return("SIGNED");
case esCastType.Single: return("DECIMAL");
case esCastType.String: return("CHAR");
default: return("error");
}
}
protected static string GetCastSql(esCastType castType)
{
switch (castType)
{
case esCastType.Boolean: return("NUMBER");
case esCastType.Byte: return("RAW");
case esCastType.Char: return("CHAR");
case esCastType.DateTime: return("TIMESTAMP");
case esCastType.Double: return("NUMBER");
case esCastType.Decimal: return("NUMBER");
case esCastType.Guid: return("RAW");
case esCastType.Int16: return("INTEGER");
case esCastType.Int32: return("INTEGER");
case esCastType.Int64: return("INTEGER");
case esCastType.Single: return("NUMBER");
case esCastType.String: return("VARCHAR2");
default: return("error");
}
}
protected static string GetCastSql(esCastType castType)
{
switch (castType)
{
case esCastType.Boolean: return "bit";
case esCastType.Byte: return "tinyint";
case esCastType.Char: return "char";
case esCastType.DateTime: return "datetime";
case esCastType.Double: return "float";
case esCastType.Decimal: return "decimal";
case esCastType.Guid: return "uniqueidentifier";
case esCastType.Int16: return "smallint";
case esCastType.Int32: return "int";
case esCastType.Int64: return "bigint";
case esCastType.Single: return "real";
case esCastType.String: return "nvarchar";
default: return "error";
}
}
protected static string GetCastSql(esCastType castType)
{
switch (castType)
{
case esCastType.Boolean: return "Bit";
case esCastType.Byte: return "TinyInt";
case esCastType.Char: return "Char";
case esCastType.DateTime: return "DateTime";
case esCastType.Double: return "Float";
case esCastType.Decimal: return "Decimal";
case esCastType.Guid: return "UniqueIdentifier";
case esCastType.Int16: return "SmallInt";
case esCastType.Int32: return "Int";
case esCastType.Int64: return "BigInt";
case esCastType.Single: return "Real";
case esCastType.String: return "NVarChar";
default: return "error";
}
}
protected static string GetCastSql(esCastType castType)
{
switch (castType)
{
case esCastType.Char: return "CHAR";
case esCastType.DateTime: return "DATETIME";
case esCastType.Double: return "DECIMAL";
case esCastType.Decimal: return "DECIMAL";
case esCastType.Int16: return "SIGNED";
case esCastType.Int32: return "SIGNED";
case esCastType.Int64: return "SIGNED";
case esCastType.Single: return "DECIMAL";
case esCastType.String: return "CHAR";
default: return "error";
}
}
protected static string GetCastSql(esCastType castType)
{
switch (castType)
{
case esCastType.Boolean: return "NUMBER";
case esCastType.Byte: return "RAW";
case esCastType.Char: return "CHAR";
case esCastType.DateTime: return "TIMESTAMP";
case esCastType.Double: return "NUMBER";
case esCastType.Decimal: return "NUMBER";
case esCastType.Guid: return "RAW";
case esCastType.Int16: return "INTEGER";
case esCastType.Int32: return "INTEGER";
case esCastType.Int64: return "INTEGER";
case esCastType.Single: return "NUMBER";
case esCastType.String: return "VARCHAR2";
default: return "error";
}
}
/// <summary>
/// Cast informs the DataProviders that a SQL CAST operation is needed. This overloaded version
/// of Cast is useful for Casting decimal types
/// </summary>
/// <remarks>
/// In C# you can cast with the overloaded cast operators, like this: (esString)query.Age
/// </remarks>
/// <param name="castType">The type of cast needed</param>
/// <returns>The very same esQueryItem now with Cast instructions</returns>
public esQueryItem Cast(esCastType castType, int precision, int scale)
{
esQuerySubOperator subOp = new esQuerySubOperator();
subOp.SubOperator = esQuerySubOperatorType.Cast;
subOp.Parameters["esCastType"] = castType;
subOp.Parameters["precision"] = precision;
subOp.Parameters["scale"] = scale;
this.AddSubOperator(subOp);
return this;
}
/// <summary>
/// Cast informs the DataProviders that a SQL CAST operation is needed. This overloaded version
/// of Cast is useful for Casting variable length character columns
/// </summary>
/// <remarks>
/// In C# you can cast with the overloaded cast operators, like this: (esString)query.Age
/// </remarks>
/// <param name="castType">The type of cast needed</param>
/// <returns>The very same esQueryItem now with Cast instructions</returns>
public esQueryItem Cast(esCastType castType, int length)
{
esQuerySubOperator subOp = new esQuerySubOperator();
subOp.SubOperator = esQuerySubOperatorType.Cast;
subOp.Parameters["esCastType"] = castType;
subOp.Parameters["length"] = length;
this.AddSubOperator(subOp);
return this;
}
