Hello All! I have generated several objects (via Linq) : Client - main table, ClientContacts - related table. I use next statement in stored procedure (for return client and its contacts): SELECT ClientID, ClientName FROM Clients WHERE ClientID = 1 SELECT * FROM Contacts WHERE FK_ClientID = 1 Could you please tell me if there is any possibility to get both Client and List with this procedure? Many thanks.
Read More...