Visual Studio Express & Data Source wizard

plang · Post by **plang** » Wed 07 Jun 2006 08:39

Hi,

I have installed PostgreSQLDirect .NET on top of Visual Studio C# Express.

According to your documentation, your library supports the "Data Source wizard" of Visual Studio, but when adding a new Data Source, I cannot choose your provider. Only the default Access and SQL Server are mentioned in the list.

Maybe what I experience is a "Visual Studio Express" limitation? I've read remote databases are not supported with Visual Studio Express. (http://msdn.microsoft.com/vstudio/products/compare/) Does that apply to remote "Postgresql" databases too?

Thanks for the feedback,

Philippe Lang
Attik System

Alexey · Post by **Alexey** » Wed 07 Jun 2006 09:13

Visual Studio C# Express doesn't support extensions. That's why you won't see our provider in the "Data Source wizard".

plang · Post by **plang** » Wed 07 Jun 2006 09:50

OK,

Another question: compared to MS Access or MS SQL Server, is there a limitation in the interactions between Visual Studio and Postgresql?

Or is the integration of Postgresql inside Visual Studio as good as with the MS Databases?

Thanks,

Philippe

Alexey · Post by **Alexey** » Wed 07 Jun 2006 10:17

compared to MS Access or MS SQL Server, is there a limitation in the interactions between Visual Studio and Postgresql?

Too hypothetic. Please specify.

is the integration of Postgresql inside Visual Studio as good as with the MS Databases?

What is meant by "Postgresql"? If you are talking about PostgreSQLDirect .NET data provider, the integration is good enough.

plang · Post by **plang** » Wed 07 Jun 2006 11:28

compared to MS Access or MS SQL Server, is there a limitation in the interactions between Visual Studio and Postgresql?

Too hypothetic. Please specify.

When using Visual Studio RAD functionalities regarding databases (Designers, Code generation, Datasets, connected/disconnected Recordsets and such), is there a feature that is available with a MS Access or MS SQL Server backend, and that is NOT available with a PostgreSQLDirect .NET / Postgresql backend?

Alexey · Post by **Alexey** » Wed 07 Jun 2006 11:59

PostgreSQLDirect .NET integrates tightly with design-time features of Visual Studio 2005 such as Server Explorer. This is also mentioned as Data Designer Extensibility features. The integration helps to design applications in more convenient and fast way. For example, you can take advantage of DataSet Designer, Data Source wizard, Query Builder, TableAdapter configuration, use Preview Data capability and configure web SqlDataSource component.