Solved

Linq result to object

Posted on 2010-09-01
7
323 Views
Last Modified: 2013-11-11
Dim League As List(Of Game) = New List(Of Game)
FillLeagueList(league)
...
now I want the following
Dim HomeList as VariantType
HomeList = (From c In League Where c.GetGameNumber = (dayNumber - 1) Select c.GetAwayTeam)

But I want that HomeList is declared as List(Of Team). So I need to cast the linq-result into this list. Can someone help me

i tried this:
HomeList = (From c In League Where c.GetGameNumber = (dayNumber - 1) Select c.GetAwayTeam, c.GetHomeTeam, c.GetGameNumber).Cast(Of Team).ToList()
HomeList = (From c In League Where c.GetGameNumber = (dayNumber - 1) Select c.GetAwayTeam).Cast(Of Team).ToList()

Public Class Game

    Private _HomeTeam As String

    Private _AwayTeam As String

    Private _Game As Integer



    Public Sub New(ByVal homeTeam As String, ByVal awayTeam As String, ByVal game As Integer)

        _HomeTeam = HomeTeam

        _AwayTeam = AwayTeam

        _Game = game



    End Sub



    Public Property GetHomeTeam()

        Get

            Return _HomeTeam

        End Get

        Set(ByVal value)



        End Set

    End Property



    Public Property GetAwayTeam()

        Get

            Return _AwayTeam

        End Get

        Set(ByVal value)



        End Set

    End Property



    Public Property GetGameNumber()

        Get

            Return _Game

        End Get

        Set(ByVal value)



        End Set

    End Property

End Class

Open in new window

0
Comment
Question by:Dhaest
  • 3
  • 2
  • 2
7 Comments
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 33584192
HomeList, based on your LINQ, will return an IEnumerable(Of String), not IEnumerable(Of Game), because of the "SELECT" statement.

If you want to return List(Of Game), you should do this....

        Dim HomeList As List(Of Game)
        HomeList = (From c In League Where c.GetGameNumber = (dayNumber - 1)).ToList

Wayne
0
 
LVL 53

Author Comment

by:Dhaest
ID: 33584236
It's not a gamelist that I want back, but a teamlist that played at home previous daynumber

' this list will be filled and will contain games.
Dim League As List(Of Game) = New List(Of Game)

' Now I need a list of teams that played home at previous round
Dim HomeList as VariantType
HomeList = (From c In League Where c.GetGameNumber = (dayNumber - 1) Select c.GetAwayTeam)

-- this code gives what I want (only it's a string-list and not a list<team>), so I need a way to convert this list<string> into a list<team>
Public Class Team

    Private name As String



    Public Sub New(ByVal TeamName As String)

        name = TeamName

    End Sub



    Public Property GetTeam()

        Get

            Return name

        End Get

        Set(ByVal value)



        End Set

    End Property



End Class

Open in new window

0
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 250 total points
ID: 33584260
How about declaring the 'GetAwayTeam' property in the Game class as Team? Then you can simply do this....

        Dim HomeList As List(Of Team)
        HomeList = (From c In League Where c.GetGameNumber = (dayNumber - 1) Select c.GetAwayTeam).ToList

Wayne
Public Class Team
    Private name As String

    Public Sub New(ByVal TeamName As String)
        name = TeamName
    End Sub

    Public Property GetTeam() As String
        Get
            Return name
        End Get
        Set(ByVal value As String)

        End Set
    End Property

End Class

Public Class Game
    Private _HomeTeam As Team
    Private _AwayTeam As Team
    Private _Game As Integer

    Public Sub New(ByVal homeTeam As String, ByVal awayTeam As String, ByVal game As Integer)
        _HomeTeam = New Team(homeTeam)
        _AwayTeam = New Team(awayTeam)
        _Game = game
    End Sub

    Public Property GetHomeTeam() As Team
        Get
            Return _HomeTeam
        End Get
        Set(ByVal value As Team)

        End Set
    End Property

    Public Property GetAwayTeam() As Team
        Get
            Return _AwayTeam
        End Get
        Set(ByVal value As Team)

        End Set
    End Property

    Public Property GetGameNumber() As Integer
        Get
            Return _Game
        End Get
        Set(ByVal value As Integer)

        End Set
    End Property
End Class

Open in new window

0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 10

Assisted Solution

by:joriszwaenepoel
joriszwaenepoel earned 250 total points
ID: 33584294
You can use "Select New Team(temaName)" in your LINQ query:

HomeList = (From c In League Where c.GetGameNumber = (dayNumber - 1) Select New Team(c.GetAwayTeam)).ToList
0
 
LVL 53

Author Closing Comment

by:Dhaest
ID: 33584361
@Webtubbs: Thanks for the insight (overlooked the fact that I declared the team as string in the class Game)
@JorisZwaenepoel: thx
0
 
LVL 53

Author Comment

by:Dhaest
ID: 33584403
@JorisZwaenepoel: I was too quick to cheer ... I tried your solution, but I get a list of teams back where each team is always the same one !
0
 
LVL 10

Expert Comment

by:joriszwaenepoel
ID: 33584437
That should not be the case.

If you get the results without the "As New", you get a list of strings.  If that list is correct then using the "As New" technique should give correct results as well.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now