Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
is it possible with Linq to SQL

Answered is it possible with Linq to SQL

  • Sunday, November 18, 2012 2:11 PM
     
     
    Sign In to Vote
    0

    Right now I have an SSIS package that runs every morning and gives me a report on the number of packages that failed or succeeded from the day before. The information for these packages is contained partly within the sysjobs table (a system table) within the msdb database (a system database) in SQL Server 2005.

    When trying to move the package to a C# executable (mostly to gain better formatting over the email that gets sent out), I wasn't able to find a way to create a dbml file that allowed me to access these tables through Linq. I tried to look for any properties that would make these tables visible, but I haven't had much luck.

    Does anyone know if this is possible with Linq to SQL?

     

All Replies

  • Monday, November 19, 2012 7:57 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Katrina,

    If you're in Server Explorer, you can make them visible this way:
     •Create a connection to the server you want.
     •Right-click the server and choose Change View > Object Type.
     •You should now see System Tables and User Tables. You should see sysjobs there, and you can easily drag it onto a .dbml surface.

    Iric Wen

    TechNet Community Support