Linq to filter result from database

Question

I have an existing function that returns a model data

var GetTableData = await _camService.GetTableData();

This returns a list Task<List<GetTableDataModel>> of model properties.

Now, I want to filter the result based on one of the model property (eg. email)

like, GetTableData where email='abc@email.com'

Answer 1

You can use LINQ to perform filtering:

var filteredData = data.Where( item => item.email == "abc@email.com" ).ToArray();

In this case however I don't see the reason to retrieve all data at once when they are just filtered subsequently. I think it would be more efficient to filter them on the database side, within your service.

Answer 2

var filteredData = GetTableData.Where(x => x.email == "abc@email.com");

I would suggest you to create a function in which you will filter the data on the database side instead of querying all the data.