ADO - .NET at JKU（ADO。）.pdf

ADO.NET Dietrich Birngruber Software Architect TechTalk www.techtalk.at Contents Part I: Basics Part II: Connection-Oriented Scenario Part III: Disconnected Scenario Part IV: Data Access Layer Sample ADO.NET, Dietrich Birngruber, TechTalk 2 Motivation How to access different data sources? – „back office“, OO/RDBMS, files, (web-)server, ... Application Oracle Oracle (object-oriented) implementation 1 IBM IBM Host Application implementation 2 (object-oriented) ??? data access ??? implementation 3 Is there a unified programming model and API available ? ADO.NET, Dietrich Birngruber, TechTalk 3 Microsoft Data Access Components (.NET) Applications ADO.NET data source OLEDB specific ODBC SQL data Non SQL data Mainframe and other proprietary MS SQL Server, Oracle, Directory services, DB2, Jet, ... email, text files, ... data sources ADO.NET, Dietrich Birngruber, TechTalk 4 Architectural Overview .NET data .NET Application types data s T DataSet IDataReader d