public static string GetSqlType(this Column column, Dialect dialect)
{
if (!String.IsNullOrWhiteSpace(column.SqlType))
{
return column.SqlType;
}
return dialect.GetTypeName(column.SqlTypeCode);
}
/// <summary>
/// The SQL required to create the database objects for a TableGenerator.
/// </summary>
/// <param name="dialect">The <see cref="Dialect"/> to help with creating the sql.</param>
/// <returns>
/// An array of <see cref="String"/> objects that contain the Dialect specific sql to
/// create the necessary database objects and to create the first value as <c>1</c>
/// for the TableGenerator.
/// </returns>
public string[] SqlCreateStrings(Dialect.Dialect dialect)
{
// changed the first value to be "1" by default since an uninitialized Int32 is 0 - leaving
// it at 0 would cause problems with an unsaved-value="0" which is what most people are
// defaulting <id>'s with Int32 types at.
return new string[]
{
"create table " + tableName + " ( " + columnName + " " + dialect.GetTypeName(columnSqlType) + " )",
"insert into " + tableName + " values ( 1 )"
};
}