TvDatabase.TvBusinessLayer.GetChannelsInGroup C# (CSharp) Method

    public IList<Channel> GetChannelsInGroup(ChannelGroup group)
    {
      SqlBuilder sb = new SqlBuilder(StatementType.Select, typeof (Channel));
      SqlStatement origStmt = sb.GetStatement(true);
      string sql = "SELECT c.* FROM Channel c INNER JOIN GroupMap gm ON (c.idChannel = gm.idChannel AND gm.idGroup =" +
                   group.IdGroup + ") ORDER BY gm.SortOrder ASC";
      SqlStatement statement = new SqlStatement(StatementType.Select, origStmt.Command, sql,
                                                typeof (Channel));
      return ObjectFactory.GetCollection<Channel>(statement.Execute());
    }