locked
DBML: Linq to SQL Classes - Master SysDatabases RRS feed

  • Question

  •  

    HI

     

    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?

     

    Thanks

     

    Griff

    Tuesday, April 29, 2008 9:49 AM

Answers

  • 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...

     

    --

    Patrice

    Tuesday, April 29, 2008 11:16 AM