Ejemplo n.º 1
0
        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));
        }
Ejemplo n.º 2
0
        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));
        }