Reputation: 659
I want to create 2 methods with the same name, same return type, but different parameters.
When I attempted this using the Model the following happened:
Error 1 CF0075: Procedure '_PR01_PayrollEmployeeFile_LoadBySocialSecurityNumber' for method 'LoadBySocialSecurityNumber(System.String socialSecurityNumber, System.String companyCode)' with body 'LOAD(string socialSecurityNumber, string companyCode) RAW' already exists. Try to change method name or method persistenceName. 0 0 Amikids.DataProWarehouse.Model
Upvotes: 1
Views: 43
Reputation: 659
To the good support people at Softfluent: Give me 24 hours and check back to make sure the following solution fully works and I don't have any other issues.
I think I have the solution but have not fully tested and noticed something quirky in the XML after I did a build, but suspect I may have corrupted the XML file and don't have time to fully explore.
The solution (I think): Set the persistenceName in the XML file. The persistenceName corresponds to the generated stored procedure name.
<cf:method name="TestMethod" body="LOAD(string x) ORDER BY FirstName" persistenceName="TestMethod1" /> <cf:method name="TestMethod" body="LOAD(string x, string y) ORDER BY LastName" persistenceName="TestMethod2" />
Upvotes: 2