/// <summary>
/// SQL-92, page 262<br/>
/// Note that setting oracleNullExtension to true will make the query non-compliant
/// </summary>
private string _ColumnDefinition(ColumnDescription description, ColumnSpecific columnSpecific, Specific specific)
{
return(string.Format(
"{0} {1} {2} {3} {4}",
nameEscaper(description.column.columnName), //column name
description.options.type, //data type | domain name
(description.options.defaultValue != null) ? "DEFAULT " + description.options.defaultValue : "", //NOTE possible SQL injection here! //default clause
String.Join(
" ",
Enumerable.Empty <string>()
.ConcatScalar(description.options.isNotNull ? "NOT NULL" : ((specific & Specific.OracleNullExtension) == Specific.OracleNullExtension ? "NULL" : null))
.ConcatScalar((columnSpecific & ColumnSpecific.PrimaryKey) == ColumnSpecific.PrimaryKey ? "PRIMARY KEY" : null)
.ToArray()
), //column constraint definition
"" //collate clause
));
}
/// <summary>
/// SQL-92, page 262<br/>
/// Note that setting oracleNullExtension to true will make the query non-compliant
/// </summary>
private string _ColumnDefinition(ColumnDescription description, ColumnSpecific columnSpecific, Specific specific)
{
return string.Format(
"{0} {1} {2} {3} {4}",
nameEscaper(description.column.columnName), //column name
description.options.type, //data type | domain name
(description.options.defaultValue != null) ? "DEFAULT " + description.options.defaultValue : "", //NOTE possible SQL injection here! //default clause
String.Join(
" ",
Enumerable.Empty<string>()
.ConcatScalar(description.options.isNotNull ? "NOT NULL" : ((specific & Specific.OracleNullExtension) == Specific.OracleNullExtension ? "NULL" : null))
.ConcatScalar((columnSpecific & ColumnSpecific.PrimaryKey) == ColumnSpecific.PrimaryKey ? "PRIMARY KEY" : null)
.ToArray()
), //column constraint definition
"" //collate clause
);
}
