SQL Server and Large Objects

  • Thread starter Thread starter Xia Wei
  • Start date Start date
X

Xia Wei

Hi group:

These days I'm puzzled about the data type of "image". I created a column
with this type in the database, but how to pass data using ADO.NET?

I know that passing byte[] to SqlParameter is OK, but if the data is very
large, such as 1GB, then I system might be crash.

Is there any better way to fix this problem?
Thank you very much!

Regards,
Sunmast
 
Hi Xia,

You should use SqlDataReader with CommandBehaviour.SequentialAccess.
 
Hi, Thanks for your reply!

But that didn't slove my problem.
Now I have known that how to read large objects from database.
Actually I want to how to upload large objects to database...
Since I can't put any large objects in the byte array, I image there might
be some operations like stream, but I didn't find how to do this.

Or this is a bug/limitation of ADO.NET system? I know this can be done very
easily in ADO v2.5.

Thanks,
Sunmast


----- Original Message -----
From: "Miha Markic [MVP C#]" <miha at rthand com>
Newsgroups: microsoft.public.dotnet.framework.adonet
Sent: Wednesday, March 23, 2005 4:41 PM
Subject: Re: SQL Server and Large Objects
 
Back
Top