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();

Answer 1

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