I have a view in SQL Server that contains a one (e.g. product) to many (e.g. vendors) relationship. As a result, one product may be displayed several times. Is it possible to perform the following query in LLBLGen 1.x? The product table isn't normalized 100% as it may contain two entries for products with the same name but different specs (e.g. color).

SELECT ProductName, COUNT(*) FROM (SELECT ProductID, ProductName FROM ProductView GROUP BY ProductID, ProductName) AS MyTable GROUP BY ProductName

If you already are using database views, you may also create another view for the previous query. And map it back as TypedView or an Entity.

As shown in the SQL statement, my view is only part of this query. Is it possible to do this in LLBLGen or does all the SQL need to be put in a new view?

I was suggesting to put it all in a new view.

Is this feature available in 2.x by chance?

No, selects from select statements ('derived tables') isn't supported, so FROM (SELECT.. FROM..) isn't supported