SQLite.net query with casted field (int to string) does not work

Question

I tried to query Customers from a SQLite tabel

I want those wher the Customer Number Starts with certain numbers.

The following code throws an error that sqlite does not have a methode ToString.

Can I reach my aim with Cast ?? How?

return conn.Table().Where(v => v.kdnr.ToString().StartsWith(suchtext));

Olivier · Accepted Answer · 2013-11-07 15:28:24Z

1

Using entity framework, that would probably work:

.Where(v=>SqlFunctions.StringConvert(v.kdnr).StartsWith(suchtext))

I dont know about SQLite provider

answered Nov 7, 2013 at 15:28

Olivier

5,7583 gold badges34 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1230268 Over a year ago

Thanks! that was what I was looking for and expected it would work! But unfortunately it is not running with sqlite.net as there is no SqlFunctions class.

Collectives™ on Stack Overflow

SQLite.net query with casted field (int to string) does not work

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related