O'Reilly logo

Essential ADO.NET by Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required