private static string Join(ColumnDefinition column, string divider, string template)
{
var columns = new List<ColumnDefinition>();
columns.Add(column);
return Join(columns, divider, template);
}
/// <summary>
/// Verifies that if the proc is optimistic, then there is a timestamp column.
/// </summary>
/// <param name="optimistic">True if it is an optimistic proc.</param>
/// <param name="timestamp">The timestamp column if there is one. </param>
private void VerifyOptimisticTimestamp(bool optimistic, ColumnDefinition timestamp)
{
if (optimistic && timestamp == null)
throw new SchemaException(String.Format(CultureInfo.InvariantCulture, "Cannot find a timestamp column on Table {0} for concurrency checking", _tableName));
}
/// <summary>
/// Return the column definitions for a table.
/// </summary>
/// <param name="tableName">The name of the table.</param>
/// <returns>The definitions of the columns in the table.</returns>
public IList<ColumnDefinition> GetColumns(SqlName tableName)
{
List<ColumnDefinition> columns = new List<ColumnDefinition>();
// get the schema of the table and the primary key
string schemaSql = String.Format(CultureInfo.InvariantCulture, @"
SELECT c.name, type_name=t.name, c.max_length, c.precision, c.scale, is_identity, is_readonly = is_identity | is_computed, c.is_nullable,
is_key = CASE WHEN pk.column_id IS NOT NULL THEN 1 ELSE 0 END,
has_default = CASE WHEN c.default_object_id <> 0 THEN 1 ELSE 0 END
FROM sys.columns c
JOIN sys.types t ON (c.user_type_id = t.user_type_id AND t.is_user_defined = 0)
LEFT JOIN (
SELECT ic.object_id, ic.column_id
FROM sys.index_columns ic
JOIN sys.indexes i ON (ic.object_id = i.object_id AND ic.index_id = i.index_id)
WHERE i.is_primary_key = 1
) AS pk ON (c.object_id = pk.object_id AND c.column_id = pk.column_id)
WHERE c.object_id = OBJECT_ID('{0}')
", tableName.SchemaQualifiedTable);
using (IDataReader reader = _connection.GetReaderSql(schemaSql))
{
while (reader.Read())
{
ColumnDefinition column = new ColumnDefinition()
{
Name = reader["name"].ToString(),
SqlType = reader["type_name"].ToString(),
IsKey = Convert.ToBoolean(reader["is_key"], CultureInfo.InvariantCulture),
IsIdentity = Convert.ToBoolean(reader["is_identity"], CultureInfo.InvariantCulture),
IsReadOnly = Convert.ToBoolean(reader["is_readonly"], CultureInfo.InvariantCulture),
IsUpdateNullable = Convert.ToBoolean(reader["is_nullable"], CultureInfo.InvariantCulture),
HasDefault = Convert.ToBoolean(reader["has_default"], CultureInfo.InvariantCulture),
};
switch (column.SqlType)
{
case "char":
case "nchar":
case "varchar":
case "nvarchar":
case "binary":
case "varbinary":
column.SqlType += String.Format(CultureInfo.InvariantCulture, "({0})", GetColumnLength(column.SqlType, Int32.Parse(reader["max_length"].ToString(), CultureInfo.InvariantCulture)));
break;
case "decimal":
case "numeric":
column.SqlType += String.Format(CultureInfo.InvariantCulture, "({0}, {1})", reader["precision"].ToString(), reader["scale"].ToString());
break;
case "float":
column.SqlType += String.Format(CultureInfo.InvariantCulture, "({0})", reader["precision"].ToString());
break;
case "real":
break;
case "rowversion":
case "timestamp":
column.IsReadOnly = true;
column.IsRowVersion = true;
column.IsUpdateNullable = true;
break;
}
columns.Add(column);
}
}
return columns;
}
