Hi,

I was wondering how to go about this -or if this is possible?

I have a complex typed view (complexStudents) which may return multiple records for a student as well as a simple type view (students) which returns only unique records for a student.

I would like to:

a) Use the complex typed view (complexStudents) to be able to select (filter) students by predicate criteria.

b) Given that there may (usually would) be multiple records -> then select only the only the unique student ids (which are Guids)

c) Use those unique student ids to select 1:1 records from the simple type view (student) to display as the results to the user.

Can anyone please help?

In your place I would go ton "Entities mapped on views". You can use you db views and map them to entities. This way you get an entitycollection you can filter, join, etc.

Thanks for the tip!

Given I'm pretty new to LLBLGen is there a good place to find an example on how to do this?

Wiggy wrote:

Given I'm pretty new to LLBLGen is there a good place to find an example on how to do this?

The manul if full of little examples that show you how to use the framework. Also there are application examples you can download at the site. Then, you can ask here