Attachment in asp.net

Question

0.00/5 (No votes)

See more:

Hi All ,

I need to attach document for some say id..
but which way i should do it by coping byte content to the Database or should we create a copy to the our server and while reading we can read from file.What should be the best approach?

Thanks,

Amit

Posted 31-Aug-10 20:11pm

Amit Patel1985

Updated 31-Aug-10 20:34pm

v2

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Hiren solanki · Answer 1 · 2010-08-31T20:37:00

Solution 1

I think the best approch would be to Store it in DB,
for the reason you can Move your DB anywhere, No Need to take care of File location, and will be safe from deletion, and will be Confidential.

Thanks

Posted 31-Aug-10 20:37pm

Hiren solanki

Comments

Amit Patel1985 1-Sep-10 3:03am

but per file size can be 10 MB or more and file can be multiple so it will increase size of database so is it best way to create a root folder for attachment and do .

Hiren solanki 1-Sep-10 6:01am

yes, you are right, but as you will store it on disk then it will need that much space too. then why not to store it in DB.
Makes sense.

Sandesh M Patil · Answer 2 · 2010-09-01T00:07:00

Solution 2

It doesn't make sense. To access such file from db more processing time reqd.

So my suggestion is to place such file in a folder and only copy the path of that file in db.

Hope this may help u.. :)

Posted 1-Sep-10 0:07am

Sandesh M Patil

Comments

Christian Graus 1-Sep-10 6:16am

There are pros and cons, that's why both approaches exist and are used by different people. Without a better explanation from the OP, no-one can really tell him which way will work best for him.

Attachment in asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Attachment in asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us