I have a web application that was developed using Microsoft ASP.NET and XML for the datasource. I'm considering changing the datasource to Microsoft Access. I have a few questions.
1. Where should the datasource connection be established?
Can this be done within the global.asax?
Note: The .accdb file is located in the APP_DATA folder.
2. Can the single datasource (.accdb) connection remain open throughout the user's session?
3. Will opening and closing the connection cause a performance issue?
4. Is it best to use BOUND or UNBOUND mode?