question

technette avatar image
technette asked

Linq to SQL WCF Services

I have my WCF services configured. How do I add another and correctly call the stored procedure? Here's my first function: Public Function GetBDISContract(ByVal Contract As String) As System.Collections.Generic.List(Of Contract) Implements IBDIS_Contract.GetBDISContract Dim db As New BDIS_ContractsDataContext() Dim matchingContracts = From Contracts In db.Contracts Where Contracts.Contract.Contains(Contract) Select Contracts Return matchingContracts.ToList() End Function
linq-to-sql
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Matt Whitfield avatar image
Matt Whitfield answered
This is really a programming question, but you'll find that [this part of an excellent series of articles][1] deals with calling stored procedures from LINQ. [1]: http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

technette avatar image technette commented ·
Thank you Matt!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.