Translate to LINQ

Hi everyone,

I'm writing a query using VB.NET and I'm having problems in my where clause.

If the value of [rdbTitleAndSettlement.Checked] then I want to return all records where app.ss is false, if the value of [rdbProductAndServices.Checked] then I want to return all records where app.ss is true, else I want to return app.ss where values are both true and false.

App.SS contains a boolean value.

What Am I doing wrong?

Thanks in advance

Dim AppInfo = (From app In dc.APPLICATIONs
Where If(rdbTitleAndSettlement.Checked, app.SS = False, If(rdbProductAndServices.Checked, app.SS = True, app.SS <> Null))
Select
Reader = app.Examiner.Examinname,
Index = app.APPLICATIONSIDNUMBER,
Title_Number = app.TITLENO)

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
Accepted answer
Try like this:
Dim AppInfo As dynamic = (From app In dc.APPLICATIONs Where ((rdbTitleAndSettlement.Checked AndAlso app.SS = False) OrElse (rdbProductAndServices.Checked AndAlso app.SS = True) OrElse (Not rdbTitleAndSettlement.Checked AndAlso Not rdbProductAndServices.Checked))app)
Edil Guardado9y ago
Thank you.

That did it.