public async Task <IEnumerable <SqlUser> > GetExistingUsersByNamesAsync(IEnumerable <string> userNames)
{
var prm = new DynamicParameters();
prm.Add("@userNames", SqlConnectionWrapper.ToStringDataTable(userNames));
return(await _connectionWrapper.QueryAsync <SqlUser>("GetExistingUsersByNames", prm, commandType : CommandType.StoredProcedure));
}
public async Task <IEnumerable <SqlGroup> > GetExistingGroupsByNamesAsync(IEnumerable <string> groupNames, bool instanceOnly)
{
var prm = new DynamicParameters();
prm.Add("@groupNames", SqlConnectionWrapper.ToStringDataTable(groupNames));
prm.Add("@instanceOnly", instanceOnly);
return(await _connectionWrapper.QueryAsync <SqlGroup>("GetExistingGroupsByNames", prm, commandType : CommandType.StoredProcedure));
}