A community member has associated this post with a similar question:
How the rewrite this IN condition logic to handle in best performance for dotnet core webapi?

Only moderators can edit this content.

How the below logic handle in best way for dotnet core webapi?

Elaya Raja 96

//Query is like ***** where JoinDateTime>@startDate AND JoinDateTime<@endDate AND EmpId IN (@EmpId )

var result = await _database.QueryAsync<Employee>(query,
new
{
startDate,
endDate,
EmpId = listOfEmployeeID.ToArray() // Empid is integer and always passing more than 1000+
});

Thanks
Jo