getting strongly typed column names from datacontext

Question

Is it possible to get the column names directly from a datacontext? Below I'm just hard coding the DataTextField and DataValueField, but I'd like to be able to get them from the datacontext if possible. What is the recommended way of getting the column names in a strongly-typed way?

DataClassesDataContext db = new DataClassesDataContext(WebConfigurationManager.ConnectionStrings[connstring].ConnectionString);

        drdPriority.DataSource = db.Tasks;
        drdPriority.DataTextField = "TaskDescription";
        drdPriority.DataValueField = "TaskId";
        drdPriority.DataBind();

Answer 1

Try the following code:

      using (DataContext1.DataContext1 dc = new DataContext1.DataContext1()) { 
        var q = dc.Mapping.GetTables(); 
        foreach (System.Data.Linq.Mapping.MetaTable table in q) { 
          List names = new List(); 
          foreach (System.Data.Linq.Mapping.MetaDataMember member in table.RowType.DataMembers) { 
            names.Add(member.Name); 
          }
          //Process the names here 
        }