File Sample?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Ekki
Posts: 32
Joined: Sun 24 Nov 2013 18:50
Location: Ilmenau, Germany
Contact:

File Sample?

Post by Ekki » Thu 28 Nov 2013 15:57

Hi,

one reason for me for switching over from MySQL to PostgreSQL was that there's a better support for files in PostgreSQL, e.g. stored directly in the file system rather than represented as BLOBs inside the DB.

Does anyone have a hint that can demonstrate how to implement this with the dotConnect tool chain?

Thx alot in advance

Ekki

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: File Sample?

Post by MariiaI » Fri 29 Nov 2013 15:01

To work with large files we recommend to use a PgSqlLargeObject class.
Please refer to:
http://wiki.postgresql.org/wiki/BinaryFilesInDB
http://www.devart.com/dotconnect/postgr ... bject.html

If you are using LinqConnect, the more suitable solution for this scenario is to use bytea datatype to store such files in the database and work with them in the application as with array of bytes.

If you have any additional questions, feel free to contact us.

Ekki
Posts: 32
Joined: Sun 24 Nov 2013 18:50
Location: Ilmenau, Germany
Contact:

Re: File Sample?

Post by Ekki » Fri 29 Nov 2013 15:18

Thanx a lot. Using your information it seems I can implement the request. Have a great weekend!

Post Reply