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");
}
}
