private void OnCreateCommand()
{
SingleCommand = new Npgsql.NpgsqlCommand();
SingleCommand.CommandText = "SELECT id, randomnumber FROM world WHERE id = @Id";
mID = new Npgsql.NpgsqlParameter <int>("@Id", _random.Next(1, 10001));
SingleCommand.Parameters.Add(mID);
FortuneCommand = new Npgsql.NpgsqlCommand();
FortuneCommand.CommandText = "SELECT id, message FROM fortune";
}
private void OnCreateCommand()
{
SingleCommand = new Npgsql.NpgsqlCommand();
SingleCommand.CommandText = "SELECT id, randomnumber FROM world WHERE id = @Id";
var id = SingleCommand.CreateParameter();
id.ParameterName = "@Id";
id.DbType = DbType.Int32;
id.Value = _random.Next(1, 10001);
SingleCommand.Parameters.Add(id);
FortuneCommand = new Npgsql.NpgsqlCommand();
FortuneCommand.CommandText = "SELECT id, message FROM fortune";
}
DbCommand CreateReadCommand(DbConnection connection)
{
var cmd = connection.CreateCommand();
cmd.CommandText = "SELECT id, randomnumber FROM world WHERE id = @Id";
var id = cmd.CreateParameter();
id.ParameterName = "@Id";
id.DbType = DbType.Int32;
id.Value = _random.Next(1, 10001);
cmd.Parameters.Add(id);
return(cmd);
}
public async Task <World> LoadSingleQueryRow()
{
using (var db = new NpgsqlConnection(_connectionString))
{
await db.OpenAsync();
using (var cmd = CreateReadCommand())
{
cmd.Connection = db;
cmd.Parameter.TypedValue = _random.Next(0, 10000) + 1;
return(await ReadSingleRow(cmd));
}
}
}
public async Task <World[]> LoadMultipleQueriesRows(int count)
{
var result = new World[count];
using (var db = new NpgsqlConnection(_connectionString))
{
await db.OpenAsync();
var(cmd, idParameter) = CreateReadCommand(db);
using (cmd)
{
for (int i = 0; i < result.Length; i++)
{
result[i] = await ReadSingleRow(cmd);
idParameter.TypedValue = _random.Next(1, 10001);
}
}
}
return(result);
}