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; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)