Essential ADO.NET

6.9. Integrating Visual Studio

In general, if you're performing well-known rather than ad hoc operations, performance will improve if you provide as much information as possible at design time. When using DataSet, you can avoid having to rely on MissingSchemaAction and MissingMappingAction by predefining DataSet schema and mappings. You should provide custom stored procedures to be used with DataAdapter.Update rather than relying on the default Commands generated by the CommandBuilder classes or obtaining stored procedure parameters with CommandBuilder.DeriveParameters. Obtaining database metadata at runtime usually involves extra round-trips and may not be as accurate as design-time specification, depending on the capabilities of the data provider. ...