Solved

How to add database to asp.net project folder vs2012

Posted on 2014-11-25
6
229 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 33

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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
LVL 33

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 79

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 33

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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

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…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
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…

777 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