SQL statement with 'ANY' to Linq

Asked Apr 08 '22 at 13:25

Active Apr 08 '22 at 13:40

Viewed 57 times

How to convert the following SQL statement to Linq statement?

select * from "schema_test".project where 'User1'=ANY("collaborators");

Here collaborators is a character varying array.

Note: The contains operator throws error at the postgre side as it is meant only for Array to array comparison. Sample Linq which has error - context.Projects.Where(x => x.Collaborators.Contains(userId))

Any suggestions would help a lot.

edited Apr 08 '22 at 13:40

stuartd

70,509
14
132
163

asked Apr 08 '22 at 13:25

Rakshitha Vasishta

Check [documentation](https://www.npgsql.org/efcore/mapping/array.html) what is supported – Svyatoslav Danyliv Apr 08 '22 at 13:32
@Dai No, it is not false always. You can refer this answer - [link] (https://stackoverflow.com/questions/39643454/postgres-check-if-array-field-contains-value) Please suggest if there are other ways to do this – Rakshitha Vasishta Apr 08 '22 at 13:32
@RakshithaVasishta Sorry, I didn't see the double-quotes there, I thought you were comparing two literal strings. – Dai Apr 08 '22 at 13:34
1

*which has error* - what error? – Caius Jard Apr 08 '22 at 13:56

SQL statement with 'ANY' to Linq

0 Answers0