从C#将byte []保存到SQL Server数据库中 [英] Save byte[] into a SQL Server database from C#

问题描述

如何将byte []数组保存到SQL Server数据库中? 该byte []包含一个HashAlgorithm值.

How can I save a byte[] array into a SQL Server database? This byte[] contains a HashAlgorithm value.

再次需要数据以供以后使用.因此，转换它而又不使其恢复到原来的状态，这不是我想要的.

The data is needed again for later use. So converting it and NOT getting it back in its original state, is not what I want.

提前谢谢！

推荐答案

您应该可以编写如下内容:

You should be able to write something like this:

string queryStmt = "INSERT INTO dbo.YourTable(Content) VALUES(@Content)";

using(SqlConnection _con = new SqlConnection(--your-connection-string-here--))
using(SqlCommand _cmd = new SqlCommand(queryStmt, _con))
{
   SqlParameter param = _cmd.Parameters.Add("@Content", SqlDbType.VarBinary);
   param.Value = YourByteArrayVariableHere;

   _con.Open();
   _cmd.ExecuteNonQuery();
   _con.Close();
}

使用Linq-to-SQL，您将编写如下内容:

Using Linq-to-SQL, you'd write something like this:

using(YourDataContextHere ctx = new YourDataContextHere())
{
   SomeClassOfYours item = new SomeClassOfYours();

   item.ByteContent = (your byte content here);

   ctx.SomeClassOfYourses.InsertOnSubmit(item);
   ctx.SubmitChanges();
}

这会将您的byte[]作为字节流插入到SQL Server表中类型为VARBINARY的列Content的列Content中，稍后您可以再次读取1:1.

That will insert your byte[] into a column Content of type VARBINARY in your SQL Server table as a byte stream, which you can read back 1:1 again later on.

这篇关于从C#将byte []保存到SQL Server数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！