/// <summary> /// Returns the syntax to get the data type of a field from a DataReader object. /// Currently only used with Velocity generator. /// </summary> /// <param name="field">Field whose reader syntax is needed.</param> /// <returns>Reader syntax to use.</returns> public String GetReaderString(PropertyElement field) { String readerMethod = String.Format(field.Column.SqlType.ReaderMethodFormat, "dataReader", field.Column.Name); if (field.Type.ConvertFromSqlTypeFormat.Length > 0) { readerMethod = String.Format(field.Type.ConvertFromSqlTypeFormat, "data", field.GetMethodFormat(), readerMethod, "dataReader", field.Column.Name); } return(readerMethod); }
public String CreateSqlParameter(Boolean output, Boolean useDataObject) { StringBuilder sb = new StringBuilder(); sb.Append("cmd.Parameters.Add(new SqlParameter(\"@" + column.Name + "\", SqlDbType." + column.SqlType.SqlDbType + ", " + column.Length + ", ParameterDirection."); if (output) { sb.Append("Output"); } else { sb.Append("Input"); } sb.Append(", false, " + column.Precision + ", " + column.Scale + ", \"" + name + "\", DataRowVersion.Proposed, "); if (useDataObject) { sb.Append(String.Format(property.Type.ConvertToSqlTypeFormat, "data", "data." + Name, "", "", property.GetMethodFormat())); } else { sb.Append(String.Format(property.Type.ConvertToSqlTypeFormat, "", property.GetFieldFormat(), "", "", property.GetFieldFormat())); } sb.Append("));" + Environment.NewLine); return(sb.ToString()); }