public async override Task <World> Get(NullRequest request, ServerCallContext context)
{
using (var db = Npgsql.NpgsqlFactory.Instance.CreateConnection())
{
db.ConnectionString = Program.ConnectionString;
var cmd = db.CreateCommand();
cmd.CommandText = "SELECT id, randomnumber FROM world WHERE id = @Id";
var id = cmd.CreateParameter();
id.ParameterName = "@Id";
id.DbType = DbType.Int32;
id.Value = new Random().Next(1, 10001);
cmd.Parameters.Add(id);
await db.OpenAsync();
using (var rdr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleRow))
{
await rdr.ReadAsync();
return(new World
{
Id = rdr.GetInt32(0),
RandomNumber = rdr.GetInt32(1)
});
}
}
}
public async override Task <ListReply> ListDB(NullRequest request, ServerCallContext context)
{
ListReply reply = new ListReply();
using (var db = Npgsql.NpgsqlFactory.Instance.CreateConnection())
{
db.ConnectionString = Program.ConnectionString;
var cmd = db.CreateCommand();
cmd.CommandText = "SELECT id, message FROM fortune";
var id = cmd.CreateParameter();
id.ParameterName = "@Id";
id.DbType = DbType.Int32;
id.Value = new Random().Next(1, 10001);
cmd.Parameters.Add(id);
await db.OpenAsync();
using (var rdr = await cmd.ExecuteReaderAsync(CommandBehavior.CloseConnection))
{
while (await rdr.ReadAsync())
{
reply.Items.Add(new Fortune
{
Id = rdr.GetInt32(0),
Message = rdr.GetString(1)
});
}
}
}
return(reply);
}
public Response XMethod(NullRequest request)
{
return(Execute <NullRequest, XResponse>(request, response =>
{
Test1();
}));
}
public override void Null(Google.ProtocolBuffers.IRpcController controller, NullRequest request, Action<NO_RESPONSE> done)
{
throw new NotImplementedException();
}
public override void Null(IRpcController controller, NullRequest request, Action<NO_RESPONSE> done)
{
ProtoOutputBuffer.Write(request.GetType(), request.ToString());
}
// Server side handler of the SayHello RPC
public override Task <NullReply> SayHello(NullRequest request, ServerCallContext context)
{
return(Task.FromResult(new NullReply()));
}
public override void Null(IRpcController controller, NullRequest request, Action <NO_RESPONSE> done)
{
ProtoOutputBuffer.Write(request.GetType(), request.ToString());
}
public override void VisitNullDescription(NullRequest element)
{
}
public override void Null(IRpcController controller, NullRequest request, Action<bnet.protocol.NO_RESPONSE> done) {
throw new NotImplementedException();
}
public override void Null(Google.ProtocolBuffers.IRpcController controller, NullRequest request, Action <NO_RESPONSE> done)
{
throw new NotImplementedException();
}
public override void Null(IRpcController controller, NullRequest request, Action <bnet.protocol.NO_RESPONSE> done)
{
throw new NotImplementedException();
}
public abstract void VisitNullDescription(NullRequest element);
