Linq to SQL data context has missing entities/tables

When adding a new connection to my L2S DataContext in my assembly, not all the entities/tables are shown? +-80 are there, but a lot are missing. Any ideas why? DataContext is a generated DBML

PS - when LINQPad generates a DataContext for me from the database, they all show up.

Comments

  • Can you query the missing tables? And have you checked that you can also successfully query them in Visual Studio?
  • The tables are accessible from SSMS and VS, and are accessible from the DataContext when running the website.
    I am taking existing, working LINQ query on the DataContext from the website, and trying to execute it in LINQPad (I want to rework the query and check the resultant SQL generated)