The .NET Data Provider for Teradata supports retrieving LOBs from the Advanced SQL Engine. You can specify two different modes for handling large objects:
Inline Mode
Deferred Mode
Using LOBs as Input, InputOutput, and Output Parameters
Potential Conflicts