Exemple #1
0
        public IAsyncEnumerable <PKMember> GetSystemMembers(PKSystem system, bool orderByName)
        {
            var sql = "select * from members where system = @SystemID";

            if (orderByName)
            {
                sql += " order by lower(name) asc";
            }
            return(_conn.QueryStreamAsync <PKMember>(sql, new { SystemID = system.Id }));
        }