Answer / alok saxena

Data Access layer is actually a part of Architecture layer.
It has 2 tier,3 tier or N tier Layer. Generally we use 3
tier Layer 1) Presentation layer,Business Logic layer and
then Data Access Layer. Data Access layer is a medium to
talk between database and Business Logic layer. It helps to
maintain flexibility,resuablity and even secuity also. In
security SQL Injection can be stopped with 3 iter
Archietcture.

Answer / nvns

This is the layer where we write the coding related to all
database operations in a class file/files.

What are the rules to implement connection pooling?

0 Answers  

---

What providers does ado.net uses internally ?

3 Answers   Digital GlobalSoft,

---

How will you fill the gridview by using datatable object at runtime?

0 Answers  

---

Describe datareader object of ado.net with example.

0 Answers  

---

Which method is used by command class to execute SQL statements that return single value?

0 Answers  

---

Which object needs to be closed?

0 Answers  

---

Is datareader faster than datatable?

0 Answers  

---

Difference between OLEDB Provider and SqlClient ?

2 Answers  

---

What is executescalar and executenonquery?

0 Answers  

---

what is data access layer?

2 Answers   Honeywell,

---

What is dataset and tell about its features. What are equivalent methods of previous, next etc. Of ADO in ADO.NET ?

1 Answers   Digital GlobalSoft,

---

What are all the different authentication techniques used to connect to MS SQL Server?

0 Answers  

---