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. var results = connection.Query( select from checkpin(:Username :Password) new { Username = input.Username Password = input.Password } commandType: CommandType.Text);

There are multiple ways the easiest one is var parameters = new { UserName = username Password = password }; var sql = select * from users where username = @UserName and password = @Password ; var result = connection.Query(sql parameters);

Answer

How to execute a function with parameters in dapper

Anele Ngqandu

5.1k

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.

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

Answers (1)

Next Recommended Forum

Need to update Table columns using View in Oracle

Stored Procedure is DDL or DML Statement?

Leaderboard

View all

Shubhankar Banerjee

Magnus Mårtensson

Bhasker Das

View all

Yesterday's leader

Shubhankar Banerjee

Blockchain, Solidity, Polygon, C#, NodeJS, HTML, C Language, C++, JavaScript, CSS, ReactJS, MySQL

Kanpur (India)

164

113.7k

11.3k

500

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

187

283.5k

10.4k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

17.2k

56.5k

Upcoming events

View all

Suggested for you

View all

Tural Suleymani

Harminder Singh

Ziauddin Choudhary

Shilpa Tanwar

Sachin Mishra

Forum Statistics

Please welcome our newest member Rahul Kumar.
3,075,475 users have contributed to 147,419 threads and 483,388
In the past 24 hours, we have 10 new threads, 28 new posts, and 200 new users.
In last week, the most popular thread is 'Query result in HTML format'.