DBML: Linq to SQL Classes - Master SysDatabases RRS feed

  • Question




    In the VS 2008 IDE, if I create a Data Connection to a SQL Server's master database, I can't then drill into the system tables to find the sysdatabases table.  I want to create a dbml file for this database (so that I can use LINQ to retrieve all the user databases on the SQL Server).  I've got around this by coding a class manually ...


    Is this possible?





    Tuesday, April 29, 2008 9:49 AM


  • Likely because system objects are ignored. Have you tried to select from those system objects inside your own user defined views. Those views should be then taken into account by the designer...




    Tuesday, April 29, 2008 11:16 AM