Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MichaelP
Jedi Yak
2489 Posts |
 Posted - 2002-09-25 : 18:53:00
|
| This may be a bit off topic, so forgive me!!I'm creating a three tier (UI, Busniess Logic, Data) system using ASP.NET, VB.Net and SQLServer 2000 respectivly. Right now, I have my ASP.net Pages calling my VB.Net Classes that are compiled as separate assemblies. My question is what should I return from my VB.net Classes when I need a set of data. One way is to use the Dataset, but I understand it's not as high performance as a DataReader. Passing a reference to a datareader out of my Business Object doesn't seem like a very good thing either, because you have to close the connection somehow, and it might take some time before you can close that connection. How do the rest of you handle such things?? Thanks! Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-09-25 : 19:10:27
|
| You might want to check out the AspNetForums project from www.asp.net ... I have found that their .NET structure really is quite nice... Personally I wrap all my data into objects and return the objects for use on the page... so the data is all fetched from the DAL and passed to the BLL via objects and then the BLL can expose those objects to the UI as needed... |
 |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
|
|
|
|
|
ASP.Net + SQL2000