title: Entity Framework - Get List of Tables
body: <p>That's it.  It's pretty simple.  I've got an edmx and want to be able to dynamically query it for tables and (hopefully), dynamically build against that table.  Is that possible?</p>
  
  <p>=========</p>
  
  <p>UPDATE:</p>
  
  <p>I've included all the DB tables, but no views or SP's, in the context.  We have lots of tables that type info (with id's).  So, for example, colors or file type or protocol type.  I want to be able to take a type (file) query for tables that might hold the type info (File, FileType) and return it with id.</p>
  
  <p>So, I may look for... Business Unit (or Color, or File) and the code would go off and search the context for BusinessUnit (or Color or File) and BusinessUnitType (or ColorType or FileType).  If it finds either one, it will query it and will return all the rows so I can see if this holds type information (I'll refine it later to only return ID and Description, Abbreviation or Name fields as well as limiting rows etc) and be able to find the associated ID for a particular whatever.</p>