EF Exceute SQL That Retuns Results from More Than One Table

See more:

EF4.0

I have been digging all over the internet trying to find how I can get data from a complex query using EF. Is this even possible?

using (var entity = new ApsAppsConfigEntities())
{
  const string myQuery = @"select comenv.[Name], catcon.[Key],catapp.[Key], conenv.Id " +
                         " from   dbo.catalogConnection catcon " +
                         " join   dbo.connectionEnvironment conenv on catcon.Id = conenv.catalogConnectionId " +
                         " join   dbo.applicationConnection appcon on conenv.Id = appcon.connectionEnvironmentId " +
                         " join   dbo.applicationEnvironment appenv on appcon.applicationEnvironmentId = appenv.Id " +
                         " join   dbo.catalogApplication catapp on appenv.catalogApplicationId = catapp.Id " +
                         " join   dbo.commonEnvironment comenv on conenv.commonEnvironmentId = comenv.Id and appenv.commonEnvironmentId = comenv.Id " +
                         " order by comenv.[Name], catcon.[Key] ,catapp.[Key] ";
  var queryResults = entity.?????????(myQuery);
  return queryResults;
}

Sorry for the formatting....Thank you!