public void SetUp()
{
_column = new ColumnBuilder()
.WithName("Column 1")
.WithDataType(typeof(string))
.Build();
_columns = new List <Column> {
_column
};
_dataTypes = new List <Type> {
typeof(string)
};
_row = new RowBuilder()
.WithId(1)
.WithField("Field 1")
.Build();
_xRow = new XElement("row",
new XElement("id", _row.Id),
new XElement("fields",
new XElement("column-1", "Field 1")));
_serializer = new RowSerializer(
new PropertySerializer(null));
}
public async Task <int> LoadSingleQueryRow(byte[] buffer, CancellationToken ct = default)
{
using (var db = _dbProvider.CreateConnection())
{
Debug.Assert(db != null);
db.ConnectionString = _connectionString;
using (var cmd = CreateSingleQueryCommand(db, _random.Next(1, 10001)))
{
await db.OpenAsync(ct);
using (var reader = await cmd.ExecuteReaderAsync(ct))
{
if (_objectWriter is null)
{
_objectWriter = new ObjectWriter(RowSerializer.For(reader, true), 1024);
}
return(await _objectWriter.WriteSingle(reader, buffer, ct));
}
}
}
}
public async Task SqlDataReader_RowSerializer_Works()
{
int written = 0;
byte[] buffer = new byte[8192];
using (var cn = new SqlConnection("data source=tcp:localhost;initial catalog=Beeline;integrated security=false;user=sa;password=S3cr3tSqu1rr3l"))
using (var cmd = cn.CreateCommand())
{
cmd.CommandText = "SELECT Id, Name, ByteValue, ShortValue, LongValue, DecimalValue, FloatValue, DateTimeValue, DateTime2Value, DateTimeOffsetValue, UnicodeName, LongStringValue FROM Test";
cmd.CommandType = CommandType.Text;
await cn.OpenAsync();
using (var reader = await cmd.ExecuteReaderAsync())
{
var actual = RowSerializer.For(reader);
while (await reader.ReadAsync())
{
written = actual.Write(reader, buffer);
}
}
}
Assert.NotEqual(0, written);
var json = Encoding.UTF8.GetString(buffer, 0, written);
var jobj = JObject.Parse(json);
Assert.Equal(1, jobj.Value <int>("Id"));
Assert.Equal("Bob", jobj.Value <string>("Name"));
Assert.Equal(255, jobj.Value <byte>("ByteValue"));
Assert.Equal(12345, jobj.Value <short>("ShortValue"));
Assert.Equal(123456789, jobj.Value <long>("LongValue"));
Assert.Equal(12345678m, jobj.Value <decimal>("DecimalValue"));
Assert.InRange(jobj.Value <double>("FloatValue"), 12345678d, 12345679d); // Serializer doesn't do all the digits
Assert.Equal(new DateTime(2018, 1, 4, 0, 0, 0), jobj.Value <DateTime>("DateTimeValue"));
Assert.Equal(new DateTime(2018, 1, 4, 0, 0, 0), jobj.Value <DateTime>("DateTime2Value"));
Assert.Equal(new DateTimeOffset(2018, 1, 4, 0, 0, 0, TimeSpan.Zero), jobj.Value <DateTime>("DateTimeOffsetValue"));
Assert.Equal("Bob", jobj.Value <string>("UnicodeName"));
Assert.Equal("We love Bob", jobj.Value <string>("LongStringValue"));
}
private static ArrayWriter CreateWriter(DbDataReader reader)
{
var serializer = RowSerializer.For(reader, true);
return(new ArrayWriter(serializer, 1024));
}