Sharing Database Between Projects

[paulthepaddy]

Hi guys.

I cant think of the best way to explain my question so added a picture to kinda help.

in the solution explorer i have 3 projects so far included. (the reason i have made 3 projects is because i want them to be able to run independently from the main application)


but each application is using loads of diffrent datasets and diffrent copies of databases. the database these projects use are the same, so is their a way to add the database to the solution instead of adding it to the project.

when im debuggin im having to refrence to the database in the bin folder so i can check for changes.

does anyone know of a good learning resource for the ado.net, most of the online tutorials i find are just using the wizard and covering basic stuff

 

[eralper]

Hi Paul,
May be it can help you if you manage many projects.
I generally build presentation layer and data layer in different projects.
Presentation layer imports data layer as a reference project and calls classes and methods within codes behind pages, classes etc.
Data layer opens connection to databases and manage read write operations.

So you can create a single data layer and call this from different projects. Is it a solution for you?