Cassandra Keyspaces repository .net

public class TestRepository : ITestRepository
{
    private readonly CassandraSessionCache _cassandra;
    private Mapper _mapper;

    public TestRepository(CassandraSessionCache cassandra)
    {
        _cassandra = cassandra;
    }

    public async Task DeleteAsync(Guid id, string keySpace)
    {
        SetSessionAndMapper(keySpace);

        await _mapper.DeleteAsync<Test>("WHERE id = ?", id);
    }

    public async Task<Install> GetAsync(string id, string keySpace)
    {
        SetSessionAndMapper(keySpace);

        return await _mapper.FirstOrDefaultAsync<Test>("SELECT * FROM \"Test\" WHERE id = ?", id);
    }

    public async Task PostAsync(Test data, string keySpace)
    {
        SetSessionAndMapper(keySpace);

        await _mapper.InsertAsync(data);
    }

    private void SetSessionAndMapper(string keySpace)
    {
        var session = _cassandra.GetSession(keySpace);
        _mapper = new Mapper(session);
    }
}

Source: stackoverflow.com

Cassandra Keyspaces repository .net

My current solve:Create Cluster:cluster = Cluster.Builder()  .AddContactPoint(cassandraData.ContactPoint)  .WithPort(int.Parse(cassandraData.Port))  .WithCredentials(cassandraData.User, cassandraData.Password)  .Build();After that i inject this by dependency injection to my Session Cache:public CassandraSessionCache(Cluster cluster){  _cluster = cluster;  _sessions = new ConcurrentDictionary<string, Lazy<ISession>>();}public ISession GetSession(string keyspaceName){  if (!_sessions.ContainsKey(keyspaceName))    _sessions.GetOrAdd(keyspaceName, key => new Lazy<ISession>(() =>   _cluster.Connect(key)));  var result = _sessions[keyspaceName];  return result.Value;}I Create also Map to Cassandra and use it my startup class.After this configuration my repository look like this:public class TestRepository : ITestRepository
{
    private readonly CassandraSessionCache _cassandra;
    private Mapper _mapper;

    public TestRepository(CassandraSessionCache cassandra)
    {
        _cassandra = cassandra;
    }

    public async Task DeleteAsync(Guid id, string keySpace)
    {
        SetSessionAndMapper(keySpace);

        await _mapper.DeleteAsync<Test>("WHERE id = ?", id);
    }

    public async Task<Install> GetAsync(string id, string keySpace)
    {
        SetSessionAndMapper(keySpace);

        return await _mapper.FirstOrDefaultAsync<Test>("SELECT * FROM \"Test\" WHERE id = ?", id);
    }

    public async Task PostAsync(Test data, string keySpace)
    {
        SetSessionAndMapper(keySpace);

        await _mapper.InsertAsync(data);
    }

    private void SetSessionAndMapper(string keySpace)
    {
        var session = _cassandra.GetSession(keySpace);
        _mapper = new Mapper(session);
    }
}

Source: stackoverflow.com

Similar codes

1 vote98 views1 answer
How to show the value of a string in c#
C#
0 vote120 views1 answer
C# how to refresh input field
C#
0 vote131 views1 answer
Cannot implicitly convert type 'system.threading.tasks.task string ' to 'string' c#
C#
0 vote114 views1 answer
??= mean C#
C#
1 vote123 views1 answer
How to be like bill gates
C#
0 vote110 views1 answer
More than one migrations configuration type was found in the assembly 'EFCodeFirst'. Specify the name of the one to use
C#
3 votes110 views2 answers
C list add element
C#
0 vote126 views1 answer
Invert bool c#
C#
1 vote169 views1 answer
Unity gui text
C#Unity
10 votes132 views1 answer
Set width of rect transform unity
C#