Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The easy answer: change the connection string for your data layer (Linq to SQL?) in the web.config to point to your out-of-process database instance.</p> <p>In more detail, here are the steps I took to split the database out of my site on my development box. By doing the following, you can test the two-server configuration locally before deploying it to production.</p> <ol> <li><a href="http://www.microsoft.com/download/en/details.aspx?displaylang=en&amp;id=8961" rel="nofollow noreferrer">Install SQL Server Management Studio</a></li> <li>Open Management Studio and connect to your local SQL Server Express instence (typicaly [boxname]/SQLEXPRESS)</li> <li>Right-click on the Databases folder in Management Server and select Attach...</li> <li>Locate your .mdf file in you project and open it.</li> <li>Rename the newly attached database to what you want it called.</li> <li>Give whatever service account your IIS application pool runs under permissions to the database. First create an account under the top level Security/Logins folder, and then add that account to the new database's Security/Users folder. For my configuration, I am using NETWORK SERVICE.</li> </ol> <p>Now that your database is mounted as a stand-alone database in SQL Server Express, you can connect to the database using a <a href="http://www.connectionstrings.com/sql-server-2005" rel="nofollow noreferrer">normal SQL Server connection string</a>.</p> <p>At this point, your development environment is simulating the production environment where the database and the IIS process are split. You only have to change your connection string in production to point to the production database.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow do I link to a remote database with ASP.NET MVC?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCyril Gandon
    1. USRyan Michela
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I link to a remote database with ASP.NET MVC?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYes sir, that did the trick. I'm still getting my feet wet with this whole .NET environment, and I totally see how this is a novice-level question. Thanks anyway for the answer :)
      singulars
      1. PO
      1. USJeff Shattock
    2. COI'm glad I could help.
      singulars
      1. PO
      1. USRyan Michela
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload