Different types of Data Access Layer

Question

User462714528 posted

Hi Everyone,

I'm sort of a beginer/intermidate asp.net developer. Lately i've been trying to understand how to build a good DAL. I followed this tutorial by Scott Mitchell on building a DAL

http://www.asp.net/learn/dataaccess/tutorial01cs.aspx?tabid=63

 In it he mentions that there are basically 2 ways to doing it

1. Typed Data Set    or    2. Custom Business Objects Class Library

 

Then in the tutorial he shows how to build a DAL via Typed Data Set. And he points how easy and quick it is to do so. (And it really is)

Does anyone know a good tutorial where i can learn how to create a DAL the other way, i.e via custom business objects class library(in C#)?

(Is building a custom objects library a LOT of work ? Is there a performance gain which is worth the extra work?)

 

Also, from what i gather, Typed Data Set is a relatively new way of doing a DAL, while developing custom business objects class library has been used for a while.

Which way do most of the software architects today design the DAL layer ? Which DAL design is better in which scenarios ?

I'd appreciate any comments from anyone on the topic from anyone.

Also, if anyone could point to any good articles or tutorials on DAL, i would really appreciate it.

 Thanks,

 

Answer 1

User43093768 posted

 Dear Friend,

Typed DataSet, Custom Business Objects, DataSets, DataTables etc are different ways to hold and manipulate data. I usually prefer Entity Classes since it gives more definition to the whole application and provide easy approach to design the domain of the application. Entity classes are used as business objects. DAL is another layer which is used to persist the information into the data store (Database, XML etc). A good way to learn about layered architecture is to read good articles and books. One of the good book is "Expert Service Oriented Architecture by Rocky Lockha".

 

Answer 2

User-2018949055 posted
try these links. First one is really good. Its a three part series. I suggest you read all three to get a complete picture. The other is the architecture discussion of Petshop 4.0 app by microsoft.
http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=416
http://msdn.microsoft.com/en-us/library/aa479070.aspx

Answer 3

User462714528 posted

Hi,

Thanks for the help guys.

 

Answer 4

User1304022899 posted

In this example only mentioned about Northwind Database what about Sql Server Database How to Create and Access

Database using DataSet.Xsd file in to the project.

Answer 5

User1304022899 posted

I solved this problem.

Step 1: Download NorthWind Data base.

Step2: Create Dataset.xsd file, save as ProductDataset.xsd.

Step3: Drag & Drop the Products Table from the Server explorer.

Put This code in Default.aspx.cs

protected void Page_Load(object sender, EventArgs e)
    {
        ProductDataSetTableAdapters.ProductsTableAdapter adapter=new ProductDataSetTableAdapters.ProductsTableAdapter ();
        ProductDataSet.ProductsDataTable table = adapter.GetDataBy();
        GridView1.DataSource = table;
        GridView1.DataBind();


    }

In Default.aspx page

Drag & Drop GridView.

This is Typed DataSet in ASP.net

Go to this Url This may helps to you 

http://weblogs.asp.net/scottgu/archive/2006/01/15/435498.aspx

<input id="gwProxy" type="hidden"><!--Session data--><input onclick="jsCall();" id="jsProxy" type="hidden">