Hi,

I want to get partial data from a table, for example, I want to get all distinct region of employees. The SQL statement may be:

select distinct region from employees

I know this may be implemented by Store procedure, but can i use LLBLGen to execute the statement directly to get a DataTable?

Thanks.

Hi,

You can use TypedList for that. TypedList correspond to custom select statements, where you are in control of every bit of your query.

You can use the designer to prepare your TypedLists structures and paths, and then add filters and other parameters at runtime.

Or you can define them at runtime from scratch by specifying your fields, the joins between your tables etc...