none
LINQ to SQL and synonyms RRS feed

  • Question

  • Hi,

     

    I have a problem in that I can't add a synonym to the LINQ to SQL designer in Visual Studio, even though in the properties, it knows that the base object is a stored procedure.

     

    The problem is that I'm using linked servers, and I'm using synonyms to map the various stored procedures from my linked databases.

     

    Is the only workaround here to write stored procedures in my database which then invoke the stored procedures on the linked databases?

     

    This seems like an artificial limitation to me...

     

    Thanks,

     

    Jessica

    Friday, May 9, 2008 1:44 AM

Answers

  • At this time, writing wrapper stored procedures is probably your best option.

     

    Thanks,

     

    --Samir

     

     

    Friday, May 9, 2008 11:09 PM