Linq to SQL WCF Service Call Stored Procedure

Question

0.00/5 (No votes)

See more:

I have my services running but I want to approapriately add additional services. I want to call the stored procedure that I created.

Here's the inition service function:

<pre lang="vb">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

How do I correctly add a function to call the stored procedure?

Posted 22-Jul-10 11:17am

technette

Updated 22-Jul-10 12:08pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2010-07-22T11:51:00

Solution 1

I'm not sure if you're asking the same question over and over, or asking different questions with the same subject. If the former, stop it. If the latter, change your subject so that the regulars on this forum understand that you're asking different things.

Posted 22-Jul-10 11:51am

Christian Graus

Comments

technette 22-Jul-10 18:09pm

Reason for my vote of 3
Christian is correct. I should change the subject heading.

Christian Graus 22-Jul-10 18:22pm

Excellent. My first thought was that you were asking the same thing over and over, but when I looked, it didn't seem like you were. The same people post here every day, the same subject will cause people to ignore you, so now you're more likely to get the help you need. Never used WCF myself, so I'm not much use....