I need to know if it is advantageous to use Microsoft Enterprise Library. I'm gonna use it mainly for it's Data Access Application Blocks. My web application needs to access 3 SQL Server (only) databases, one of which for almost all database accesses and the other two at specific points of a process.
I also want to know how the enterprise library handles the connection to the database, i.e. does it automatically open and close the connection by using the DatabaseFactory.CreateDatabase method and a dataset to be filled with the results? Does it handle the multiple simultaneous database accesses?
what is the difference between using DAAB and old fashion open connection- execute command - close connection In terms of performance and load of database connections?
Thank you so much for your help in advance
View Complete Post