Slide 1IntroductionTimelineLow Level AccessJDBCADOADO.netADO.net cont.LINQLINQ cont.ConclusionOverview of Database Access in .NetJosh BowenCIS 764-FS2008Introduction•To best understand a technology it is often useful to look at what came before•Within .net three main classes are used for database access•A new technology called LINQ has been introduced with the latest .Net frameworkTimelineODBC DAO OLE DBADO RDO JDBC ADO.net v1.0ADO.net v2.0ADO.netv3.0LINQ1992 1992 1995 1996 1996 1997 2002 2005 2006 2007•This is not an exhaustive list of database access technologies•There are as many DB access methods as there are stars in the sky (well almost)•Each of these technologies influenced the creation of .Net database access technologyLow Level Access•ODBC – Created to provide a common method for accessing databases, implemented many times by many different companies•DAO,OLE DB,RDO,ADO – Created to simplify access to databases, often used ODBC, many tied to specific products such as Access or Visual BasicJDBC•Database access in Java•4 Major Classes–Driver – Specific to database type–Connection – Information about the DB to access–Statement – The SQL to execute–Results – Data retrieved from database•One option was a connection to ODBCADO•The Microsoft technology which most influenced .net•Relied on 2 major classes–Connection: Information about how to connect to DB, executed queries against connection class–Recordset: Held information retrieved from DBs•Built upon OLE DB•ActiveX Data Objects – Based on COMADO.net•Part of the .Net framework from the beginning•Similar to ADO, but not simply a .Net version of ADO•Based on three classes–Connection: DB type specific, Holds information necessary to communicate with DB–Adapter: Holds the SQL commands for SELECT, DELETE, UPDATE and ADD–Dataset: Holds the data, Can contain multiple tables and relations between tablesADO.net cont.•To make changes to data change the data in the data set, and use the adapter to propagate changes to database•The dataset can be used to store information from any type of data source, only the connection and adapter are specific to database type•ADO.net can be used to query other data sources like XML filesLINQ•Introduced as part of the .Net framework 3.5•Completely new way to access data•Select statements are made from within the language, not as strings passed to a query class•Can be used to query not only databases but also collections and arrays which implement the correct interfacesLINQ cont.•Language Integrated Query – The queries are actually compiled parts of the program, complete with intellisense•Currently can be used with SQL server, other database types need to be accessed using ADO.net components along with LINQConclusion•The history of database access within Microsoft Windows is of decreasing complexity•ADO and JDBC both influenced the design of data access in .net•ADO.net provides a simple yet robust method of accessing data•LINQ represents a major shift in the way databases are
View Full Document
Unlocking...