Cannot use Visual Studio 2008/2010 Query Builder

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
pguerin
Posts: 1
Joined: Fri 23 Dec 2011 16:02

Cannot use Visual Studio 2008/2010 Query Builder

Post by pguerin » Wed 04 Jan 2012 16:52

I am trying to use the Visual Studio Query Builder inside Visual Studio 2008 to create .Net Apps or SSIS Package and I have always the following reply from Postgresql : relation "xxxxx" does not exist.

The tools convert my columns names and table names from Pascal Case to small caps.

How can we tell to Visual Studio or the ADO.NET Adapter to generate a correct SQL Query using double quote for the columns and tables names ?

I like to build the adapter to implement our BI solution.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 11 Jan 2012 17:31

Unfortunately, we have not found the way to integrate into unmanaged VS Query Builder to make it quote the column/table names when working with PostgreSQL. We are investigating the issue but there is no timeframe.

Post Reply