Could someone please explain how I fix the setting to save tables in data base to the folder the data base is in. Actually I am using Visual studio 2015. When I add the data base to the project there is no choice for Local Database so I pick Service based data base and it shows up in the solution explorer then I try to add table design the table and save it, where it goes I have no idea, it never shows up in the solution explorer, or Server explorer. I am desperate! I have reloaded visual studio 5 times, even did a fresh install of Windows and did the whole reload visual studio with the same result.