alternative to linq to query in SQlite c# (lambda compile error)

ozkaro 66

Hi there i need to compare each character in a string data from database and vice versa in any order but i have this error "cannot compile: lambda"

var query = dbcon.Table<userDatabase>().Where(x => x.components.All(j => j.Equals(name.ToCharArray()))).ToListAsync();

I remember use the "using statements" to connect to the databases and foreach to access to the data but in this version of sqlite I don't know how use it and i can't find info about it

JessieZhang-MSFT 7,706 Reputation points Microsoft Vendor

2021-06-11T06:46:24.837+00:00

i need to compare each character in a string data from database and vice versa in any order

What are you trying to achieve? If you want to deal with the data in the database, you can first get the data field from the database ,after that you can do something with the data that you take out.
ozkaro 66 Reputation points

2021-06-11T22:29:25.727+00:00

What I want to do is compare each char of the string what I'm sending with the string in the component element stored in the database.
for example:
(send_string = "abcd") compare with (db_string = "xcka") and then loads all data which contains 'a' and 'c' to a list

thanks in advance
zyz629 6 Reputation points

2021-06-17T01:36:00.503+00:00

Have you tried alessandrocaliaro's advice?

1 answer

Alessandro Caliaro 4,181 Reputation points

2021-06-11T10:47:52.903+00:00

I think you can use the "query" method to execute a select

sqlite-net

manual query
Please sign in to rate this answer.

0 comments No comments
Sign in to comment