none
EntityCommandExecutionException was unhandled question? RRS feed

  • Question

  • The error message: "The data reader is incompatible with the specified 'Database1Model.GetWallTotalArea_Result'. A member of the type, 'Column1', does not have a corresponding column in the data reader with the same name"

    I think this is because the stored procedure selects both a column and the sum of the product of two columns(which is not a column in the database). Here is the procedure:

    CREATE PROCEDURE [dbo].[GetWallTotalArea]
    	
    AS
    BEGIN
    	 SELECT Project, SUM (Dimension$.Height*Dimension$.Width)
     
    
    FROM Dimension$
     
    
    
    GROUP BY Project
    END
    

    The mapping details in the function import:

    Project:String <- Project

    Column1:Double <- Column1

    What is the best way to solve this problem?

    Thursday, March 28, 2013 2:54 PM

Answers

  • Hi,

    What about if you performed something like this in your procedure:

    SELECT Project, SUM (Dimension$.Height*Dimension$.Width) AS Column1
    

    Regards.


    Please remember to Vote & "Mark As Answer" if this post is helpful to you.
    Por favor, recuerda Votar y "Marcar como respuesta" si la solución de esta pregunta te ha sido útil.

    • Marked as answer by NullRef35 Thursday, March 28, 2013 4:41 PM
    Thursday, March 28, 2013 3:04 PM