Now that you know the basics of building and deploying.NET Compact Framework applications utilizing the Smart Device Extensions, it’s time to learn about the technology used to connect those applications to SQL Server CE 2.0. ADO.NET is the latest generation of Microsoft data access technology in a family tree that extends back to ODBC from the Precambrian period. If you did anyVisual Basic and MS Access programming in the early to mid ‘80s, you probably remember using Data Access Objects (DAO) to communicate with the Jet engine. A little later on, Microsoft released a collection of hierarchical objects, called Remote Data Objects (RDO), that wrapped around ODBC to make life a little easier for those needing to communicate with enterprise databases. ActiveX Data Objects (ADO) finally made it onto the scene with the release of the first version of Active Server Pages (Denali) Because it provided an easy-to-use flat layer of objects on top of the OLE DB technology for universal database access, ADO was a huge hit.
KeywordsData Provider Visual Basic Query Plan Error Handling Database Connection
Unable to display preview. Download preview PDF.