public string ToSprocDatatype()
{
StringBuilder sb = new StringBuilder(Datatype.ToString());
if (_TextTypes.Contains(Datatype.ToLower()))
{
string max = (MaxLength == -1) ? "MAX" : MaxLength.ToString();
sb.Append(String.Format("({0})", max));
}
//if (IsNullible)
//{
// sb.Append(" = NULL");
//}
return(sb.ToString());
}
public override string ToString()
{
StringBuilder sb = new StringBuilder(ColumnName + " (");
if (IsPrimaryKey)
{
sb.Append("PK, ");
}
sb.Append(Datatype.ToString());
if (_TextTypes.Contains(Datatype.ToLower()))
{
string max = (MaxLength == -1) ? "MAX" : MaxLength.ToString();
sb.Append(String.Format("({0})", max));
}
sb.Append((IsNullible) ? ", null)" : ", not null)");
return(sb.ToString());
}
