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();
}
