• In some cases, a stored procedure can provide advantages over embedded SQL statements. Stored procedures support complex conditional and looping constructs that are difficult to duplicate with SQL statements embedded directly in an application.You can also see a significant improvement in performance by using stored procedures; a stored procedure only needs to be parsed, compiled and optimized once on the server side, while a SQL statement that is included in an application may be parsed, compiled and optimized each time it is executed from a .NET application.
2. Import the EnterpriseDB.EDBClient namespace.
4. Change the EDBCommand.CommandType to CommandType.StoredProcedure.
5. Prepare() the command.