Hello everybody,

i am working on a Document Management System with Asp.Net 2.0 , C# and Oracle and i like to do the same wich is described in this article(http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=414) . it works good. The big problen is, that i like to upload more than 10.000 Documents (this is once task). How to do that?I have a table in my oracle database with the follow properties (Document_id, Document_name , Document_type, Content.type, Blob). The 10.000 files (e.g. *.pdf, *doc, *.ppt) is storing in my Harddisk. How to do that with C#.Please help me, i am writing my Master and i dont make any progress.

I have an idea, ex. to store this information in an array an then give him to an oracle procedure



CREATE PROCEDURE sprocFilesInsertSingleItem

  id uniqueidentifier,

  fileData blob (max),
  originalName nvarchar(50),
  contentType nvarchar(50)

AS

INSERT INTO Files
(
  Id,

  FileData,
  OriginalName,
  ContentType
)
VALUES
(
  :id,

  :FileData,
  :originalName,
  :contentType
)

Is a database really the best place to store all that content?! Why not FTP and then run a script to update the DB with the file paths? Yeah you would need to be careful on the dependancy, but thats what a management system is for ;)

Rob
http://cantgrokwontgrok.blogspot.com