Click here to Skip to main content
15,899,314 members
Home / Discussions / C#
   

C#

 
JokeRe: Little indian vs Big Indian Pin
Guffa2-Aug-06 9:04
Guffa2-Aug-06 9:04 
AnswerRe: Little Endian vs Big Endian Pin
Ennis Ray Lynch, Jr.2-Aug-06 8:25
Ennis Ray Lynch, Jr.2-Aug-06 8:25 
GeneralRe: Little Endian vs Big Endian Pin
seq-2-Aug-06 8:29
seq-2-Aug-06 8:29 
AnswerRe: Little Endian vs Big Endian Pin
engsrini2-Aug-06 8:33
engsrini2-Aug-06 8:33 
AnswerRe: Little Endian vs Big Endian Pin
Guffa2-Aug-06 8:52
Guffa2-Aug-06 8:52 
QuestionTyped Datasets vs. Custom Classes Pin
econner2-Aug-06 8:13
econner2-Aug-06 8:13 
AnswerRe: Typed Datasets vs. Custom Classes Pin
eggsovereasy2-Aug-06 9:59
eggsovereasy2-Aug-06 9:59 
QuestionDAL/BLL Best Practices Pin
econner2-Aug-06 8:08
econner2-Aug-06 8:08 
I am looking to create an Data Access Layer and Business Logic Layer for a new web site. I am looking for suggestions on the best practice on how to handle the database connection from the DAL.

I have seen examples where every function in the DAL creates a connection, runs the query, and then closes the connection based on the connection string passed into the DAL. With connection pooling this doesnt seem to be a big issue. Is this the best method for a web application since it is stateless? Or, is it better for the BLL to create a connection and pass the connection into the DAL? How is the best way to get the connection string from the Web.config file to the DAL? Does the BLL pass the connection string into the DAL or is there a better way?

I am looking at using ASP 2.0 but I didnt want to use the table adapter wizard.

Any examples would be greatly appreciated.

AnswerRe: DAL/BLL Best Practices [modified] Pin
eggsovereasy2-Aug-06 10:03
eggsovereasy2-Aug-06 10:03 
GeneralRe: DAL/BLL Best Practices Pin
econner2-Aug-06 10:12
econner2-Aug-06 10:12 
GeneralRe: DAL/BLL Best Practices Pin
eggsovereasy2-Aug-06 10:35
eggsovereasy2-Aug-06 10:35 
QuestionHow to assign text control's value to a numeric variable? Pin
Amol Ravatale2-Aug-06 7:54
Amol Ravatale2-Aug-06 7:54 
AnswerRe: How to assign text control's value to a numeric variable? Pin
Stefan Troschuetz2-Aug-06 8:34
Stefan Troschuetz2-Aug-06 8:34 
AnswerRe: How to assign text control's value to a numeric variable? Pin
engsrini2-Aug-06 8:35
engsrini2-Aug-06 8:35 
AnswerRe: How to assign text control's value to a numeric variable? Pin
BlackDice2-Aug-06 8:38
BlackDice2-Aug-06 8:38 
QuestionStrange Behavior Pin
Mehdi Mousavi2-Aug-06 5:43
Mehdi Mousavi2-Aug-06 5:43 
QuestionScreenshots Pin
Kovu172-Aug-06 5:08
Kovu172-Aug-06 5:08 
AnswerRe: Screenshots Pin
Judah Gabriel Himango2-Aug-06 5:24
sponsorJudah Gabriel Himango2-Aug-06 5:24 
GeneralRe: Screenshots Pin
Kovu172-Aug-06 23:22
Kovu172-Aug-06 23:22 
GeneralRe: Screenshots Pin
Judah Gabriel Himango3-Aug-06 4:21
sponsorJudah Gabriel Himango3-Aug-06 4:21 
Questionhow to create a color eyedroppper? Pin
relsirc2-Aug-06 4:36
relsirc2-Aug-06 4:36 
AnswerRe: how to create a color eyedroppper? Pin
Ennis Ray Lynch, Jr.2-Aug-06 4:42
Ennis Ray Lynch, Jr.2-Aug-06 4:42 
Questionhow to remove duplicate characters from a text file [modified] Pin
vp152-Aug-06 4:35
vp152-Aug-06 4:35 
AnswerRe: how to remove duplicate characters from a text file Pin
Ennis Ray Lynch, Jr.2-Aug-06 4:44
Ennis Ray Lynch, Jr.2-Aug-06 4:44 
QuestionClass doesn't support Automation [modified] Pin
Lupson2-Aug-06 4:21
Lupson2-Aug-06 4:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.