public void CanInsertAndSelectByteArray()
{
var orig = new TypeWithByteArrayField { Id = 1, Content = new byte[] { 0, 17, 0, 17, 0, 7 } };
using (var db = ConnectionString.OpenDbConnection())
{
db.CreateTable<TypeWithByteArrayField>(true);
db.Save(orig);
var target = db.GetById<TypeWithByteArrayField>(orig.Id);
Assert.AreEqual(orig.Id, target.Id);
Assert.AreEqual(orig.Content, target.Content);
}
}
private static void _insertManually(TypeWithByteArrayField orig, System.Data.IDbConnection db)
{
using(var cmd = db.CreateCommand()) {
cmd.CommandText = @"INSERT INTO ""TypeWithByteArrayField"" (""Id"",""Content"") VALUES (@Id, @Content) --manual parameterized insert";
var p_id = cmd.CreateParameter();
p_id.ParameterName = "@Id";
p_id.Value = orig.Id;
cmd.Parameters.Add(p_id);
var p_content = cmd.CreateParameter();
p_content.ParameterName = "@Content";
p_content.Value = orig.Content;
cmd.Parameters.Add(p_content);
cmd.ExecuteNonQuery();
}
}
private static void _selectAndVerifyManually(TypeWithByteArrayField orig, System.Data.IDbConnection db)
{
using(var cmd = db.CreateCommand()) {
cmd.CommandText = @"select ""Content"" from ""TypeWithByteArrayField"" where ""Id"" = 1 --manual select";
using(var reader = cmd.ExecuteReader()) {
reader.Read();
var ba = reader["Content"] as byte[];
Assert.AreEqual(orig.Content.Length, ba.Length);
Assert.AreEqual(orig.Content, ba);
}
}
}
