sql-server – 如何使用过程保存byte []？

发布时间：2020-12-12 06:32:49 所属栏目：MsSql教程来源：网络整理

导读：这个存储过程不保存数据,这似乎是VARBINARY的一个问题.我传递一个byte [],但它不起作用.如果我将此参数发送为NULL,则可以正常工作. 我用以下代码调用该过程： public Community AddCommunity(string name,string description,byte[] picture,User owner,int?

这个存储过程不保存数据,这似乎是VARBINARY的一个问题.我传递一个byte [],但它不起作用.如果我将此参数发送为NULL,则可以正常工作.

我用以下代码调用该过程：

public Community AddCommunity(string name,string description,byte[] picture,User owner,int? venue,int communityID) 
{
    using (var database = new Database())
    {
        return database.Scope.GetSqlQuery<Community>("QP_AddCommunity ?,?,?","VARCHAR Name,VARCHAR Description,VARBINARY Picture,INTEGER Owner,INTEGER Venue,INTEGER ID").GetResult(name,description,picture,owner.ID,venue,communityID);
    }
}

程序如下：

CREATE PROCEDURE [dbo].[QP_AddCommunity]
    @Name VARCHAR(120),@Description VARCHAR(MAX),@Picture VARBINARY(MAX),@Owner INTEGER,@Venue INTEGER,@ID INTEGER

AS
BEGIN
    SET NOCOUNT ON;

    IF(SELECT COUNT(*) FROM QT_Community WHERE ID = @ID) = 0
        INSERT INTO QT_Community(Name,[Description],Picture,[Owner],Venue) VALUES(@Name,@Description,@Picture,@Owner,@Venue);

    ELSE
        UPDATE QT_Community SET Name = @Name,[Description] = @Description,Picture = @Picture,[Owner] = @Owner,Venue = @Venue WHERE ID = @ID;

    SELECT * FROM QT_Community WHERE ID = @@IDENTITY;


END

这段代码出了什么问题？ VARBINARY不是一个字节[]？

此代码在SQL Server Management Studio上执行时有效.

DECLARE @X varbinary(20)
Set @X = CAST('Testing' As varbinary(20))
EXECUTE [QP_AddCommunity] 'aaaaa','descricao',@X,216,NULL,0;

但是当使用getSqlQuery方法调用byte []上的某些东西时,事务表明它不是活动的而且不是脏的.但是如果byte []为null,它就可以正常工作.

解决方法

我发现这是不可能的,如 this answer所示

Hello gaurav,currently our GetSqlQuery method cannot operate properly with parameters of type LongVarBinary or VarBinary,thus making it impossible for the stored procedure to work as expected. We are aware of this problem and we are working on fixing it. As a work around you should try and use Linq to achieve your goal. Greetings,Petar the Telerik team

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!