SQL ADO.Net Entity LINQ question

Question

I have a small question about my project you could not know, I understand. But perhaps I have a very simple fault in my following function you could see?

<OperationContract()>
Public Function GetBestFahrer() As Autofahrer
    Dim Database As New Model1Container
    Dim Fahrer As Autofahrer = From d In Database.AutofahrerSet Where d.Unfälle = 0 Select d Order By d.Unfälle Ascending
    If Fahrer Is Nothing Then
        Fahrer = Autofahrer.CreateAutofahrer(0, "Testfahrer", DateTime.Now, 0)
        Database.AutofahrerSet.AddObject(Fahrer)
        Database.SaveChanges()
    End If

    Return Fahrer

End Function

Error message on line with "Dim Fahrer As Autofahrer = ..."

Unable to cast object of type 'System.Data.Objects.ObjectQuery`1[SilverlightApplication4.Web.Autofahrer]' to type 'SilverlightApplication4.Web.Autofahrer'.

You haven't accepted any answers to your questions.

Jack Marchetti
– Jack Marchetti

2011-05-03 19:26:40 +00:00
Commented May 3, 2011 at 19:26 — Jack Marchetti
– Jack Marchetti, Commented May 3, 2011 at 19:26

Biff MaGriff · Accepted Answer · 2011-05-03 19:33:42Z

1

Fahrer is a single object
From d In Database.AutofahrerSet Where d.Unfälle = 0 Select d Order By d.Unfälle Ascending does not give you a single object

It looks like you want to see if something exists and then create it if it doesn't.

Try something like this

Dim myCount as integer = (From d In Database.AutofahrerSet Where d.Unfälle = 0 Select d).Count()
if myCount = 0 then
    Fahrer = Autofahrer.CreateAutofahrer(0, "Testfahrer", DateTime.Now, 0)
    Database.AutofahrerSet.AddObject(Fahrer)
    Database.SaveChanges()
else
    Fahrer = (From d In Database.AutofahrerSet Where d.Unfälle = 0 Select d Order By d.Unfälle Ascending).First()
End If

answered May 3, 2011 at 19:33

Biff MaGriff

8,2619 gold badges65 silver badges100 bronze badges

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

Collectives™ on Stack Overflow

SQL ADO.Net Entity LINQ question

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