Ejemplo n.º 1
0
 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));
 }
Ejemplo n.º 2
0
 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));
 }
Ejemplo n.º 3
0
 public string ConvertToSql(object value, DbType targetDbType)
 {
     return(SqlScriptingHelper.ToSql(value, targetDbType, PrefixUnicodeLiterals));
 }
Ejemplo n.º 4
0
 public string ConvertToSql(object value, DbType targetDbType)
 {
     return(SqlScriptingHelper.ToSql(value, targetDbType));
 }