Linq to SQL Stored Procedures with Multiple Results
<p>I have a stored procedure that selects from multiple tables</p>

<p>The calling method in the class the inherits from DataContext is as follows</p>

<p>[Function(Name = "dbo.BASE_Product_Retrieve")]</p>

<pre><code>    [ResultType(typeof(BASE_Product))]

    [ResultType(typeof(BASE_Product_Version))]

    [ResultType(typeof(BASE_ItemPrice))]

    [ResultType(typeof(BASE_VendorItem))]

    [ResultType(typeof(BASE_ProductAttachment))]

    [ResultType(typeof(BASE_ItemPrice_Version))]


    public IMultipleResults BASE_Product_Retrieves([Parameter(Name = "ProductId", DbType = "Int")] System.Nullable&lt;int&gt; productId, [Parameter(Name = "Version", DbType = "Int")] System.Nullable&lt;int&gt; version)
    {
        IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), productId, version);
        return ((IMultipleResults)(result.ReturnValue));
    }
</code></pre>

<p>when i call it from my class</p>

<p>var x=RetrieveProductList.GetResult &lt; BASE_ItemPrice > ();</p>

<p>it gives me the following exception</p>

<p>The required column 'ItemPriceId' does not exist in the results.</p>

<p>knowing that ItemPriceId is a clumn that exists in that table!!</p>
