Archive for December 13th, 2007

PotgreSQL OLEDB provider for ASP.NET

December 13th, 2007 by Denis Golovtsov

I read the information on the official PostgreSQL site that the first commercial OLEDB provider for PotgreSQL is available now. I estimate this news as very good.

I have been working with PostgreSQL very closely for one year and I found that this server is very powerful and as now .NET framework will have OLEDB provider for a supporting of that, it can be a good alternative of the MS SQL and Oracle servers, licenses of which cost much money.

I have downloaded th trial version of it from the author’s site and have checked how it works. Of course trial version has serious limitation here:

TRIAL VERSION

The trial version has the following limitations:

- SELECT statements return up to 100 rows.
- DB conversion in DTS/SSIS Wizard handles only first 100 rows in every table.

Also I proud that the its developer is Russian programmer, who works and lives in USA now. Thank him very much for his good job. And if I will have .NET project where by some reasons will choose PostgreSQL server I obviously can play with its not trial version also, which doubtless will be interesting.