Esempio n. 1
0
        public override async Task <Stream> GetLOB(uint oid, DBTransaction transaction, int bufferSize = 81920)
        {
            var command = (SqlCommand)transaction.AddCommand($"select oid, lob_data from db_lob where oid = @oid");

            command.Parameters.AddWithValue($"@oid", (long)oid);
            transaction.Reader = (IDataReader)await transaction.ExecuteQueryAsync(command, DBExecuteType.Reader, CommandBehavior.SequentialAccess);

            if (await transaction.ReadAsync())
            {
                return(((SqlDataReader)transaction.Reader).GetStream(1));
            }
            throw new Exception("No Data Found!");
        }