
<p>
  This blog demo how to create use MVC Layout and Controller with Sitecore
  Layout and Controller Rendering. The final source you can get from
  <a
    href="https://github.com/keke78ui9/SitecoreSampleSite"
    target="_blank"
    rel="noopener"
    >here</a
  >.
</p>
<h2>Create a Sitecore Page with MVC Layout and Controller</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492809/eqi6ktzhkq3w8njsf4qh.png"
    alt=""
  />
</p>
<h2>Create Layout at Sitecore</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492808/ypiftnriw6zizv1ehk31.png"
    alt=""
  />
</p>
<h2>Set Sitecore location for new Layout file</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492808/wjegljgxyyjajbbsx8s3.png"
    alt=""
  />
</p>
<h2>Set Sitecore Mvc Layout's cshtml file location</h2>
<p>
  <img
    class="img-responsive"
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_eiwog38cl.png"
    alt=""
  />
</p>
<h2>Create new DefaultLayout1.cshtml at visual studio</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492808/euxnrrb7yxdqiot5gsh2.png"
    alt=""
  />
</p>
<h2>Sitecore Layout Detail</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492808/eqrvlmstvtwfpwxfzmlk.png"
    alt=""
  />
</p>
<h2>DefaultLayout1.cshtml detail</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492809/wxzbl2vrehrn1yletq6p.png"
    alt=""
  />
</p>
<h2>Create Sitecore Controller Rendering</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492809/siheqvtz2idrx0lyyjw4.png"
    alt=""
  />
</p>
<h2>Add Controller name and action name at sitecore</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492809/yekacd6skk7dhgdpnadp.png"
    alt=""
  />
</p>
<h2>Create Controller at Visual Studio Mvc Project</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492809/d3l6r74upv7fcqvi6h33.png"
    alt=""
  />
</p>
<h2>Sitecore Page Layout Detail</h2>
<p>
  <img
    class="img-responsive"
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_9m9w100vi.png"
    alt=""
  />
</p>
<h2>Change Sitecore page to use different Layout</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492809/z5rr6ciifi2d4cv6cx3v.png"
    alt=""
  />
</p>
<h2>Layout Detail - add Sitecore Controller Rendering</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492809/mkuut9l6ujys0qtaypjl.png"
    alt=""
  />
</p>
<h2>Device Editor</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492809/ddaa38zhtlgptlkhzzk1.png"
    alt=""
  />
</p>
<h2>Select the new Rendering</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492809/pjxdmdno1h2znxlktzsw.png"
    alt=""
  />
</p>
<h2>Sample Controller Rendering</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492809/vakvxvfsrwv5fmvfzlrv.png"
    alt=""
  />
</p>
<h2>Page use new Layout and new Mvc Controller</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492809/v0s9q6peizpj56l5r1ie.png"
    alt=""
  />
</p>
<h2>Create new Page and Submit via Worlflow</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492809/uds50ek8puvxedq7e1y8.png"
    alt=""
  />
</p>
<h2>Approve Workflow</h2>
<p>
  <img
    class="img-responsive"
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_3vq8svj63.png"
    alt=""
  />
</p>
<h2>Publish and see changes</h2>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1513492810/yyok1wo9egrwlwxqhuya.png"
    alt=""
  />
</p>


This blog demo how to create use MVC Layout and Controller with Sitecore Layout and Controller Rendering. The final source you canget from here [https://github.com/keke78ui9/SitecoreSampleSite].

How to Create Sitecore Mvc Layout and Controller Rendering


<p>
  Sitecore 9's installation is little different than Sitecore 8, it is
  recommended to use Sitecore Installation Framework, which you'll install the
  solution with Powershell. There are lots sites, videos are described how to
  setup Sitecore 9 already. This blog will be quick version or notes or how to
  setup Sitecore9. If you want to watch short Youtube video, I recommended
  watching
  <a
    href="https://www.youtube.com/watch?v=-pMH7mcAVHg&amp;index=7&amp;list=PLBDqdodEhG7-9-hX5R_m2UAvpMKEZp-xY"
    target="_blank"
    rel="noopener"
    >Install Sitecore 9</a
  >. The total is about 15 minutes, it starts from setup IIS, SQL Server 2016
  SP1, SQL Server Data Tools 2015, Solr 6.6.2 and use Sitecore Installation
  Framework. I wish I could watch this video before I start to Install Sitecore
  9 because I had made few common mistakes.
</p>
<p>
  Now, following section will focus on How to set up the local development
  environment&nbsp;for Sitecore 9.
</p>
<p>
  First, go to&nbsp;<a
    href="https://dev.sitecore.net/Downloads/Sitecore_Experience_Platform/90/Sitecore_Experience_Platform_90_Initial_Release.aspx"
    target="_blank"
    rel="noopener"
    >dev.sitecore.net</a
  >&nbsp;to download package for XP Single.
</p>
<p>
  <img
    class="img-responsive"
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_83t7mo90o.png"
    alt=""
  />
</p>
<p>
  After extract zip file, you'll see following files, you will probably need to
  modify *.json files, but you won't have to touch the *zip files.
</p>
<ul>
  <li>Sitecore 9.0.0 rev. 171002 (OnPrem)_single.scwdp.zip</li>
  <li>Sitecore 9.0.0 rev. 171002 (OnPrem)_xp0xconnect.scwdp.zip</li>
  <li>xconnect-xp0.json</li>
  <li>xconnect-createcert.json</li>
  <li>sitecore-XP0.json</li>
  <li>sitecore-solr.json</li>
  <li>xconnect-solr.json</li>
</ul>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512422942/tyxgfuibqpxmzqhchwiz.png"
    alt=""
  />
</p>
<p>
  IIS setup, make sure you have IIS installed on your local, following is sample
  setting for you to reference.
</p>
<p>
  <img
    class="img-responsive"
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_4jem7u5nn.png"
    alt=""
  />
</p>
<p>Install SQL Server 2016 SP1</p>
<p>
  You can go to this
  <a
    href="https://www.microsoft.com/en-us/sql-server/sql-server-downloads-free-trial"
    target="_blank"
    rel="noopener"
    >link </a
  >to download a free version of SQL Server 2016. At this blog, I downloaded the
  Developer version.
</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512423548/xefi4ogjlwpmbjnw7bpg.png"
    alt=""
  />
</p>
<p>
  SQL Server 2016 Settings, there are few things you need to modify for SQL
  Server 2016.
</p>
<ul>
  <li>
    Change Server Properties' Server authentication from Windows Authentication
    mode to SQL Server and Windows Authentication mode.
  </li>
  <ul>
    <li>
      <img
        class="img-responsive"
        src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512423861/kdogcxh3g6l3mid8pknm.png"
        alt=""
      />
    </li>
  </ul>
  <li>Change sa&nbsp;from Login Disabled to Enabled.</li>
  <ul>
    <li>
      <img
        class="img-responsive"
        src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512423861/diou3tngdxjoctwxuup2.png"
        alt=""
      />
    </li>
  </ul>
  <li>Change sa&nbsp;password.</li>
  <ul>
    <li>
      <img
        class="img-responsive"
        src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512423861/hdj8ta9xmwwspiezhfmv.png"
        alt=""
      />
    </li>
  </ul>
</ul>
<p>Install SQL Server Management Studio</p>
<p>
  This blog I have installed SQL Server Management Studio 17.3, you can download
  from this
  <a
    href="https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms"
    target="_blank"
    rel="noopener"
    >link</a
  >.
</p>
<p>Install Web Platform Installer components</p>
<p>Install SQL Server Data Tools 2015</p>
<p>Install Solr 6.6.2</p>
<p>
  For Sitecore 9.0.0 rev. 171002, I think better to use Solr 6.x version. I have
  tried to use the 7.x version of the Solr but running into some issue when
  trying to create a module on Solr.&nbsp;
</p>
<p>
  You can download Solr 6.6.2 from
  <a
    href="http://archive.apache.org/dist/lucene/solr/"
    target="_blank"
    rel="noopener"
    >here</a
  >.
</p>
<p>
  <img
    class="img-responsive"
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_4ot4rvhcf.png"
    alt=""
  />
</p>
<p>Setup Windows Service for Solr</p>
<p>Download NSSM</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512425330/vt47iygsal3vglagickj.png"
    alt=""
  />
</p>
<p>&nbsp;</p>
<p>Add NSSM to System Variables's Path</p>
<p>
  Since I put my NSSM to the following location, add path as this
  C:\Files\nssm-2.24\win64. Once you add the executable&nbsp;path to System
  Variables, refresh command line, then you can use NSSM command on Command
  Prompt. Now, type <code>nssm install solr. </code>Enter information as
  following.
</p>
<ul>
  <li>Path: C:\solr-6.6.2\bin\solr.cmd</li>
  <li>Startup directory:&nbsp;C:\solr-6.6.2\bin</li>
  <li>Arguments:&nbsp;start -f -p 8983</li>
  <li>Service name: solr</li>
</ul>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512425649/qzt9xm19ww2ur5aigxv2.png"
    alt=""
  />
</p>
<p>Enable SSL for Solr</p>
<p>
  You can read Solr's document to setup SSL, but I recommended&nbsp;use this
  blog PowerShell to enable SSL for Solr, it is much easier. You'll have to
  change Java keytool.exe to the location on your pc. Following is the script
  from&nbsp;<a
    href="https://kamsar.net/index.php/2017/10/Quickly-add-SSL-to-Solr/"
    target="_blank"
    rel="noopener"
    >Quickly add SSL to Solr from kamsar.net</a
  >.
</p>
<pre class="language-shell"><code>
param(
	[string]$KeystoreFile = 'solr-ssl.keystore.jks',
	[string]$KeystorePassword = 'secret',
	[string]$SolrDomain = 'localhost',
	[switch]$Clobber
)

$ErrorActionPreference = 'Stop'

### PARAM VALIDATION
if($KeystorePassword -ne 'secret') {
	Write-Error 'The keystore password must be "secret", because Solr apparently ignores the parameter'
}

if((Test-Path $KeystoreFile)) {
	if($Clobber) {
		Write-Host "Removing $KeystoreFile..."
		Remove-Item $KeystoreFile
	} else {
		$KeystorePath = Resolve-Path $KeystoreFile
		Write-Error "Keystore file $KeystorePath already existed. To regenerate it, pass -Clobber."
	}
}

$P12Path = [IO.Path]::ChangeExtension($KeystoreFile, 'p12')
if((Test-Path $P12Path)) {
	if($Clobber) {
		Write-Host "Removing $P12Path..."
		Remove-Item $P12Path
	} else {
		$P12Path = Resolve-Path $P12Path
		Write-Error "Keystore file $P12Path already existed. To regenerate it, pass -Clobber."
	}
}

try {
	$keytool = (Get-Command 'C:\Program Files\Java\jdk1.8.0_131\bin\keytool.exe').Source
} catch {
	$keytool = Read-Host "keytool.exe not on path. Enter path to keytool (found in JRE bin folder)"

	if([string]::IsNullOrEmpty($keytool) -or -not (Test-Path $keytool)) {
		Write-Error "Keytool path was invalid."
	}
}

### DOING STUFF

Write-Host ''
Write-Host 'Generating JKS keystore...'
&amp; $keytool -genkeypair -alias solr-ssl -keyalg RSA -keysize 2048 -keypass $KeystorePassword -storepass $KeystorePassword -validity 9999 -keystore $KeystoreFile -ext SAN=DNS:$SolrDomain,IP:127.0.0.1 -dname "CN=$SolrDomain, OU=Organizational Unit, O=Organization, L=Location, ST=State, C=Country"

Write-Host ''
Write-Host 'Generating .p12 to import to Windows...'
&amp; $keytool -importkeystore -srckeystore $KeystoreFile -destkeystore $P12Path -srcstoretype jks -deststoretype pkcs12 -srcstorepass $KeystorePassword -deststorepass $KeystorePassword

Write-Host ''
Write-Host 'Trusting generated SSL certificate...'
$secureStringKeystorePassword = ConvertTo-SecureString -String $KeystorePassword -Force -AsPlainText
$root = Import-PfxCertificate -FilePath $P12Path -Password $secureStringKeystorePassword -CertStoreLocation Cert:\LocalMachine\Root
Write-Host 'SSL certificate is now locally trusted. (added as root CA)'

Write-Host ''
Write-Host '########## NEXT STEPS ##########' -ForegroundColor Green
Write-Host ''
Write-Host '1. Copy your keystore to $SOLR_HOME\server\etc (MUST be here)' -ForegroundColor Green

if(-not $KeystoreFile.EndsWith('solr-ssl.keystore.jks')) {
	Write-Warning 'Your keystore file is not named "solr-ssl.keystore.jks"'
	Write-Warning 'Solr requires this exact name, so make sure to rename it before use.'
}

$KeystorePath = Resolve-Path $KeystoreFile
Write-Host ''
Write-Host '2. Add the following lines to your solr.in.cmd:' -ForegroundColor Green
Write-Host ''
Write-Host "set SOLR_SSL_KEY_STORE=etc/solr-ssl.keystore.jks" -ForegroundColor Yellow
Write-Host "set SOLR_SSL_KEY_STORE_PASSWORD=$KeystorePassword" -ForegroundColor Yellow
Write-Host "set SOLR_SSL_TRUST_STORE=etc/solr-ssl.keystore.jks" -ForegroundColor Yellow
Write-Host "set SOLR_SSL_TRUST_STORE_PASSWORD=$KeystorePassword" -ForegroundColor Yellow
Write-Host ''
Write-Host 'Done!'
</code></pre>
<p
  style="
    font-family: 'Helvetica Neue', Helvetica, Arial, Helvetica, sans-serif;
    white-space: normal;
  "
>
  Once install service and Enable SSL on solr then check
  the&nbsp;solr&nbsp;page, make sure page is loaded with https. If the page is
  not loading correctly, you'll have to find the issue and fix it.
</p>
<p
  style="
    font-family: 'Helvetica Neue', Helvetica, Arial, Helvetica, sans-serif;
    white-space: normal;
  "
>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512425792/ud5h2kxe2xjspatfbguv.png"
    alt=""
  />
</p>
<p>&nbsp;</p>
<p>Now verify before you run Sitecore Installation Framework.</p>
<ul>
  <li>Installed IIS</li>
  <li>Installed SQL Server 2016 SP1</li>
  <li>Configured SQL Server 2016</li>
  <li>Install Solr and Enabled SSL on Solr</li>
</ul>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512426182/wpabrxzhb8yzuahyi6bo.png"
    alt=""
  />
</p>
<h3>install.ps1</h3>
<pre class="language-shell"><code>
Import-Module SitecoreFundamentals
Import-Module SitecoreInstallFramework

#define parameters 
$prefix = "sitecore_900"
$XConnectCollectionService = "$prefix.xconnect"
$sitecoreSiteName = "$prefix.local"
$SolrUrl = "https://localhost:8983/solr"
$SolrRoot = "C:\solr-6.6.2"
$SolrService = "solr"
$SqlServer = "Your local sql server name"
$SqlAdminUser = "sa"
$SqlAdminPassword = "your sa password" 
$SqlAccountUser = "$prefix"
$SqlAccountPassword = "Pa##w0rd" 
$FilesRoot = "C:\FolderContainsAllSitecoreFileForInstall"
 
#install client certificate for xconnect 
$certParams = 
@{     
    Path = "$FilesRoot\xconnect-createcert.json"     
    CertificateName = "$prefix.xconnect_client" 
} 
Install-SitecoreConfiguration @certParams -Verbose



#install solr cores for xdb 
$solrParams = 
@{
    Path = "$FilesRoot\xconnect-solr.json"     
    SolrUrl = $SolrUrl    
    SolrRoot = $SolrRoot  
    SolrService = $SolrService  
    CorePrefix = $prefix 
} 
Install-SitecoreConfiguration @solrParams -Verbose

#deploy xconnect instance 
$xconnectParams = 
@{
    Path = "$FilesRoot\xconnect-xp0.json"     
    Package = "$FilesRoot\Sitecore 9.0.0 rev. 171002 (OnPrem)_xp0xconnect.scwdp.zip"
    LicenseFile = "$FilesRoot\license.xml"
    Sitename = $XConnectCollectionService   
    XConnectCert = $certParams.CertificateName    
    SqlDbPrefix = $prefix  
    SqlServer = $SqlServer  
    SqlAdminUser = $SqlAdminUser
    SqlAdminPassword = $SqlAdminPassword
    SolrCorePrefix = $prefix
    SolrURL = $SolrUrl      
    SqlMarketingAutomationUser = $SqlAccountUser
    SqlMarketingAutomationPassword = $SqlAccountPassword
    SqlReferenceDataUser = $SqlAccountUser
    SqlReferenceDataPassword = $SqlAccountPassword
    SqlProcessingPoolsUser = $SqlAccountUser
    SqlProcessingPoolsPassword = $SqlAccountPassword
} 
Install-SitecoreConfiguration @xconnectParams -Verbose

#install solr cores for sitecore 
$solrParams = 
@{
    Path = "$FilesRoot\sitecore-solr.json"
    SolrUrl = $SolrUrl
    SolrRoot = $SolrRoot
    SolrService = $SolrService     
    CorePrefix = $prefix 
} 
Install-SitecoreConfiguration @solrParams -Verbose
 
#install sitecore instance 
$sitecoreParams = 
@{     
    Path = "$FilesRoot\sitecore-XP0.json"
    Package = "$FilesRoot\Sitecore 9.0.0 rev. 171002 (OnPrem)_single.scwdp.zip" 
    LicenseFile = "$FilesRoot\license.xml"
    SqlDbPrefix = $prefix  
    SqlServer = $SqlServer  
    SqlAdminUser = $SqlAdminUser     
    SqlAdminPassword = $SqlAdminPassword     
    SolrCorePrefix = $prefix  
    SolrUrl = $SolrUrl     
    XConnectCert = $certParams.CertificateName     
    Sitename = $sitecoreSiteName         
    XConnectCollectionService = "https://$XConnectCollectionService"    
    SqlCoreUser = $SqlAccountUser
    SqlCorePassword = $SqlAccountPassword
    SqlMasterUser = $SqlAccountUser
    SqlMasterPassword = $SqlAccountPassword
    SqlWebUser = $SqlAccountUser
    SqlWebPassword = $SqlAccountPassword
    SqlFormsUser = $SqlAccountUser
    SqlFormsPassword = $SqlAccountPassword
    SqlProcessingTasksUser = $SqlAccountUser
    SqlProcessingTasksPassword = $SqlAccountPassword
    SqlReportingUser = $SqlAccountUser
    SqlReportingPassword = $SqlAccountPassword
    SqlMarketingAutomationUser = $SqlAccountUser
    SqlMarketingAutomationPassword = $SqlAccountPassword
    SqlReferenceDataUser = $SqlAccountUser
    SqlReferenceDataPassword = $SqlAccountPassword
    SqlProcessingPoolsUser = $SqlAccountUser
    SqlProcessingPoolsPassword = $SqlAccountPassword
} 
Install-SitecoreConfiguration @sitecoreParams -Verbose
</code></pre>
<p>Run install.ps1</p>
<p>If everything correct, you should see your site with the prefix.</p>
<p>
  &nbsp;<img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512426618/znr3mjc1rihddrrjrble.png"
    alt=""
  />
</p>
<p>Conclusion</p>
<p>
  Compare to
  <a
    href="../blog/post/install-sitecore-via-sim-sitecore-instance-manager"
    target="_blank"
    rel="noopener"
    >how Sitecore 8 setup via SIM</a
  >, use PowerShell is a little complicated since there is something have to set
  up before that. That could make some mistake too. So if you install Sitecore
  9, I recommended doing following.
</p>
<ol>
  <li>Don't use Solr 7.*, use 6.* instead, for example, this blog use 6.2.2</li>
  <li>
    Don't use SQL Server 2014 or SQL Server 2014 SP2 if that's possible because
    some feature not work, so it's better to use SQL Server 2016.
  </li>
  <li>
    If you new, watch&nbsp;<a
      href="https://www.youtube.com/watch?v=-pMH7mcAVHg&amp;index=7&amp;list=PLBDqdodEhG7-9-hX5R_m2UAvpMKEZp-xY"
      target="_blank"
      rel="noopener"
      >this video</a
    >&nbsp;before try.
  </li>
</ol>
<p>References</p>
<ul>
  <li>
    <a
      href="https://dev.sitecore.net/Downloads/Sitecore_Experience_Platform/90/Sitecore_Experience_Platform_90_Initial_Release.aspx"
      target="_blank"
      rel="noopener"
      >Sitecore 9 download link</a
    >
  </li>
  <li>
    <a
      href="https://kamsar.net/index.php/2017/10/Quickly-add-SSL-to-Solr/"
      target="_blank"
      rel="noopener"
      >kamsar.net about quickly setup SSL on Solr</a
    >
  </li>
  <li>
    <a
      href="https://www.youtube.com/watch?v=-pMH7mcAVHg&amp;index=7&amp;list=PLBDqdodEhG7-9-hX5R_m2UAvpMKEZp-xY"
      target="_blank"
      rel="noopener"
      >Youtube video about how to install Sitecore 9</a
    >
  </li>
  <li>
    <a
      href="http://archive.apache.org/dist/lucene/solr/"
      target="_blank"
      rel="noopener"
      >Download Solr</a
    >
  </li>
  <li>
    <a
      href="https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt#ssdt-for-visual-studio-2017"
      target="_blank"
      rel="noopener"
      >Download SQL Server Data Tools (SSDT)</a
    >
  </li>
  <li>
    <a href="https://nssm.cc/download" target="_blank" rel="noopener"
      >Download NSSM</a
    >
  </li>
  <li>
    <a
      href="http://dl.sitecore.net/updater/info/static/install/sitecore900.txt"
      target="_blank"
      rel="noopener"
      >sitecore dev link for sample sitecore 9 script</a
    >
  </li>
</ul>


This blog will focus on How to set up the local development environment for Sitecore 9.

How to Install Sitecore 9


<p>
  Install Sitecore become easier by using
  <strong>Sitecore Instance Manager</strong>. This article will describe how to
  use SIM to install default Sitecore 8 site. Before start how to use install,
  the following are few links about SIM.
</p>
<h3>Sitecore Instance Manager useful links</h3>
<ol>
  <li>
    <a href="http://dl.sitecore.net/updater/sim/" target="_blank" rel="noopener"
      >Download SIM</a
    >
  </li>
  <ul>
    <li>Url for ClickOnce&nbsp;SIM product, go here to download SIM on pc.</li>
  </ul>
  <li>
    <a
      href="https://marketplace.sitecore.net/Modules/S/Sitecore_Instance_Manager.aspx"
      target="_blank"
      rel="noopener"
      >Sitecore Market Place - SIM</a
    >
  </li>
  <ul>
    <li>Sitecore Marketplace link about SIM</li>
  </ul>
  <li>
    <a
      href="https://github.com/Sitecore/Sitecore-Instance-Manager"
      target="_blank"
      rel="noopener"
      >Github - SIM</a
    >
  </li>
  <ul>
    <li>SIM is open source and host at Github.</li>
  </ul>
</ol>
<p>
  SIM provides great features, such as Install new Sitecore, Back up Sitecore
  Website, Install SQL Database and MongoDB. All these features make the
  Sitecore developers more productive.
</p>
<h3>Sitecore Instance Manager main features</h3>
<blockquote cite="https://github.com/Sitecore/Sitecore-Instance-Manager">
  <ul>
    <li>List Sitecore websites installed locally and their modules</li>
    <li>Install new Sitecore standalone product</li>
    <li>Install Sitecore modules and packages</li>
    <li>Download Sitecore products from SDN and DEV</li>
    <li>Back up Sitecore websites, and Restore them</li>
    <li>Export Sitecore website and Import it on remote computer</li>
  </ul>
</blockquote>
<h3>Pre Requirement for SIM Install</h3>
<p>
  Although SIM is open source Sitecore is not and not cheap, also Sitecore
  Instance is not easy to get it. You'll have to be certified Sitecore Developer
  than you can download from SDN, a Sitecore Developer Network site.
</p>
<ul>
  <li>Sitecore Instance</li>
  <ul>
    <li>
      At this example, we use Sitecore 8.2. Example file name looks like
      this.<code>Sitecore 8.2 rev. 170614.zip</code> Again, if you're the
      certified Sitecore developer you can download from SDN.
    </li>
  </ul>
  <li>Sitecore license</li>
  <ul>
    <li>
      You have to purchase&nbsp;from Sitecore, I don't think
      Sitecore&nbsp;provide a trial license. license file name like this
      <code>license.xml</code>
    </li>
  </ul>
  <li>SQL Server</li>
  <ul>
    <li>
      You'll need SQL Server, in this blog example, I'm using SQL Server
      Version&nbsp;12.0.4237.0.
    </li>
  </ul>
  <li><del>MongoDB</del></li>
  <ul>
    <li>
      You don't have to install MongoDB before SIM Installation, you can use SIM
      to download MongoDB and Install.
    </li>
  </ul>
  <li>IIS Manager</li>
  <ul>
    <li>
      You'll need this, Sitecore is Web Application. SIM will create the site,
      application pool, update windows host file once you use Sitecore Instance
      to create the site.
    </li>
  </ul>
</ul>
<p>
  Also, this blog sample OS is using Windows 10. SIM and Sitecore are not
  supported on Mac or Linux&nbsp;and I'm not sure they'll have the plan to
  support in the future or not. But SQL Server 2017 support Linux, .NET Core is
  cross-platform, so something might happen to Sitecore too.
</p>
<h3>Setup Sitecore Instance Manager - SIM</h3>
<h4>
  Download SIM via Click once at
  <a href="http://dl.sitecore.net/updater/sim/" target="_blank" rel="noopener"
    >here</a
  >
</h4>
<p>at this point, December 2017, latest version is 1.5</p>
<h4>Start SIM Installation Wizard</h4>
<p>Just click Next to first few License Agreement or information.</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512088179/twyir0xp1thlhxkgpjrj.png"
    alt=""
  />
</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512088179/npcudbemxn8pwaphcktx.png"
    alt=""
  />
</p>
<h4>Instance Root Folder</h4>
<p>
  Instances Root folder is where do you want your Sitecore instance to be
  stored, and this folder will be your IIS site folder, so make sure your folder
  has permission for permission.<code>NetworkService</code>
</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512088195/i3ckdewufa3prqbbvzze.png"
    alt=""
  />
</p>
<p>
  Local Repository put the location which contains the Sitecore zip file.
  <code>Sitecore 8.2 rev. 170614.zip</code> for instance. The Sitecore License
  file is the path for the Sitecore license.
</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512088390/iur1ui40bt4zradnlv8r.png"
    alt=""
  />
</p>
<p>
  Make sure Sitecore IIS site folder has permission to account.<code
    >Network Service</code
  >
</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512088403/uioc2yif0xfz1jvn9smu.png"
    alt=""
  />
</p>
<p>
  Enter SQL Server Name, SQL User Name, and SQL User Password. By default,
  windows service use&nbsp;<code>SQL Server</code> account
  <strong>NT SERVICE\MSSQLSERVER</strong>, change the SQL Server(MSSQLSERVER)
  windows service to use Network Service account.
</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512088410/ske7zclmbssziyoei9aa.png"
    alt=""
  />
</p>
<p>
  <img
    class="img-responsive"
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_7ry3j4a84.png"
    alt=""
  />
</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512088432/ksdtaamdexicuraznmi4.png"
    alt=""
  />
</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512088439/cqsth3mnpeeqguxpqki9.png"
    alt=""
  />
</p>
<p>
  After SIM installed successfully, launch it and click Installing new instance.
  By click following next button, SIM will create the new site, new SQL
  Database, new MongoDB database and add the hostname to host file.
</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512088472/svgdvsuuz0kpu4ymngi1.png"
    alt=""
  />
</p>
<p>
  <img
    class="img-responsive"
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_92m75cqy7.png"
    alt=""
  />
</p>
<p>The IIS site SIM generated.</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512089180/jy6o4acnb9sz71oivki0.png"
    alt=""
  />
</p>
<p>The Default Sitecore Site.</p>
<p>
  <img
    class="img-responsive"
    src="https://d1p0mp3f1fx0hz.cloudfront.net/_2ywrfaxqe.png"
    alt=""
  />
</p>
<p>Sitecore Admin site</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512152805/npz4u8hdiqbijhwp0iyg.png"
    alt=""
  />
</p>
<p>Sitecore Database</p>
<p>
  <img
    class="img-responsive"
    src="http://res.cloudinary.com/dmwrakaup/image/upload/v1512152805/ak0hj39uastr3bz5qrc2.png"
    alt=""
  />
</p>
<p>&nbsp;Other Info</p>
<ul>
  <li>SIM log location</li>
  <ul>
    <li>%AppData%\Sitecore\Sitecore Instance Manager</li>
  </ul>
  <li>
    <a
      href="https://github.com/Sitecore/Sitecore-Instance-Manager/releases"
      target="_blank"
      rel="noopener"
      >SIM Release Schedule</a
    >
  </li>
</ul>
<h3>Conclusion</h3>
<p>
  Use Sitecore Instance Manager is very powerful and very easy to setup Sitecore
  Development Environment if every other source already there you can launch a
  site within minutes, which the SIM will create site, application pool,
  database for you. Also, SIM has the backup and delete features make your
  Sitecore Development life easier.
</p>


This article will describe how to use SIM to install default Sitecore 8 site.

Install Sitecore via SIM (Sitecore Instance Manager)


<h3>How to add item in C# code</h3>
<pre class="language-csharp"><code>
 using (new Sitecore.SecurityModel.SecurityDisabler())
                {
                    var database = Sitecore.Configuration.Factory.GetDatabase("Master or Web");
                    TemplateItem template = database.GetItem("Your Page Item's page template url");
                    Item item = database.GetItem("where do you want to add the item");
                    Item newItem = item.Add("New Item name", template);
                    newItem.Editing.BeginEdit();
                    addItem(newItem);
                    newItem.Editing.EndEdit();
                    return newItem;
                }
</code></pre>


How to Add Item in Sitecore


<p>
  Few list to learn sitecore. Athough, I don't like Sitecore, but just in case
  if I have to do it, following are list of resource for reference.
</p>
<p>
  <a href="http://www.sitecore.net/" target="_blank">Sitecore Official Site</a>
</p>
<p>
  <a href="http://sitecoreexperiences.blogspot.com/" target="_blank"
    >Sitecore Blog - 1</a
  >
</p>
<p>
  <a href="http://sitecoreblog.blogspot.com/" target="_blank"
    >Sitecore Blog - 2</a
  >
</p>
<p>
  <a href="http://larsnielsen.blogspirit.com/index-1.html" target="_blank"
    >Sitecore Blog - 3</a
  >
</p>
<p>
  <a href="https://briancaos.wordpress.com/" target="_blank"
    >Sitecore Blog - 4</a
  >
</p>
<p>
  <a href="http://sitecore.alexiasoft.nl/" target="_blank">Sitecore Blog - 5</a>
</p>
<p>
  <a href="http://webcmd.wordpress.com/" target="_blank">Sitecore Blog - 6</a>
</p>
<p>
  <a href="http://thesitecoreexperience.blogspot.com/" target="_blank"
    >Sitecore Blog - 7</a
  >
</p>
<p>
  <a href="http://www.newguid.net/category/sitecore/resources/" target="_blank"
    >NewGuid.Net</a
  >
</p>
<p style="padding-left: 30px">&nbsp;all Sitecore related cotent</p>
<p>
  <a href="http://en.wikipedia.org/wiki/Sitecore" target="_blank"
    >wikipedia Sitecore</a
  >
</p>
<p>
  <a href="http://firebreaksice.com/" target="_blank"
    >Learn Sitecore - 1 - firebreaksice</a
  >
</p>
<p>
  <a href="http://learnsitecore.cmsuniverse.net/" target="_blank"
    >Learn Sitecore - 2</a
  >
</p>
<p>
  <a
    href="http://www.sitecore.net/learn/blogs/technical-blogs/john-west-sitecore-blog/posts/2010/11/best-sitecore-documentation.aspx"
    target="_blank"
    >Learn Sitecore - 3 - great documents</a
  >
</p>
<p style="padding-left: 30px">&nbsp;</p>
<p style="padding-left: 30px">&nbsp;</p>


Few list to learn sitecore. Athough, I don't like Sitecore, but just in case if I have to do it, following are list of resourcefor reference.

Category Sitecore

How to Create Sitecore Mvc Layout and Controller Rendering

How to Install Sitecore 9

Install Sitecore via SIM (Sitecore Instance Manager)

How to Add Item in Sitecore

List of Useful Links to Learn Sitecore