实体数据模型 (edmx) 服务返回 sql server 2008 图像类型作为 iPhone SDK 通过 NSURLConnection 的二进制访问

Question

我有一个 sql 图像类型字段在 EDM（实体数据模型）.NET 服务调用中返回。图像字段在 sql server 2008 中以二进制形式存储。但是，我不确定图像数据发生了什么，或者编码类型是什么。由于网络服务是在幕后生成的，因此在通过网络发送图像二进制数据之前，我无法弄清楚该服务是否对图像二进制数据做了一些奇怪的事情。

有人做过类似的事情吗？

我尝试过对图像进行base64解码，尝试将NSURLConnection请求编码设置为NSUTF8StringEncoding，但都没有成功

这是一个示例数据包嗅探：

HTTP/1.1 200 OK 日期：2010 年 3 月 9 日星期二 19:41:13 GMT 服务器：微软-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-版本：2.0.50727 数据服务版本：1.0； 缓存控制：无缓存 内容类型：application/json;charset=utf-8 内容长度：41809

{“d”：[ { “__元数据”：{ "uri": "http://11.111.11.111:8002/domain /myservice.svc/StudentByGroupID(createDate=datetime\'2009-12-15T11%3A16%3A18.14\',firstName=\'年松\',groupId=1,isActive=1,lastName=\'刘\',studentGroupId=28,studentId=6)", "type": "MyModel.StudentByGroupID" }, "studentId": 6, "firstName": "念松", "lastName": "刘", "createDate": "/Date(1260875778140)/", "updateDate": null, "isActive": 1, " image": "AAEAAAD/////AQAAAAAAAAAMAgAAAFFTeXN0ZW0uRHJhd2luZywgVmVyc2lvbj0yLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWIwM2Y1ZjdmMTFkNTBhM2EFAQAAABVTeXN0ZW0uRHJhd2luZy5CaXRtYXABAAAABERhdGEHAgIAAAAJAwAAAA8DAAAABA0AAAL/2P/gABBKRklGAAEBAAABAAEAAP/bAEMACQYHCAcGCQgHCAoKCQsNFg8NDAwNGxQVEBYgHSIiIB0fHyQoNCwkJjEnHx8tPS0xNTc6OjojKz9EPzhDNDk6N//bAEMBCgoKDQwNGg8PGjclHyU3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3N//AABEIAGcAfwMBIgACEQEDEQH/xAAfAAABBQEBAQEBAQAAAAAAAAAAAQIDBAUGBwgJCgv/xAC1EAACAQMDAgQDBQUEBAAAAX0BAgMABBEFEiExQQYTUWEHInEUMoGRoQgjQrHBFVLR8CQzYnKCCQoWFxgZGiUmJygpKjQ1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4eLj5OXm5+jp6vHy8/T19vf4+fr/xAAfAQADAQEBAQEBAQEBAAAAAAAAAQIDBAUGBwgJCgv/xAC1EQACAQIEBAMEBwUEBAABAncAAQIDEQQFITEGEkFRB2FxEyIygQgUQpGhscEJIzNS8BVictEKFiQ04SXxFxgZGiYnKCkqNTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqCg4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2dri4+Tl5ufo6ery8/T19vf4+fr/2gAMAwEAAhEDEQA/APbd1JuplBpiHbqZN80TClpHGUb6UMDwbxCNuoMB6Y/IkVZ8P6NcasJVhwkaffkboucYHuTg8VF4lVv7RkCgsSWGB1PzGvRNM0v+ w9AS3Hy3G3dKynkORgnPqB8o+ma8OnSVSTvsj2p1eSCtuzz7ULEWWqCGfLkkZKnATHGScH8QKj1q0sYX2Rq0b85O4nnv+tWPEE7QFWZcrtCgAfwnJP8A6F+lUNTgmdPtLZLI4JHrx/Xj861UILSKI c5dTDurKdc7c7h2Pf8AGsuW7dg0T5ByoIPbArtLeNHWSBiCYsFW/vRNyp/AnFcr4ls/s97DOowJG2t/vD/638q6KUruzMKl0robZPtkUjsa6SzuyFHOa5SJip4rTtbg4FVUjcmErHSC79TWjpt1kEZ/irl0nz +FaemT5J571zuNja9y14ycNbacfS6/9lNYulrta44B/fd+3Mn+FaXin5rKxb+7cj8OKz9LOJLoZwPOXqP+uhrGr/DZpS3R9DZozzTe1NJ5r3DxyYGkJyrD2pqnmlH8Q9jQB5LJAJPHFnEwyPt mTjvtcn+ldxq1wFaRM53gqMfgP6/rXJxx5+IMJKj5LiYn2+9/iK3pW83Ub0kf8e4+Tvndwf1SvHTcYtLuenNXlG/ Y5jW7izZiLiPB8skDHQYyP0Arn9R1iFbdUjGFChcemGBz+GBWvLqIvNYNhNbbmADfvIBg+mec/hiszxN5NneRwvaxHeOFCgCsIxkpam1o23MS3v0FxESdoAMZ/wBzP9Mn8hTdfxcabvx8yOjH2OcH+t RxbL5X2wFdynadmMHBxzk96jaf7RZTqT8wHz/725q7NmmYvZoyVPSp4WINQL0FTRc10s50XY5SK1NKkzJzzWOvWtbSF/e9KwqbG0dzU8SZOlW59LlOnes3T8fa7oE/8tFOfwb/ABrV8SJjRYj6 XEf88Vl6fn7ddgD+IH36D/GuOr8L/rsdFPf+vM+hMUhXkVLSYr3TxhoFKv3qcBQBzQBwEUQXx zKNvJZmJ9i6f4irefI8SXPXEqMpHbIO4H8iRVS5uI7TxmzNwZZ1XOe2FP8AMAVb11WiuxdQ4J +U89Mj+hHFePU0V10Z6S3V+qKdxFbJd+cUBcfxbea5LxJ/pGpqVjkZwVKAqVOD1/KumlL3ISW2cxB8sdwyR7Vyeqi6gulmnuiyq5OwgcjPsOtYtu+h1Riu5DJMluZFVVGxSWwOuOa5K14s 3fdnzDjPqd3NXNau8QzCMk+b8pJ7A1WbasVtax8kHf8AhXVSi1DU560k5aFECHFWIetQsRvbHq aliPpXUzmRbiGSK3dGQeZmsKI8iug0VhvxntXPV2N4Gj4oXGgZHaeI/wDj1Y9gR/af4T3AOfwT/ GT/xIobw7P7PGef98Vz9gSt/dnt5IP/AKLrkqfC/R/obw/y/U+iKSlpK908YWkHWlpskixI0khCogJY+gFIDyjxwl0PEbfYo3eRZEcbR6KME+gz3PFdBOZtR0eW43pbsJABwXUd2A6eo/XqKp+Mt QjYNJD5gBbDKB1Jxgk9R0x+Ncnda0JdJtrV4DG63AjSUHGOSxyPz/SUR4aKUpPW56UW24weljoru9Wzt4xJD5cBGI3Byrden5Gudv1tb2TfGCe+Nx61pX2mx3lmY2Ziz4JfdklgODzWBLbXelKzg b0YHRNJII9YP5Z7/Tnhnh3f3TuUOVaEF1ZW7pFaXH2aLzN2XlkClScYJ9MY6Hrn3rQl8JRR6a0MG8XkqEJMWwAexHt9O2ax7m2yBJI7SED7zfn/AF/nVAzTwaN5FxPGJAOUSVLDHHyg4P1NddCm krHLiVyu5mXFvNZ3EltcoY5Ym2up7H/D3pYmq7a2L6lamQyFrrcxyxzuHUA/rzWeMo2GBBBwQe1bNdDls0k+jLqNitfSZ9swFYUb8CrlnLtkBrKcbouL1Oy1qTzPDt1z0CH/AmeFYVsT9vnAxzAP/ ZP8KtXFzv0K8Un/AJZf4VStmzqRx3t0/ H/OK4aq0fo/0Oqn/kfROaKonV9NAz9utyPaQH+VQv4g0xDzcg8Z4Rjn9K9lziup5ChLsatYfiu7MFhsXBLHJH97HRfxbH4A1HN4t0uL/n4bjtFj8OSKyNWv11K8gmjDLCsQdFbrkjI/nUS qRasmdOGoy9onJaIw7ptt2ttL8+9Qu44+Yjg57YIwfzrJuLKwFw8lxMTCHCmPdhUJIxyevJXnP StjWjBaRNNKMtbRgn8RnFcvPqrjTryyuIEk+1IrmQ9Yifm49cDBA459uKySk3ZHfVkopSsbEk9i R8t7EM9MTjmo21m2h027tTdwyJcocoxBJwpwP1H6VxriKNZA7ScgAZQDAPQ/rVSUqNrN5jZJYfKPTFaexRi8XJqzRv2s9lHIk1xEzbBuG8HHb+fFU51spoZ3MmVbLK24kZ5BGccHI/UHvWG0b SOI41kyk7B8uc5Of6/pTDdytAlszkRBFGB2AO7/wBCpOnbYzliXLdI63S7dbTS57vAy6hYxuzyT1/Miue1yAwXm7GN/wCvT/H9K6PW2Gn2VjaRHIJDc9wOefxxVDxXAUtrWY9Wxn8jWUXrqdVaC9 m0uhzqNirEUmGFVAaej81o0cCZu+eTpt0uesLDr7GpNOYtqkQBILQqP0asqOb9xKp7xsMfhV7T JUXULJmIAaLknHo1claGjOmlLVEjX943L3cxPvIaj82VvvSuR7saE0rVn+7pt4fpa3+FTr4f15 /u6TefjERVciGplZpJCp+djxx8xr1iytxHsVuEjVYwPXaAP6V5zF4Y8QEgnSbgAHncAP616Nc3UWnWtxql02FjJ8oepzxitKcUrmkZX为什么XjHUS+rT2a4KTFVYKMkMOB36YxWAql7iSJn 3LEoTAweBx69wKl3Mbk6heuI5ppCI1Pbgk/p/ MVSgYs905+bL4Xdz3z/St6CesjPFOzUew43NzHPIjTsQRx8oAOOmOKoSXMrTBNxx34q9MqlVYcsQRkdsZ/wrMJ2yMSMN27jrWzVjjbK95PIxVAx3Kepx7Yqhc7/MPXOKutjyyx5JJFV2AMse0Do RxUEM6qBZNTubeaQ7ooERBz14BP8AMVb8XfvLFgB9zafphgP61n+D3Z4pIgfvjeM9iOD/AERT1rM2mzqVw/lsDn2GQf0rl2keuvfot9zic0oOGpmaaSwzjk1ueVctJKBkM3UYqe2mZhaMDjEZwfx /+vVS2+yMw+2faQf9jH+FaUcGjbFHmaiNowBsBArKpbZo1p36M2JPFGuvw+qXOD285h/Kqr61qT58zUp29mmc/wBaKKzUUza9iJLq4nkWNJ9zyMFUHPJPA6n3rvtSkF7dRfahm3iiMsUI6Y/vn3 Y9B2HXnoUU+RRWh04eTle5xUpe4vbd52+d2LRgdEABOfxI/KhFkhXI+bcOSD3/AP1Giiuql8JyV9ZsJtqxY2HeWJJfnnOeBkgdaz7hFMucZ5+X8/8A9VFFaNHOUpQqx7CD6n8qrMpMg55yQAfWiioJ Og8JsXtg8OBcQyMy56OuRkH8/wBa3NRkWZEZOFkJ3KR/n1oorm +0etR/hI4DpgUoIoorY8ok2hsAitzQRGtpGZEBHIL7FJyMjv1oorCt8BtR+I//2Qs=”，“studentGroupId”：28，“groupId”：1 } ] }

Answer 1

该返回是 JSON 有效负载 (application/json)，其中包含 UTF-8 上的 Base64 编码图像8 字符集。如果您不想自己解析 JSON，可以使用 json-framework 您可以尝试，或者 TouchJSON。

Answer 2

这是.net图像相关代码：

Codes for saving images into database
System.Drawing.Image img = System.Drawing.Image.FromFile(imgPath);// “imgPath” is the file path of a temporary image uploaded by a user.
student.image = new System.Data.Linq.Binary(Utility.Convertor.ImageToByteArray(img));
img.Dispose();
Codes for writing image bytes from server to client
System.Drawing.Image img = Utility.Convertor.ByteArrayToImage(stu.image.ToArray());
Response.ContentType = ("image/" + Utility.Gadget.GetImageFormat(img));
MemoryStream ms = new MemoryStream();
img.Save(ms, img.RawFormat);
byte[] result = ms.ToArray();
ms.Close();
ms.Dispose();
Response.BinaryWrite(result);

Below are encapsulated methods for storing / restoring students’ images:
Serializer for serializing a image to bytes
/// 
/// Convert a System.Drawing.Image object to byte array formatted by System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.
/// 
/// 
/// 
public static byte[] ImageToByteArray(System.Drawing.Image imageIn)
{
      BinaryFormatter sf = new BinaryFormatter();
      MemoryStream ms = new MemoryStream();
      sf.Serialize(ms, imageIn);
      byte[] result = ms.ToArray();
      ms.Close();
      ms.Dispose();
      return result;
}
Deserializer for restoring a image from bytes
/// 
/// Convert a byte array formatted by System.Runtime.Serialization.Formatters.Binary.BinaryFormatter to a System.Drawing.Image object.
/// 
/// 
/// 
public static System.Drawing.Image ByteArrayToImage(byte[] byteArrayIn)
{
       BinaryFormatter sf = new BinaryFormatter();
       MemoryStream ms = new MemoryStream(byteArrayIn);
       System.Drawing.Image returnImage = (System.Drawing.Image)sf.Deserialize(ms);
       ms.Close();
       ms.Dispose();
       return returnImage;
}