Can I use one .mdf file in multiple projects

Question

I have a project PROJECT_A which contains mdf file database. In the solution of this project I added one new project - PROJECT_B.

My question is:Can I use .mdf file from PROJECT_A in PROJECT_B?

Answer 1

You can add .mdf file as a Link Reference to project B

Right click project B and then properties > Add Reference > Existing Item > Select the .mdf file and in the add button select Add As Link option.

Answer 2

Yes, you can use single .mdf file in multiple projects. However it is not recommended since it may cause 'access denied' error. It is also a bad practice. You should be using per .mdf file per project/application.