May 2002
Beginner to intermediate
560 pages
11h 36m
English
Content preview from Essential ADO.NETBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
6.8. Nonrelational Data and DataViews
DataViews do not work well with nonrelational DataTables—that is, Data-Tables that contain object data types or multivalued data. This is not surprising because the Sort and Filter syntax used in DataViews mimics SQL syntax defined in SQL-92. SQL-99 extends SQL to provide for embedded tables and object data types (user-defined types). To reference attributes of user-defined types, SQL-99 specifies that observer functions must be available. To update such types, you use mutator functions. Listing 6-25 presents an example of using a user-defined type in a SQL table definition and retrieving it through the mutator functions exposed by the database. (Note: No “mainstream” database exposes this functionality, ...