How to execute a function with parameters in dapper

Question

0.00/5 (No votes)

See more:

Hi Guys

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 missing expression.

What I have tried:

C#

var results = connection.Query("select from checkpin(:Username, :Password)", new { Username = input.Username, Password = input.Password }, commandType: CommandType.Text);

Posted 2-Jun-21 0:21am

Anele Ngqandu

Updated 2-Jun-21 0:30am

Add a Solution

Comments

Richard Deeming 2-Jun-21 8:37am

That query looks like you're storing users' passwords in plain text. Don't do that!

Secure Password Authentication Explained Simply[^]
Salted Password Hashing - Doing it Right[^]

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2021-06-02T00:30:00

Solution 1

You're at least missing the list of columns you're selecting. For example, try using * to get all of the columns

C#

var results = connection.Query("select * from ...

Posted 2-Jun-21 0:30am

Wendelius

How to execute a function with parameters in dapper

1 solution

Solution 1

Add your solution here

Preview 0

How to execute a function with parameters in dapper

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us