problem with linq to sqlite

Question

I am using vb.net sqlite.net and dblinq0.20.1 to search a sqlite table on a primary key field.

My code looks like this

Dim blb = (From d In db.Data Where d.UID = myuid Select d).Single

This returns the error "Coalesce used with type that cannot be null"

If I search on a nullable field it works fine.

Anyone come across this error before and throw any light on what the issue is?

Paul Ryan · Accepted Answer · 2010-09-25 16:57:40Z

1

This error message was a bit misleading. The field in question (the primary key for the table) was in fact nullable whereas it should not have been. I changed the field property to 'not null' and the linq query worked as expected.

answered Sep 25, 2010 at 16:57

Paul Ryan

3322 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

problem with linq to sqlite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related