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

3.9. Reading Column Values through IDataRecord

Individual column values are read through a DataReader's implementation of the IDataRecord interface. IDataRecord includes a series of strongly typed accessors (shown in Listing 3-18) that take a zero-based column ordinal and return a CLS type. These methods map data source data types to CLS data types. Providers can choose to expose accessors for data source-specific data types; for example, the SqlClient provider's accessors can return instances of structures defined in the System.Data.SqlTypes namespace. Strongly typed accessors do not necessarily convert types; using the wrong getter (for example, calling GetString on an integer column) results in an InvalidCastException. A special method,

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