By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,883 Members | 955 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,883 IT Pros & Developers. It's quick & easy.

microsoft application blocks

P: n/a
Just Curious, how many of you are using microsoft application blocks for
your application?

http://msdn.microsoft.com/library/de...ml/daab-rm.asp

--
Kind regards

Guoqi Zheng
guoqi AT meetholland dot com
Http://www.meetholland.com

Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"Guoqi Zheng" <no@sorry.nl> wrote in news:#sa7j#okEHA.1048
@tk2msftngp13.phx.gbl:
Just Curious, how many of you are using microsoft application blocks for
your application?


I'm using the data application block - it makes database calls a lot
simplier.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 21 '05 #2

P: n/a
Yes, I am trying to use it as well. but I am afraid of bugs.

I saw they use function to return a datareader. As far as I understand, if
you disconnect connection object, data reader will disappear as well, if you
don' t close connection, then you have a connection leak there, so data
reader can not be returned by a function.

Do you find any bugs there?

--
Kind regards

Guoqi Zheng
guoqi AT meetholland dot com
Http://www.meetholland.com

"Lucas Tam" <RE********@rogers.com> wrote in message
news:Xn***************************@140.99.99.130.. .
"Guoqi Zheng" <no@sorry.nl> wrote in news:#sa7j#okEHA.1048
@tk2msftngp13.phx.gbl:
Just Curious, how many of you are using microsoft application blocks for
your application?


I'm using the data application block - it makes database calls a lot
simplier.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

Nov 21 '05 #3

P: n/a
You can return a datareader via a function if the reader was opened as such:

dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)

The connection will close once the reader is closed.

Greg
"Guoqi Zheng" <no@sorry.nl> wrote in message
news:uG**************@TK2MSFTNGP12.phx.gbl...
Yes, I am trying to use it as well. but I am afraid of bugs.

I saw they use function to return a datareader. As far as I understand, if
you disconnect connection object, data reader will disappear as well, if you don' t close connection, then you have a connection leak there, so data
reader can not be returned by a function.

Do you find any bugs there?

--
Kind regards

Guoqi Zheng
guoqi AT meetholland dot com
Http://www.meetholland.com

"Lucas Tam" <RE********@rogers.com> wrote in message
news:Xn***************************@140.99.99.130.. .
"Guoqi Zheng" <no@sorry.nl> wrote in news:#sa7j#okEHA.1048
@tk2msftngp13.phx.gbl:
Just Curious, how many of you are using microsoft application blocks for your application?


I'm using the data application block - it makes database calls a lot
simplier.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/


Nov 21 '05 #4

P: n/a
"Guoqi Zheng" <no@sorry.nl> wrote in
news:uG**************@TK2MSFTNGP12.phx.gbl:
I saw they use function to return a datareader. As far as I
understand, if you disconnect connection object, data reader will
disappear as well, if you don' t close connection, then you have a
connection leak there, so data reader can not be returned by a
function.


No, it works fine.

This is how you use the datareader portion:
Dim dr as sqlclient.sqldatareader = sqlhelper.executereader(...)
When you're done with the reader, go: dr.close.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.