C# (CSharp) MigSharp.Providers SqlScriptingHelper.ToSql Examples

ToSql() private method

private ToSql ( object value, DbType dbType, bool prefixUnicodeLiterals ) : string
value	object
dbType	DbType
prefixUnicodeLiterals	bool
return	string

Example #1

 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));
 }

Example #2

 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));
 }

Example #3

File: MySqlProvider.cs Project: pkradioman/MigSharp

 public string ConvertToSql(object value, DbType targetDbType)
 {
     return(SqlScriptingHelper.ToSql(value, targetDbType, PrefixUnicodeLiterals));
 }

Example #4

File: SQLiteProvider.cs Project: richardprior/MigSharp

 public string ConvertToSql(object value, DbType targetDbType)
 {
     return(SqlScriptingHelper.ToSql(value, targetDbType));
 }