Skip to content

Instantly share code, notes, and snippets.

@ssvaidya
ssvaidya / SetIISACLPerms.ps1
Created December 13, 2016 16:22
Set ACL Permissions for an IIS Directory
Clear-Host
$WebsiteDir = "G:\Websites\DemoApp"
[string[]] $ACLPerms = "Administrators", "IIS_IUSRS", "IUSR"
#Assign the ACL Permissions
foreach ($permission in $ACLPerms)
{
$AccessRule =New-Object System.Security.AccessControl.FileSystemAccessRule($permission,"FullControl","ContainerInherit,ObjectInherit","InheritOnly","Allow")
@ssvaidya
ssvaidya / EFCodeFirstMultipleFKsDataAnnotations.cs
Created October 19, 2016 01:58
Entity Framework Code First with Multiple Foreign Keys to the same database table
public class Team
{
public int TeamId { get; set;}
public string Name { get; set; }
[InverseProperty("HomeTeam")]
public virtual ICollection<Match> HomeMatches { get; set; }
[InverseProperty("GuestTeam")]
public virtual ICollection<Match> AwayMatches { get; set; }
}
@ssvaidya
ssvaidya / EFCodeFirstMultipleFKs.cs
Created October 19, 2016 01:52
Entity Framework Code First with Multiple Foreign Keys to the same database table
public class Team
{
public int TeamId { get; set;}
public string Name { get; set; }
public virtual ICollection<Match> HomeMatches { get; set; }
public virtual ICollection<Match> AwayMatches { get; set; }
}
public class Match
@ssvaidya
ssvaidya / EFCodeFirstConnectionString.config
Created October 18, 2016 01:48
Entity Framework Code First Database connection string
<connectionStrings>
<add name="BlogContext"
providerName="System.Data.SqlClient"
connectionString="Server=.\SQLEXPRESS;Database=Blogging;Integrated Security=True;"/>
</connectionStrings>
@ssvaidya
ssvaidya / EFDatabaseFirstConnectionString.config
Created October 18, 2016 01:46
Entity Framework Database First connection String
<connectionStrings>
<add name="BlogContext"
connectionString="metadata=res://*/BloggingModel.csdl|
res://*/BloggingModel.ssdl|
res://*/BloggingModel.msl;
provider=System.Data.SqlClient
provider connection string=
&quot;data source=(localdb)\v11.0;
initial catalog=Blogging;
integrated security=True;
@ssvaidya
ssvaidya / ASPNETWebAPIRouteConstraints.cs
Last active October 7, 2016 13:36
ASP.NET Web API with Route Constraints
[Route("{id:int}")]
[HttpGet]
public IHttpActionResult GetById(int id)
{
try
{
return Ok(_myRepository.GetById(id));
}
catch (Exception ex)
{
@ssvaidya
ssvaidya / OracleODPNetTNSNamesConnString.xml
Created September 28, 2016 02:18
Oracle ODP.NET TNS Names Connection String
<configuration>
<connectionStrings>
<add name="OracleDatabase" connectionString="Data Source=ORCL;User Id=myUsername;Password=myPassword;" providerName="Oracle.ManagedDataAccess.Client" />
</connectionStrings>
</configuration>
@ssvaidya
ssvaidya / OracleODPNetConnString.xml
Created September 27, 2016 20:41
Oracle ODP.NET Connection String
<configuration>
<connectionStrings>
<add name="OracleDatabase" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SID=MyOracleSID)));User Id=myUsername;Password=myPassword;" providerName="Oracle.ManagedDataAccess.Client" />
</connectionStrings>
</configuration>
@ssvaidya
ssvaidya / MVCFuturesRedirectToAction.cs
Created September 27, 2016 16:31
ASP.NET MVC Futures Redirect To Action
using Microsoft.Web.Mvc;
public ActionResult RedirectToStronglyTypedAction
{
return this.RedirectToAction(c => c.Index(myId));
}
@ssvaidya
ssvaidya / MVCRedirectToAction.cs
Created September 27, 2016 16:25
ASP.NET MVC Redirect to Action
return RedirectToAction("Index", new { id = myId });