Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - Enterprise libraries

Reply
 
Old 07-24-2008   #1 (permalink)
Terry Holland


 
 

Enterprise libraries

Im not sure if this is the correct group for this question - please feel free
to redirect me to a more appropriate group if necessary

Im assessing Enterprise Libraries and I wanted to know how objects are
disposed of

ie writing data access code by hand i might write soemthing like this

Dim strConnTxt As String =
"Server=(local);Database=Northwind;Integrated Security=True;"
Dim strSql As String = "select * from products where categoryid = "
& txtCategoryID.Text

'create and open the connection object
Using objConn As New SqlConnection(strConnTxt)
'Using Definition
'http://msdn.microsoft.com/en-us/library/htd05whh.aspx
objConn.Open()

'Create the command object
Using objCmd As New SqlCommand(strSql, objConn)
objCmd.CommandType = CommandType.Text

'databind the datagrid by calling the ExecuteReader() method
GridView1.DataSource = objCmd.ExecuteReader()
GridView1.DataBind()
lblCount.Text = ""

End Using

'close the connection
objConn.Close()
End Using

As I understand, by using the 'Using' block, the connection & command
objects are disposed of when exiting the block

If however I use the following code using DataAccessApplicationBlock, how
are these objects (that are inevitably created within the application block
code) disposed of?

Dim db As Database = DatabaseFactory.CreateDatabase()
Dim dbCommand As DbCommand =
db.GetStoredProcCommand("GetProductsByCategory")

db.AddInParameter(dbCommand, "CategoryID", DbType.Int32,
txtCategoryID.Text)
db.AddOutParameter(dbCommand, "RecordCount", DbType.Int32,
txtCategoryID.Text)

GridView1.DataSource = db.ExecuteReader(dbCommand)
GridView1.DataBind()

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Icon libraries or collections Vista General
Icon libraries Vista General
functions libraries PowerShell


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46