I think there is something wrong with Linq to sql.
1) Try to drag and drop 50 + Stored procedure at the same time on the LINQ To SQL designer.
2) Say no to the prompt window that asks you to save sensitive data pertaining to the connection string to the sql db.
All the stored procedures appear in the methods of the LINQ to SQL design surface, but in the DataContex cs , file that is auto generated, nothing is written in code that has to do with the dropped stored procedures.
PS: this works, only if I drag and drop them 1 at a time or 2 at a time. But not all to gether. Why?