public Startup(IConfiguration configuration) { Configuration = configuration; String create_keyspace = @"CREATE KEYSPACE IF NOT EXISTS driver_test WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy', 'DC1' : 1 } ; "; String create_user_table = @"CREATE TABLE IF NOT EXISTS driver_test.user ( id uuid, first_name text, last_name text, PRIMARY KEY (id) );"; IDseCluster cluster = DseCluster.Builder() .AddContactPoint("127.0.0.1") .Build(); IDseSession session = cluster.Connect(); session.Execute(create_keyspace); session.Execute(create_user_table); session.Dispose(); }
public string Get(Guid id) { IDseCluster cluster = DseCluster.Builder() .AddContactPoint("127.0.0.1") .Build(); IDseSession session = cluster.Connect(); var get_user = session.Prepare("SELECT * FROM driver_test.user where id = ?"); RowSet results = session.Execute(get_user.Bind(id)); if (results.Any()) { session.Dispose(); Row user = results.First(); return(user.GetValue <String>("first_name") + user.GetValue <String>("last_name")); } else { session.Dispose(); return("User not found"); } }