使用SQL Filestream时出现OutOfMemoryException

钟情文君

我正在尝试将一个约600 MB的zip文件上传到SQL 2008
FILESTREAM表，但出现OutOfMemoryException。我使用一个SqlFileStream类上传的文件（在本教程中描述-
http://www.aghausman.net/dotnet/saving-and-retrieving-file-using-filestream-
sql-server-2008.html）
。如果有问题，我有一台具有4GB内存的32位Vista计算机，并且正在使用VS 2010，Entity Framework 4。
这是我的代码段-
public static void AddItem(RepositoryFile repository)
{
      var contents = repository.Data; // I get the exception at this line.
      repository.Data = System.Text.Encoding.ASCII.GetBytes("0x00");
      using (var scope = new TransactionScope())
      {
         using (var db = new MyEntities())
         {
            db.RepositoryTable.AddObject(repository);
            db.SaveChanges();
         }
         using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
         using (var cmd = new SqlCommand("SELECT Data.PathName(), GET_FILESTREAM_TRANSACTION_CONTEXT() FROM dbo.RepositoryTable", con))
         {
            cmd.Connection.Open();
            using (var reader = cmd.ExecuteReader())
            {
                  while (reader.Read())
                  {
                     var path = reader.GetString(0);
                     var transactionContext = reader.GetSqlBytes(1).Buffer;
                     var fileStream = new SqlFileStream(path, transactionContext, FileAccess.Write);
                     fileStream.Write(contents, 0, contents.Length);
                     fileStream.Close();
                  }
            }
         }
         scope.Complete();
      }
}
如何上传文件而没有任何错误？
谢谢！

解决方案:


            我发现了问题。这是我的代码-
private void AddFile()
{
      if (!fupFile.HasFile)
      {
         lblMessage.Text = &quot

lease select a file.";
         return;
      }
      var data = new byte[(int) fupFile.FileContent.Length];
      fupFile.FileContent.Read(data, 0, data.Length);
      if (fupFile.FileContent.Length > 0)
      {
         var repositoryFile = new Repository
                                 {
                                       ID = Guid.NewGuid(),
                                       Name = Path.GetFileName(fupFile.PostedFile.FileName),
                                       Data = System.Text.Encoding.ASCII.GetBytes("0x00")
                                 };
         RepositoryController.AddItem(repositoryFile, data); // Calling DAL class.
      }
}
// DAL method
public static void AddItem(RepositoryFile repository, byte[] data)
{
using (var scope = new TransactionScope())
{
      using (var db = new MyEntities()) // DBContext
      {
         db.RepositoryTable.AddObject(repository);
         db.SaveChanges();
      }
      using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
      using (var cmd = new SqlCommand(string.Format("SELECT Data.PathName(), GET_FILESTREAM_TRANSACTION_CONTEXT() FROM dbo.RepositoryTable WHERE ID='{0}'", repository.ID), con)) // "Data" is the column name which has the FILESTREAM. Data.PathName() gives me the local path to the file.
      {
         cmd.Connection.Open();
         using (var reader = cmd.ExecuteReader())
         {
            while (reader.Read())
            {
                  var path = reader.GetString(0);
                  var transactionContext = reader.GetSqlBytes(1).Buffer;
                  var fileStream = new SqlFileStream(path, transactionContext, FileAccess.Write);
                  fileStream.Write(contents, 0, contents.Length); //Write contents to the file.
                  fileStream.Close();
            }
         }
      }
      scope.Complete();
}
}

使用SQL Filestream时出现OutOfMemoryException

钟情文君 LV1