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