This question is locked. New answers and comments are not allowed.
Hi guys,
For the second time, I need your help.
As example, I have the following Mysql stored procedure
I want to use it in my C# code. Then, I added correctly (i think) this stored procedure in my model, and created a domain method.
Nevertheless, when I add this stored procedure, I have a look on input parameters and I can see that nullable value is not authorized (false value).
And the generated code seems to apply this behavior as I have :
IS there any solution so as to authorize null parameters for mysql procedures ?
Is that possible to have an "int?" instead of this simple "int" as parameter in generated function ?
Thanks a lot for your help.
For the second time, I need your help.
As example, I have the following Mysql stored procedure
CREATE
PROCEDURE
`P_S_TEST`(
TEST1
INT
,
TEST2
VARCHAR
(36),
TEST3
VARCHAR
(32)
)
BEGIN
SELECT
*
FROM
t_tests tes
WHERE
((TEST1
IS
NULL
)
OR
(TEST1
IS
NOT
NULL
AND
tes.tes_id = TEST1 ))
AND
((TEST2
IS
NULL
)
OR
(TEST2
IS
NOT
NULL
AND
tes.tes_nom = TEST2 ))
AND
((TEST3
IS
NULL
)
OR
(TEST3
IS
NOT
NULL
AND
tes.tes_prenom = TEST3 ))
I want to use it in my C# code. Then, I added correctly (i think) this stored procedure in my model, and created a domain method.
Nevertheless, when I add this stored procedure, I have a look on input parameters and I can see that nullable value is not authorized (false value).
And the generated code seems to apply this behavior as I have :
public
IEnumerable<CWI.DAL.TELERIK.MYSQL.P_S_TESTResultSet> P_S_TEST(
int
TEST1,
string
TEST2,
string
TEST3)
IS there any solution so as to authorize null parameters for mysql procedures ?
Is that possible to have an "int?" instead of this simple "int" as parameter in generated function ?
Thanks a lot for your help.