public string ConvertToSql(object value, DbType targetDbType)
{
if (targetDbType == DbType.DateTime)
{
return(string.Format(CultureInfo.InvariantCulture, "TO_DATE('{0}','DD-MON-YYYY HH24:MI:SS')",
((DateTime)value).ToString("dd-MMM-yyyy HH:mm:ss", CultureInfo.InvariantCulture)));
}
return(SqlScriptingHelper.ToSql(value, targetDbType, PrefixUnicodeLiterals));
}
public string ConvertToSql(object value, DbType targetDbType)
{
if (targetDbType == DbType.DateTime)
{
return(string.Format(CultureInfo.InvariantCulture, "TIMESTAMP '{0}'",
((DateTime)value).ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture)));
}
return(SqlScriptingHelper.ToSql(value, targetDbType));
}
public string ConvertToSql(object value, DbType targetDbType)
{
return(SqlScriptingHelper.ToSql(value, targetDbType, PrefixUnicodeLiterals));
}
public string ConvertToSql(object value, DbType targetDbType)
{
return(SqlScriptingHelper.ToSql(value, targetDbType));
}
