Saving file from SQL Server into Memory Stream in C#

Question

I've method which saves the file saved in db into file on disk. How would I modify it so method returns MemoryStream?

    public static void databaseFileRead(string varID, string varPathToNewLocation) {
        using (var varConnection = Locale.sqlConnectOneTime(Locale.sqlDataConnectionDetailsDZP))
        using (var sqlQuery = new SqlCommand(@"SELECT [RaportPlik] FROM [dbo].[Raporty] WHERE [RaportID] = @varID", varConnection)) {
            sqlQuery.Parameters.AddWithValue("@varID", varID);
            using (var sqlQueryResult = sqlQuery.ExecuteReader()) {
                if (sqlQueryResult != null) {
                    sqlQueryResult.Read();
                    var blob = new Byte[(sqlQueryResult.GetBytes(0, 0, null, 0, int.MaxValue))];
                    sqlQueryResult.GetBytes(0, 0, blob, 0, blob.Length);
                    using (var fs = new FileStream(varPathToNewLocation, FileMode.Create, FileAccess.Write)) {
                        fs.Write(blob, 0, blob.Length);
                    }
                }

            }
        }
    }

TFD · Accepted Answer · 2010-03-03 10:57:07Z

2

Change FileStream to MemoryStream. Declare the stream object at the top level of the method and use it on the return statement

answered Mar 3, 2010 at 10:57

TFD

24.7k2 gold badges36 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

dovla110010101 Over a year ago

it would be excellent if someone could paste entire code, so others can study how it is done... There are also young programmers on Stackoverflow who doesn't have any experience with memorystream and getting data from Blob file...

Collectives™ on Stack Overflow

Saving file from SQL Server into Memory Stream in C#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related