Take the 2-minute tour ×  I have the following LINQ query:  var
queryGroups = (from p in db.cl_contact_event
select new Groups { inputFileName = p.input_file_name
}).Distinct();  Which translates to the following when run:
[Distinct1].[C1] AS [C1],  [Distinct1].[input_file_name] AS
[input_file_name]        [Extent1].[input_file_name] AS
[input_file_name],         1 AS [C1]        FROM
[mel].[cl_contact_event] AS [Extent1] )  AS [Distinct1]  Now I'm
pretty sure that the reason there is a sub-select is because I
have the base LINQ query surrounded by () and then perform
.Distinct() but I don't know enough about LINQ to be sure of
this. If that's indeed the case is there a way to
restructure/code my query so that a sub-select doesn't occur?  I
know that it probably seems that I'm just nit-picking here but
I'm just curious.  share|improve this question Is that linq-to-
sql, linq-to-entities or linq-to-nhibernate? –  Danny Varod Jun
18 '12 at 22:39 @DannyVarod linq-to-entities I believe since I'