Databases
StackOverflow2013
Postsdbo
POPublish MVC 3.0 Site in IIS 7.0
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPublish MVC 3.0 Site in IIS 7.0
    primarykey
    data
    text
    <p>I program website with MVC 3.0 which uses EntityFrame work 4.0, In controller layer I Have this:<br/></p> <pre><code> public ViewResult Index() { return View(_DatabaseSMSEntities.People.ToList()); } </code></pre> <p>And in View Layer I used Telerik Grid:</p> <pre><code>&lt;% Html.Telerik().Grid&lt;ProjectWebsite.Models.People&gt;(Model) .Name("People") .Columns(columns =&gt; { columns.Bound(o =&gt; o.PersonID).Format( "&lt;a href='../WebPage/PersonSMSPage.aspx?personID=" + "{0}" + @"' &lt;br/&gt;runat=""server""&gt;" + "&lt;img src='../../Content/themes/base/images/RegisterSMS.png' &lt;br/&gt;alt='{0}' /&gt;"&lt;br/&gt; ); }) .RowAction(row =&gt; { if (row.Index == 0) { row.DetailRow.Expanded = false; } }) .Render();%&gt; </code></pre> <p>I published it in IIS 7.0. But it does not work. </p> <pre><code>&lt;connectionStrings&gt; &lt;add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" /&gt; &lt;add name="DatabaseSMSEntities" connectionString="metadata=res://*/Models.ModelDatabaseSMS.csdl|res://*/Models.ModelDatabaseSMS.ssdl|res://*/Models.ModelDatabaseSMS.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DatabaseSMS.mdf;Integrated Security=True;MultipleActiveResultSets=True&amp;quot;" providerName="System.Data.EntityClient" /&gt; &lt;add name="cn1" connectionString="data source=~/ErrorsLog/Errors.db" /&gt; &lt;/connectionStrings&gt; </code></pre> <p>First, I published it in D:\Pardis, But I got error:</p> <pre><code> CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file D:\Pardis\App_Data\DatabaseSMS.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file D:\Pardis\App_Data\DatabaseSMS.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Source Error: Line 20: public ViewResult Index() Line 21: { Line 22: return View(_DatabaseSMSEntities.People.ToList()); Line 23: } Line 24: </code></pre> <p>Then, I published it in Inetup but I got error. I do not have ASPNET user in user list to set security.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStereško
    1. USRamezani r
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COSo what exactly doesn't work? Publishing itself or the published site?
      singulars
      1. POPublish MVC 3.0 Site in IIS 7.0
      1. USLukeP
    2. COI find I should add "User Instance=True;", but it work sometimes and does not work another time
      singulars
      1. POPublish MVC 3.0 Site in IIS 7.0
      1. USRamezani r
 

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