VistaDB 5
Gibraltar VistaDB > Tools User's Guide > Visual Studio > Known Visual Studio Issues
Known Visual Studio Issues

There are unfortunately known issues in Visual Studio that don't have a workaround as of Visual Studio 2015.

TableAdapter - Refresh Table Data

Checking the Refresh Table Data from the Advanced Options button of the TableAdapter Configuration Wizard looks like it works, but Visual Studio never passes those values to VistaDB.  The dialog is hard coded to look only for Microsoft providers and send the value on to them, for all others the value is thrown away.  

The only way to get a refresh on your data is to manually edit the SQL syntax and tell it to pull the data after an insert using a select statement.

Or you can add the select statement to the TableAdapter insert command at runtime in your application.

SqlDataSource Designer

The SqlDataSource should really be named the SqlServerDataSource. It only really works for Sql Server. If your type does not match the exact namespace of the SqlClient several options don't work correctly.

DeriveParameters does not call the provider, it is hard coded only for Microsoft products. So all of the parameters in the Visual Studio Query Builder don't work correctly unless you implement a ? as the parameter type (even though allows the provider to specify this value, it is never used). ParameterPrefix is always an empty string for all providers except SqlClient.

See Also