How to execute a function with parameters in dapper

Question

Please assist executing a dapper function below. I am using oracle Below query complains that its missing a FROM, but when from is added, it complains that the query is not properly created.

 var user = connection.Query<dynamic>("select myfunctionname(:Username, :Password)", new { Username = input.Username, Password = input.Password },commandType: CommandType.Text).First();

Note: there is a QueryFirst<T> method, and it is almost always preferable to avoid dynamic — Marc Gravell
– Marc Gravell, Commented Jun 2, 2021 at 9:56
Dapper doesn't modify the query, it sends it directly to the database for execution. Have you tried running that query by itself? If Oracle complains that FROM is missing, you probably need to add it — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jun 2, 2021 at 9:58
Not all variables are bound that's a completely different error from what you posted in the question. What is the actual error? — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jun 2, 2021 at 9:59
@PanagiotisKanavos the question asked was what happens when I remove CommandType.Text to StoredProcedure then I said I get an error "Not all variables are bound" — Anele Ngqandu
– Anele Ngqandu, Commented Jun 2, 2021 at 10:01

Marc Gravell · Accepted Answer · 2021-06-02 09:55:10Z

1

If Oracle functions work like SQL Server table-valued functions (UDFs), then you probably mean select * from myfunctionname(:Username, :Password)

answered Jun 2, 2021 at 9:55

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to execute a function with parameters in dapper

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related