1. Do not include dynamic SQL, with output parameters stored procedure Call instance
A. Stored procedure Code: B.EF automatically generated code (including the entity model corresponding to Objectresult): C. Calling the stored procedure Code instance: summary:
- When the ObjectParameter parameter corresponds to the output type, you do not have to specify such
- ObjectParameter namespace: Using System.Data.Objects;
- The name of the ObjectParameter parameter is the corresponding stored procedure parameter string minus the @ symbol, such as the stored procedure parameter ' @Count int output ', corresponding to the name "Count", note case insensitive
2. Dynamic SQL, with output parameter stored procedure call instance
A. Stored procedure Code: b.ef automatically generated code (not available): C. Stored procedure Call code: summary:
- The SQLQuery method is required for stored procedures for dynamic SQL, and the corresponding parameters should be of type SqlParameter
- For non-dynamic SQL stored Procedures EF automatically generates the corresponding method and the entity class that returns the result, the corresponding parameter type is ObjectParameter
EF (serverfirst) execution stored procedure instance 1 (with output parameters)