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;

Frédéric Hamidi · Accepted Answer · 2010-10-24 19:50:41Z

3

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
    };

edited Oct 24, 2010 at 19:50

answered Oct 24, 2010 at 7:40

Frédéric Hamidi

264k42 gold badges497 silver badges486 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joe Albahari · Accepted Answer · 2010-10-24 07:00:59Z

3

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

answered Oct 24, 2010 at 7:00

Joe Albahari

31.2k7 gold badges85 silver badges97 bronze badges

3 Comments

LIX Over a year ago

how can I cast it to data column ?

Joe Albahari Over a year ago

You could do this: this.Mapping.GetTable (typeof (Customer)).RowType.DataMembers.Select (dm => new DataColumn (dm.Name, dm.Type) { AllowDBNull = dm.CanBeNull })

LIX Over a year ago

I got an exception : DataSet does not support System.Nullable<>.

Collectives™ on Stack Overflow

get array of table columns in LINQ To SQL

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related