Linq: Get a list of all tables within DataContext

.net linq asp.net-3.5 datacontext
Sergey picture Sergey · Apr 10, 2009 · Viewed 12.5k times · Source

I have a DataContext (Linq to Sql) with over 100 tables, is it possible to get a list of all those tables and lets say print them to the console? This might be a silly question.

Thanks.

Answer

Jacob Proffitt picture Jacob Proffitt · Apr 10, 2009

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();

Related questions

LINQ query on a DataTable

I'm trying to perform a LINQ query on a DataTable object and bizarrely I am finding that performing such queries on DataTables is not straightforward. For example: var results = from myRow in myDataTable where results.Field("RowNo") == 1 select results; This …

Read More
Using LINQ to remove elements from a List<T>

Say that I have LINQ query such as: var authors = from x in authorsList where x.firstname == "Bob" select x; Given that authorsList is of type List<Author>, how can I delete the Author elements from authorsList that …

Read More
Group By Multiple Columns

How can I do GroupBy Multiple Columns in LINQ Something similar to this in SQL: SELECT * FROM <TableName> GROUP BY <Column1>,<Column2> How can I convert this to LINQ: QuantityBreakdown ( MaterialID int, ProductID int, …

Read More