<p>Can a Linq query retrieve BLOBs from a Sql Database?<br>
And how do they come out?</p>

[{'answer_id': 53889, 'author': 'aku', 'author_id': 1196, 'author_profile': 'https://Stackoverflow.com/users/1196', 'pm_score': 1, 'selected': False, 'text': "<p>If I'm not mistaken LINQ to SQL teats BLOB as System.Byte[]<br>\nI recall that there was some problem with SqlMetal, it generated wrong type for BLOB, but MSVS dmbl designer should work.</p>\n"}, {'answer_id': 53938, 'author': 'Chris Wenham', 'author_id': 5548, 'author_profile': 'https://Stackoverflow.com/users/5548', 'pm_score': 4, 'selected': True, 'text': "<p>LINQ-To-SQL classes create properties of type System.Data.Linq.Binary for all binary and varbinary fields in SQL-Server. The Binary type has a .ToArray() method that returns a byte[], and its constructor can take a byte[].</p>\n\n<p>Older versions of SQLMetal generated properties of type byte[], but the problem with these was that they failed in any joins. I think that's the main reason they replaced it with the IEquatable Binary type.</p>\n"}]
['https://Stackoverflow.com/questions/53873', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/-1/']