Hi, we're using csharp-driver in our application and we would like to execute queries (using Table<TEntity>) at various keyspaces. SimpleStatement.SetKeyspace() doesn't have any effect on the actual query's keyspace (documentation states that this method is only to provide a hint for token-aware routing).
Therefore it seems like our only option is to either use ISession.ChangeKeyspace() before every query to set a session wide keyspace or to use a separate session for each keyspace. Isn't there a better approach to achieve the desired functionality?
Thanks!