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