DataService query persons in group?

Questions
1

How can I use the DataService to fetch all persons belonging to a specific group?

Litium version: 7.4

2

You need to use Dapper instead of DataService because with DataService you will be forced to fetch all customers as a list first and do your selection after and that would be dangerous on large numbers of customers to look up from DB directly.

3

I had no idea Litium used Dapper. Or do you mean we should implement our own custom orm/data access layer?

4

Dapper is included in Accelerator.

5

I suggest to use the DataService directly

using (var q = _dataService.CreateQuery<Person>())
{
    return q.Filter(x => x.ContainsInGroup(GroupSystemId)).ToList();
}
2 Likes
6

Great didn’t find that extension method :slight_smile:

7

Neither did I… thank’s Patric.
And now that I do know, searching yields this page: https://docs.litium.com/api-reference/api?product=Litium&version=7.4&xref=Litium.Customers.Queryable.PersonFilterDescriptorExtensions
Hopefully you’ll find time to improve the documentation on these things so we get to know about them and can use them.

8

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.