A Question About Linq To Sql

Question

When I write a code like below, I take this error message: "The query operator 'ElementAtOrDefault' is not supported."

How can I fix it?

Dim tmpQuestion As New UIData Dim strViews = From t In tmpQuestion.LU_QUESTIONs _ Where t.ID_QUESTION = Request.QueryString("IdQuestion") _ Select t Dim mtViews = strViews(0).MT_VIEWS

Benjamin Autin · Accepted Answer · 2009-02-27 14:28:02Z

3

You haven't really queried yet. strViews isn't the result set, it is the query. You need to actually retrieve some data.

var chosen = strViews.FirstOrDefault();

answered Feb 27, 2009 at 14:28

Benjamin Autin

4,16928 silver badges34 bronze badges

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

2 Comments

Adam Lassek Over a year ago

Good point about the late binding -- that can really mess you up if you're not careful.

mavera Over a year ago

Thanks, this sentence is very important: "strViews isn't the result set, it is the query."

tvanfosson · Accepted Answer · 2009-02-27 14:26:43Z

Have you tried using the FirstOrDefault() then check to make sure it is not null. My VB syntax is probably suspect, but you get the idea.

Dim strView = (From t In tmpQuestion.LU_QUESTIONS _ Where t.ID_QUESTION = Request.QueryString("IdQuestion") _ Select t).FirstOrDefault() Dim mtViews as ... If Not strView Is Nothing mtViews = strView.MT_VIEWS EndIf

Johannes · Accepted Answer · 2009-02-27 14:23:16Z

I am no expert in VB or LINQ2SQL but does this not have anything to do with the fact that you say strViews(0).MT_VIEWS while there is a chance that strViews can be null?

Collectives™ on Stack Overflow

A Question About Linq To Sql

3 Answers 3

2 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Linked

Related