Linq查询可以从Sql数据库检索BLOB吗? [英] Can a Linq query retrieve BLOBs from a Sql Database?

问题描述

Linq查询可以从Sql数据库中检索BLOB吗?
以及它们如何出来?

Can a Linq query retrieve BLOBs from a Sql Database?
And how do they come out?

推荐答案

LINQ-To-SQL类为SQL-Server中的所有二进制和varbinary字段创建类型为System.Data.Linq.Binary的属性.二进制类型具有一个.ToArray()方法，该方法返回byte []，其构造函数可以采用byte [].

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[].

SQLMetal的较旧版本生成类型为byte []的属性，但是这些问题是它们在任何联接中均失败.我认为这是他们将其替换为IEquatable Binary类型的主要原因.

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.

这篇关于Linq查询可以从Sql数据库检索BLOB吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！