.NET
Microsoft Technologies based on the .NET software framework.
3,395 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
//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