How to add database to asp.net project folder vs2012

A small asp.net c# application works with a remote database (on the same computer).

Question: What are the steps to upload this database to asp project folder?
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

käµfm³d 👽Commented:
What do you mean by "remote database"? What kind of database is this?
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
It is in SSMS. I want to bring into solution folder as we do with desktop application (as local file).
0
käµfm³d 👽Commented:
SSMS is a utility for interacting with SQL Server and some of its lighter variants. It alone is not a database. Are you therefore saying that you are working with SQL Server? Or perhaps SQL Server Express or Compact?
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Mike EghtebasDatabase and Application DeveloperAuthor Commented:
My apology for poor description. I have SQLEXPRESS12, the database I work with now is in the Data folder (C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS12\MSSQL\DATA) and this is how SSMS sees it.

I will not be using compact version. What I want to do is to upload this database from DATA folder (after it is off line and detached) into my asp solution folder.

The reason I am doing it to make this application portable. Later when I try it on another computer; which also has SQLEXPRESS12, would allow me to demo the app on that computer.
0
David Johnson, CD, MVPOwnerCommented:
take the database offline
copy it to your appdata folder
attach it from your appdata folder.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
I can manually copy and paste it into App_Data folder manually. But I am looking for a wizard solution that it works.

I tried: On the solution folder right-click/Add/Existing Item...  this gives me the browser. After selecting the .mdf file, the database gets copied solution folder whereas I was expecting to put in App_Data folder which it doesn't.

Eventually, I want to add few tables and procs into a LINQ-TO-SQL interface to create a .dhml file to work with.

This process seemingly is different with asp compare to desktop which I am quite familiar with.

Question: How is this done in a asp.net application?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.