We are using EntityFramework and CodeFirst with MySql Database. In DB I created a stored procedure:
CREATE PROCEDURE `GetDepartmentPath`(leftKey INT, rightKey INT)
BEGIN
.....
END
I tried executing code from here and here(what is very similar to first link), but I always get a NotSupportedExeption. Is there a simple way to execute stored procedures using codefirst and get just a collection of entities?