© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•10mo ago•
5 replies
VoidPointer

One IEnumerable with 1 item mysteriously becomes empty after I query a second IEnumerable

The variable
pkeys
pkeys
has one item immediately after the query that returns it is executed, but then when the query that returns
ckeys
ckeys
query is executed, suddenly
pkeys
pkeys
shows Enumeration yielded no results while
ckeys
ckeys
contains one item.
var pkeys= qry.GetTableColumns(tableName)
    .Where(col => col.Kind == Column.ColumnKinds.PartitionKey)
    .Select(col => new PropertyGenerationModel(col));
var ckeys= qry.GetTableColumns(tableName)
    .Where(col => col.Kind == Column.ColumnKinds.Clustering)
    .Select(col => new PropertyGenerationModel(col));
var pkeys= qry.GetTableColumns(tableName)
    .Where(col => col.Kind == Column.ColumnKinds.PartitionKey)
    .Select(col => new PropertyGenerationModel(col));
var ckeys= qry.GetTableColumns(tableName)
    .Where(col => col.Kind == Column.ColumnKinds.Clustering)
    .Select(col => new PropertyGenerationModel(col));

In case it helps,
GetTableColumns
GetTableColumns
is querying a Cassandra db like this:
using Cassandra.Mapping;
using CassandraClient.Config;
using CassandraClient.Metadata.Models;
namespace CassandraClient.Metadata;

public class MetaDataQueries(SessionOptions options)
{
    public IEnumerable<Column> GetTableColumns(string tableName)
    {
        var session = SessionFactory.GetSession(options);
        Mapper mapper = new(session);
        var columns = mapper.Fetch<Column>(
            $"select * from system_schema.columns where table_name = '{tableName}' and keyspace_name = '{session.Keyspace}' allow filtering;");
        return columns;
    }
}
using Cassandra.Mapping;
using CassandraClient.Config;
using CassandraClient.Metadata.Models;
namespace CassandraClient.Metadata;

public class MetaDataQueries(SessionOptions options)
{
    public IEnumerable<Column> GetTableColumns(string tableName)
    {
        var session = SessionFactory.GetSession(options);
        Mapper mapper = new(session);
        var columns = mapper.Fetch<Column>(
            $"select * from system_schema.columns where table_name = '{tableName}' and keyspace_name = '{session.Keyspace}' allow filtering;");
        return columns;
    }
}
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

❔ IEnumerable is empty for some reason
C#CC# / help
4y ago
IEnumerable<Author>
C#CC# / help
3mo ago