public override string CharIndex(MethodCallExpressionModel model)
{
return(string.Format("instr ({0},{1},1,1) ", model.Args[0].MemberName, model.Args[1].MemberName));
}
public override string ToTime(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" to_timestamp({0},'0000-01-01 hh24:mi:ss') ", parameter.MemberName));
}
public override string DateIsSameByType(MethodCallExpressionModel model)
{
throw new NotSupportedException("Oracle NotSupportedException DateIsSameDay");
}
public override string Length(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" LENGTH({0}) ", parameter.MemberName));
}
public override string ToString(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" CAST({0} AS VARCHAR2(4000))", parameter.MemberName));
}
public override string ToDate(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" to_date({0},'yyyy-mm-dd hh24:mi:ss')", parameter.MemberName));
}
public override string ToBool(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" CAST({0} AS SIGNED)", parameter.MemberName));
}
public override string ToDouble(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" CAST({0} AS DECIMAL(18,4))", parameter.MemberName));
}
public override string ToInt64(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" CAST({0} AS INTEGER)", parameter.MemberName));
}
public override string CharIndex(MethodCallExpressionModel model)
{
throw new NotSupportedException("Slqite Not Supported CharIndex");
}
public override string ToDate(MethodCallExpressionModel model)
{
var parameter = model.Args[0];
return(string.Format(" DATETIME({0})", parameter.MemberName));
}