SQL Server and Large Objects

[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

 

[Miha Markic [MVP C#]]

Hi Xia,

You should use SqlDataReader with CommandBehaviour.SequentialAccess.

 

[Xia Wei]

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