Is it possible to change the level of DISTINCT in the SQL statement generated out of a LINQ query by Connect for ADO .Net Provider ?

May 19, 2015
Knowledge

Title

URL Name

Is-it-possible-to-change-the-level-of-DISTINCT-in-the-SQL-statement-generated-out-of-a-LINQ-query-by-Connect-for-ADO-Net-Provider

Article Number

000173501

Environment

Product: Connect for ADO .Net DB2 Version: All supported versions OS: All supported platforms Database: DB2 V7R1 Application:All supported applications

Question/Problem Description

Is it possible to change the level of DISTINCT in the SQL statement generated out of a LINQ query by Connect for ADO .Net Provider ?

Steps to Reproduce

Clarifying Information

LINQ query:
var query = dbContext.View.AsQueryable();
//...
if (filter != null)
{
query = query.Where(filter.Expand());
}
//...
var queryGrouped = query.GroupBy(m => new
{
m.Col1,
m.Col2
}).Select(s => s.Key);
//...
if (!order.IsNullOrEmpty())
{
queryGrouped = queryGrouped.OrderBy(order);
}

Generated SQL Statement:
SELECT
"Distinct1"."Col1" AS "Col1",
"Distinct1"."Col2" AS "Col2"
FROM ( SELECT DISTINCT
"Extent1"."Col1" AS "Col1",
"Extent1"."Col2" AS "Col2"
FROM (SELECT
"VIEW"."Col1" AS "Col1",
"VIEW"."Col2" AS "Col2"
FROM "SCHEMA"."VIEW" "VIEW") "Extent1"
WHERE (("Extent1"."Col1" >= 0) AND ("Extent1"."Col1" < '1000'))
) "Distinct1"
ORDER BY "Distinct1"."Col2" DESC

Expected SQL Statement:
SELECT DISTINCT
"Distinct1"."Col1" AS "Col1"
"Distinct1"."Col2" AS "Col2"
FROM ( SELECT
"Extent1"."Col1" AS "Col1",
"Extent1"."Col2" AS "Col2"
FROM (SELECT
"VIEW"."Col1" AS "Col1",
"VIEW"."Col2" AS "Col2"
FROM "SCHEMA"."VIEW" "VIEW") "Extent1"
WHERE (("Extent1"."Col1" >= 0) AND ("Extent1"."Col1" < '1000'))
) "Distinct1"
ORDER BY "Distinct1"."Col2" DESC

Error Message

Defect Number

Enhancement Number

Cause

Resolution

It was determined that the Progress Product is functioning as designed.

An enhancement to the product can be requested through the Progress Community via an Ideas submission. Customer feedback is valuable and Idea submissions are monitored by our Product Management team. Enhancement requests are reviewed during the planning phase of each new product release and a list of the enhancements chosen for implementation can be found in the Release Notes documents that accompany each release. Once an Idea is submitted the Progress Software Community will have the opportunity to comment on and vote for the Idea.

For detailed information on how to submit an Idea, please refer to Knowledge Base article How to submit an idea for a Progress product enhancement (embedded video)

Workaround

Notes

Keyword Phrase

Last Modified Date

11/20/2020 7:29 AM

Is it possible to change the level of DISTINCT in the SQL statement generated out of a LINQ query by Connect for ADO .Net Provider ?

Files(0)

Was this article helpful?

Was this article helpful?

Is it possible to change the level of DISTINCT in the SQL statement generated out of a LINQ query by Connect for ADO .Net Provider ?

Information

Related Articles