Get an array of table columns in LINQ To SQL

Question

How to get an array of data columns via LINQ to SQL? I am looking for something like this:

DataColumn[] dc = DataContext.Table.Columns;  

Answer 1

Try:

var dataColumns =
    from member in yourDataContext.Mapping.GetMetaType(typeof(YourMappedType)).DataMembers
    select new DataColumn {
        ColumnName = member.MappedName,
        DataType = (
            member.Type.IsGenericType && member.Type.GetGenericTypeDefinition() == typeof(Nullable<>)
                ? new NullableConverter(member.Type).UnderlyingType
                : member.Type
        ),
        AllowDBNull = member.CanBeNull
    };

Answer 2

myDataContext.Mapping.GetTable (typeof (Customer)).RowType.DataMembers