You should be able to replicate this issue easily. This is what I did:
1. Create a stored procedure in any Firebird database.
2. Have the SP insert values into your database using a couple of parameters
you pass to your SP.
3. The prototype would look something like this: Execute Procedure
MySP(value1, value2);
4. From a web project in Visual Studio 2010 add a "New Item..." to your
project. Select "Data" from "Installed Templates" and choose "ADO.NET Entity
Data Model"
5. On the Data Model work area right click in the white area and select
"Update Model from Database..."
6. From the "Update Wizard" dialog box "Add" tab, select "Stored Procedures"
and select the stored procedure created in steps 1 & 2 and press Finished
7. Click "View" then "Other Windows" then "Entity Data Model Browser"
8. In the "Model Browser" tree, select "Stored Procedures" under your
database .Store branch (See Capture 1)
http://firebird.1100200.n4.nabble.com/file/n3811066/Capture1.jpg
9. Right Click on your stored procedure and select "Add Function Import...."
10. None of the options in the "Returns a Collection of" or "Get Column
Information" sections works but that is another issue...
11. Click OK
12. In your code create an instance of you entity modal object.
13. Notice that the modal object has a method for you stored procedure with
the input parameters.
At run-time the method executes successfully but the database remains
unchanged. I did not make any changes to the modal's underlying code.
--
View this message in context:
http://firebird.1100200.n4.nabble.com/ADO-NET-Entity-Relationship-with-Stored-Procedures-tp3808352p3811066.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
------------------------------------------------------------------------------
BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
Learn about the latest advances in developing for the
BlackBerry® mobile platform with sessions, labs & more.
See new tools and technologies. Register for BlackBerry® DevCon today!
http://p.sf.net/sfu/rim-devcon-copy1
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
