Hi!

I'm using DataAdapter to fill datasets, and querying database views with
MissingSchemaAction.AddWithKey option, it's about 50 times slower with
SqlClient than with OleDb! I know it's propably not wise to fetch the schema
for views, but in this case i must do so.

Does OleDb cache the schema or how is it possible? Is there anything i can
do to make it faster? If I understood correctly, the SqlClient should be the
optimized and faster method.

-J

Change Connection String at runtime.
CLR Trigger Rollback
Clearing row selected from DataGridView
ODBC.NET
Provider independant Data Access