Webmaster's Guide to the Wireless Internet part 45. The Webmaster’s Guide to the Wireless Internet provides the Wireless Webmaster with all of the tools necessary to build the next generation Internet. Packed with the essential information they need to design, develop, and secure robust, e-commerce enabled wireless Web sites. This book is written for advanced Webmasters who are experienced with conventional Web site design and are now faced with the challenge of creating sites that fit on the display of a Web enabled phone or PDA | 412 Chapter 9 Microsoft Mobile Internet Toolkit Figure Architecture .NET Data Provider Connection Command Transaction Parameters DataReader DataAdapter SelectCommand InsertCommand UpdateCommand DeleteCommand Data Set DataRelationCollection DataTableCollection DataTable DataRowCollection DataColumnCollection ConstraintCollection XML Data Providers In ADO communication with the data source is through the OLE DB providers. In the communication is through Data contains two Data providers SQL Data provider OLEDB Data provider If your backend database is SQL Server you should use the SQL Data provider as it talks natively using TDS to SQL results in immediate performance gains as there is no need to go through the OLE DB layer. However if you are not using SQL Server you should use the OLEDB Data provider. The OLEDB Data provider is engineered to work with most OLE DB providers listed in Table have been tested and are known to work with . Microsoft Mobile Internet Toolkit Chapter 9 413 Table Supported OLE DB Providers Driver SQLOLEDB MSDAORA Provider Microsoft OLE DB Provider for SQL Server Microsoft OLE DB Provider for Oracle OLE DB Provider for Microsoft Jet Note__ It is possible to use the OLEDB Data provider even if you are using SQL server. In this case you are foregoing the benefits of talking directly to SQL server by going through additional layers by first going to the OLEDB Data provider and then going through the OLEDB provider. Figure summarizes the discussion so far. Figure Comparing SQLData Provider and OLEDB Data Provider 414 Chapter 9 Microsoft Mobile Internet Toolkit DataReader A huge portion of our database access is on retrieving records and simply displaying them on the client side. For this reason provides the DataReader. The .
