public void JoinOnRightSideNameClash()
{
using (testEntities context = new testEntities())
{
string eSql = @"SELECT c.Id, c.Name, a.Id, a.Name, b.Id, b.Name FROM
testEntities.Companies AS c JOIN (testEntities.Authors AS a
JOIN testEntities.Books AS b ON a.Id = b.Id) ON c.Id = a.Id";
ObjectQuery<DbDataRecord> query = context.CreateQuery<DbDataRecord>(eSql);
string sql = query.ToTraceString();
CheckSql(sql, SQLSyntax.JoinOnRightSideNameClash);
foreach (DbDataRecord record in query)
{
Assert.AreEqual(6, record.FieldCount);
}
}
}