Entity model mapping not render properly with dynamic sql procedure RRS feed

  • Question

  • Dear all,

    I have a store procedure in my SQL server database 2008 which is dynamic and define as follow :

    	EXEC sp_executesql @SQL, N'@BranchId uniqueidentifier,@PropertyTypeId int,@Bedroom int,	@MinPrice int,@MaxPrice int,@ForSale bit,@ForRent bit',
    							@BranchId,@PropertyTypeId,@Bedroom ,@MinPrice,@MaxPrice,@ForSale,@ForRent

    When I am updating my database model. Then I Add a function Import in order to map to my procedure. the problem is tha if I try to get the column Information, it is not capable to get them du the the dynamic sql I guess.

    How can I solve that ?


    Monday, February 3, 2014 11:36 AM


  • Got it working

    EF is not friend with dynamic sql query, I has to do the mapping manually

    • Marked as answer by wakefun Monday, February 3, 2014 3:41 PM
    Monday, February 3, 2014 3:41 PM