public virtual string[] SqlCreateStrings(Dialect.Dialect dialect)
{
string createString = dialect.CreateTableString + " " + TableName
+ " ( "
+ SegmentColumnName + " " + dialect.GetTypeName(SqlTypes.SqlTypeFactory.GetAnsiString(SegmentValueLength)) + " not null, "
+ ValueColumnName + " " + dialect.GetTypeName(SqlTypes.SqlTypeFactory.Int64) + ", "
+ dialect.PrimaryKeyString + " ( " + SegmentColumnName + ") "
+ ")";
return(new string[] { createString });
}
private string GetDialectTypeName(Dialect.Dialect dialect, IMapping mapping)
{
if (IsCaracteristicsDefined())
{
// NH-1070 (the size should be 0 if the precision is defined)
return(dialect.GetTypeName(GetSqlTypeCode(mapping), (!IsPrecisionDefined()) ? Length:0, Precision, Scale));
}
else
{
return(dialect.GetTypeName(GetSqlTypeCode(mapping)));
}
}
private string GetDialectTypeName(Dialect.Dialect dialect, IMapping mapping)
{
if (IsCaracteristicsDefined())
{
// NH-1070: the size should be 0 if the precision or scale is defined.
return(dialect.GetTypeName(
GetSqlTypeCode(mapping),
IsPrecisionDefined() || IsScaleDefined() ? 0 : Length,
Precision, Scale));
}
else
{
return(dialect.GetTypeName(GetSqlTypeCode(mapping)));
}
}
public virtual string[] SqlCreateStrings(Dialect.Dialect dialect)
{
return(new String[]
{
"create table " + tableName + " ( " + valueColumnName + " " + dialect.GetTypeName(SqlTypeFactory.Int64)
+ " )", "insert into " + tableName + " values ( " + initialValue + " )"
});
}
/// <summary>
/// Gets the name of the data type for the column.
/// </summary>
/// <param name="dialect">The <see cref="Dialect.Dialect"/> to use to get the valid data types.</param>
/// <param name="mapping"></param>
/// <returns>
/// The name of the data type for the column.
/// </returns>
/// <remarks>
/// If the mapping file contains a value of the attribute <c>sql-type</c> this will
/// return the string contained in that attribute. Otherwise it will use the
/// typename from the <see cref="Dialect.Dialect"/> of the <see cref="SqlType"/> object.
/// </remarks>
public string GetSqlType(Dialect.Dialect dialect, IMapping mapping)
{
if (sqlType == null)
{
SqlType sqlTypeObject = GetAutoSqlType(mapping);
if (Length != DefaultPropertyLength)
{
return(dialect.GetTypeName(sqlTypeObject, Length));
}
else
{
return(dialect.GetTypeName(sqlTypeObject));
}
}
else
{
return(sqlType);
}
}
/// <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 virtual 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[]
{
"create table " + tableName + " ( " + columnName + " " + dialect.GetTypeName(columnSqlType) + " )",
"insert into " + tableName + " values ( 1 )"
});
}
public bool SupportsSqlType(SqlType sqlType)
{
try
{
_dialect.GetTypeName(sqlType);
return(true);
}
catch
{
return(false);
}
}