ADO.NET. ADO.NET. ADO.NET deals with accessing and manipulating databases.it comprises of many namespaces and classes to do so. ADO.NET provides access to datasources such as Microsoft SQL server,OLE DB and XML.
Is used for connecting to the database,executing commands and retreivingresults.we can either access database directly or use the disconectedapproach.For the disconected approach we use the DATASET class.
It is generally used to extract one or a few records or a specific field value or to execute simple SQL statements.
A DataAdapter is used to fill data from the database into the Dataset object.ThedataAdater is used in disconnected approach.
Q1 C eate a project and connect it to the databasd (Northwind).
and create a DAL layer.(1) Issuing SELECT, INSERT, UPDATE, and DELETE commands, and so on – should be located in the DAL. The presentation layer (your web page)should not contain any references to such data access code, but should instead make calls into the DAL for any and all data requests. Data Access Layers typically contain methods for accessing the underlying database data. The Northwind database, for example, has Products and Categories tables that record the products for sale and the categories to which they belong. In our DAL You will have methods like:
2)GetCategories(), which will return information about all of the categories
3) GetProducts(), which will return information about all of the products
4) GetProductsByCategoryID(categoryID), which will return all products that belong to a specified category
5) GetProductByProductID(productID), which will return information about a particular product
Q2)what is the difference between loosely typed objects and strongly typed objects.why this approach (DAL)is prefferable over using DatsSource controls directly.