get array of table columns in LINQ To SQL

Question

How to get an array of data columns via LINQ To SQL? I'm 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
    };