Is it possible to get a distinct output of several (not all) fields from a typed view?

For example, the typed view has these fields (and perhaps others as well): CustomerID OrderDate ProductID

I'd like to get a distinct output of CustomerID and ProductID only. Can this be done and if so, how can it be done.

Joel Reinford Data Management Solutions LLC

I think you mean to Group By CustomerID and ProductID, right?

If so then you might use a the groupByClause parameter in one of the FetchTypedView overloads (Adapter model), or one of the YourTypedView.Fill overloads (SelfServicing)

No, I don't want to group. I just want distinct on a subset of columns.

Given this View

CREATE VIEW dbo.vw_OrderKeys    
AS
SELECT
    o.OrderID
     ,o.CustomerID
     ,o.EmployeeID
     ,o.OrderDate
     ,d.ProductID
    
FROM
    [dbo].[Orders] o
    JOIN dbo.[Order Details] d
    ON o.OrderID = d.OrderID

I want to do this equivalent:

SELECT Distinct
    k.CustomerID
    ,k.ProductID
FROM dbo.vw_OrderKeys k

Typically I'd be adding some predicate expression onto that to limit the results.

Joel Reinford Data Management Solutions LLC

Create a dynamic list with the 2 fields you want to have. Then specify for 'allowDuplicates' false and fetch the dynamic list into a datatable.