Linq: Get a list of all tables within DataContext
It's much easier than above and no reflection required. Linq to SQL has a Mapping property that you can use to get an enumeration of all the tables.
context.Mapping.GetTables();
You can do this via reflection. Essentially, you iterate over the properties in your DataContext class. For each property, check to see if that property's generic parameter type has the TableAttribute attribute. If so, that property represents a table:
using System.Reflection;
using System.Data.Linq.Mappings;
PropertyInfo[] properties = typeof(MyDataContext).GetProperties();
foreach (PropertyInfo property in properties)
{
if(property.PropertyType.IsGenericType)
{
object[] attribs = property.PropertyType.GetGenericArguments()[0].GetCustomAttributes(typeof(TableAttribute), false);
if(attribs.Length > 0)
{
Console.WriteLine(property.Name);
}
}
}