What is the return type of my linq query?

Question

I have two tables A & B. I can fire Linq queries & get required data for individual tables. As i know what each of the tables will return as shown in example. But, when i join both the tables i m not aware of the return type of the Linq query. This problem can be solved by creating a class which will hold ID,Name and Address properties inside it. but,everytime before writing a join query depending on the return type i will have to create a class which is not a convinient way Is there any other mathod available to achieve this

  private IList<A> GetA()
    {
        var query = from a in objA
                    select a;
        return query.ToList();
    }

    private IList<B> GetB()
    {
        var query = from b in objB
                    select b;
        return query.ToList();
    }

    private IList<**returnType**?> GetJoinAAndB()
    {
        var query = from a in objA
                    join b in objB
                    on a.ID equals b.AID
                    select new { a.ID, a.Name, b.Address };
        return query.ToList();
    }

Answer 1

You've created an anonymous class - you can't really return it. A simple solution is to add a class to represent your type.

For example:

public class UserWithAddress
{
    public UserWithAddress(int id, string name, string address)
    {
        ID = id;
        Name = name;
        Address = address;
    }

    // you may have your own types here
    public int ID { get; set; }
    public String Name { get; set; }
    public String Address { get; set; }
}

And then:

private IList<UserWithAddress> GetJoinAAndB()
{
    var query = from a in objA
                join b in objB
                on a.ID equals b.AID
                select new UserWithAddress(a.ID, a.Name, b.Address);
    return query.ToList();
}