5

I have a WorkflowInstances table in my DB which contains this fields: ID (int), Name (nvarchar(50), WorkflowID (int), Document (varbinary(MAX))). I want to insert a new WorkflowInstance so I wrote this code

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();
                }
            }

I got an error in line 15, the error is: Cannot implicitly convert type 'byte[]' to 'System.Data.Linq.Binary'

Anas Salem
  • 177
  • 1
  • 2
  • 13

1 Answers1

12

System.Data.Linq.Binary has a constructor taking 1 argument of byte[]:

w.Document = new System.Data.Linq.Binary(bytes);
King King
  • 61,710
  • 16
  • 105
  • 130