Jon's Blog

So the other day while attempting to drag a stored procedure onto the LINQ Designer in Visual Studio I received the following error:

The stored procedure was rather complex including a call to FREETEXT and for some reason the LINQ Designer would not accept it, so I manually mapped the stored procedure for the DataContext.  For future reference, here is some sample code:

public partial class MyDataContext
{
    [Function(Name = "dbo.MyStoredProc")]
    public ISingleResult<MyClass> MyProcName(
        [Parameter(Name = "Parameter1")] int? parameter1,
        [Parameter(Name = "Parameter2")] ProductCategory? parameter2,
        [Parameter(Name = "Parameter3")] bool? parameter3)
    {
        IExecuteResult result = this.ExecuteMethodCall(this,
            ((MethodInfo)(MethodInfo.GetCurrentMethod())),
            parameter1, parameter2, parameter3);

        return ((ISingleResult<MyClass>)(result.ReturnValue));
    }
}

Then you can call the stored procedure in code like so:

var results = myDC.MyProcName(parameter1, parameter2, parameter3);