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]
    	 SELECT Project, SUM (Dimension$.Height*Dimension$.Width)
    FROM Dimension$
    GROUP BY Project

    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


  • Hi,

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

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


    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