Solved

How to add database to asp.net project folder vs2012

Posted on 2014-11-25
6
230 Views
Last Modified: 2014-11-25
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?
0
Comment
Question by:Mike Eghtebas
  • 3
  • 2
6 Comments
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 40465704
What do you mean by "remote database"? What kind of database is this?
0
 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 40465719
It is in SSMS. I want to bring into solution folder as we do with desktop application (as local file).
0
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 40465740
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
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 40465756
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
 
LVL 80

Accepted Solution

by:
David Johnson, CD, MVP earned 500 total points
ID: 40465807
take the database offline
copy it to your appdata folder
attach it from your appdata folder.
0
 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 40465825
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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question