C# where clause and postgres

Question

Fouad Allali 1

Hi team
I have issue wiht where clause in C# with postgres and access database.

In postgres the query is :

When i declare harn = "azx" it works fine

But when i keep it variable in method not works. Exemple method :

Internal int getvalue(string harn, con)

(Select Id from table1 where column2 = @val , con)
Cmd. Parameters. AddWithValue("val", harn)

Viorel 122.6K Reputation points

2021-01-20T09:22:03.603+00:00

Does it work if you put “?” instead of “@val ” in query: “select Id from table1 where column2=?”?
Fouad Allali 1 Reputation point

2021-01-20T18:13:07.307+00:00

Thanks Viorel-1 four the answer.

it work wth :

select Id from table1 where column2='azx',con

or

If i add befor query harn = "azx" and i keep the same query (Select Id from table1 where column2 = @val , con)

It work.

1 answer

Viorel 122.6K Reputation points

2021-01-20T09:22:03.603+00:00

Does it work if you put “?” instead of “@val ” in query: “select Id from table1 where column2=?”?
Fouad Allali 1 Reputation point

2021-01-20T18:13:07.307+00:00

Thanks Viorel-1 four the answer.

it work wth :

select Id from table1 where column2='azx',con

or

If i add befor query harn = "azx" and i keep the same query (Select Id from table1 where column2 = @val , con)

It work.

Answer 1

Fouad Allali 1

thanks the problem solved.