Contents tagged with ADO.NET
-
Architect 3 : Building Data Access Layer Using Microsoft Enterprise Library 4.1
You have a Customer table with three fields: ID, LastName and FirstName. You are building a data access layer to retrieve all the records from the Customer table and return the result as a collection of Customer objects. You want implement it using Microsoft Enterprise Library.
-
Tip 6 : Function returning SqlDataReader Type
I am strongly against building a function that returns SqlDataReader type because it destroys the basic purpose of building a function: decoupling or separation of concerns. For SqlDataReader, an active database connection needs be kept open across your function to the client that calls the function.