我的数据库中有一个WorkflowInstances表,该表包含以下字段:ID(int),Name(nvarchar(50),WorkflowID(int),文档(varbinary(MAX)))。
我想插入一个新的WorkflowInstance,所以我写了这段代码
Stream myStream = openFileDialogDoc.OpenFile();
if (myStream != null)
{
using (myStream)
{
WorkflowInstance w = new WorkflowInstance();
byte[] bytes = new byte[myStream.Length];
myStream.Read(bytes, 0, (int)myStream.Length);
w.ID = repository.WorkflowsRepository.GetMaxIDWokflowInstance() + 1;
w.Name = textBoxWorkflowInstanceName.Text;
w.CurrentStateID = repository.WorkflowsRepository.GetWorkflowFirstState((int)listBoxMyWorkflows.SelectedValue);
w.WorkflowID = (int)listBoxMyWorkflows.SelectedValue;
w.CreationDate = System.DateTime.Now.ToString();
w.Document = bytes;
RapidWorkflowDataContext context = new RapidWorkflowDataContext();
context.WorkflowInstances.InsertOnSubmit(w);
context.SubmitChanges();
}
}
我在第15行出现错误,错误是:无法将类型'byte []'隐式转换为'System.Data.Linq.Binary'
最佳答案
System.Data.Linq.Binary
的构造函数采用byte[]
的1个参数:
w.Document = new System.Data.Linq.Binary(bytes);