Lessons learned from WebAPI and MVC Implementations

My Notes on a painful journey to learn, make and publish a Azure hosted MVC, Sinlge-Page application, Android client app and a WebAPI working with-one another. Software technology can be real pain in the ass!!!

JSON and Self referencing loop

If you get the following error:

Self referencing loop detected for property ‘your model’ with type ‘System.Data.Entity.DynamicProxies

Solution:

Loop Reference handling in Web API

My Solution:

I used [JsonIgnore] attribute to tell the proper inheritance to JSON serialization.

using Newtonsoft.Json;

public partial class Set
{
public Set()
{
this.Exercises = new HashSet<Exercise>();
}

public long Id { get; set; }
public string Name { get; set; }
public string UserId { get; set; }

public virtual ICollection<Exercise> Exercises { get; set; }
}

public partial class ExerciseRecord
{
public long Id { get; set; }
public double Record { get; set; }
public System.DateTime Date { get; set; }
public System.DateTime StartDate { get; set; }
public System.DateTime EndDate { get; set; }
public long ExerciseId { get; set; }

[JsonIgnore]
public virtual Exercise Exercise { get; set; }
}

public partial class Exercise
{
public Exercise()
{
this.ExerciseAttributes = new HashSet<ExerciseAttribute>();
this.ExerciseRecords = new HashSet<ExerciseRecord>();
}

public long Id { get; set; }
public string Name { get; set; }
public double Target { get; set; }
public long SetId { get; set; }
[JsonIgnore]
public virtual Set Set { get; set; }
public virtual ICollection<ExerciseAttribute> ExerciseAttributes { get; set; }
public virtual ICollection<ExerciseRecord> ExerciseRecords { get; set; }
}

 

MVC loads older script files

This is due to browser script caching. The easiest solution for this is to set the browser which you are using to debug to retrieve the newest versions of web page content on each time you visit a webpage.

Missing Key definition from Model when creating a controller

You might get an error like this: EntityType ‘your type’ has no key defined. Define the key for this EntityType.

To fix such problems simply add this namespace definitions:

using System.ComponentModel.DataAnnotations;

And then define in your data model a key like this:

public class ColumnDataHighChart
{
[Key]
public int ID { get; set; }
public String Title { get; set; }
public String SubTitle { get; set; }
public IList<String> xAxisCategories { get; set; }
public String yAxisTitle { get; set; }
public IList<SeriesDataHighChart> Series { get; set; }

}

 

Intercepting web requests

 

I have two ways of doing this:

  1. A delegation handler
  2. Or an action filter for a controller.

Delegation handler

DelegatingHandler Class

Sample code:

public class AuthHandler : DelegatingHandler
{
protected async override Task<HttpResponseMessage> SendAsync(
HttpRequestMessage request, CancellationToken cancellationToken)
{
// Call the inner handler.
var response = await base.SendAsync(request, cancellationToken);
return response;
}
}

Action filter for a controlle

Notice that for MVC and Web API there are two different sets of action filter definitions:

http://msdn.microsoft.com/en-us/library/system.web.http.filters.actionfilterattribute(v=vs.118).aspx

http://msdn.microsoft.com/en-us/library/system.web.mvc.actionfilterattribute(v=vs.118).aspx

MVC Sample:

public class AuthenticationActionFilterHelper : ActionFilterAttribute
{
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
base.OnActionExecuting(filterContext);
if (HttpContext.Current != null && HttpContext.Current.User != null && HttpContext.Current.User.Identity.IsAuthenticated)
{
if (SessionHelper.LoggedInUser<AspNetUser>(HttpContext.Current.User.Identity.Name) == null)
{
//SessionHelper.UserSessionID = user.Id;
AspNetUsersController aspUserCon = new AspNetUsersController();
var sessionUser = aspUserCon.GetUser(HttpContext.Current.User.Identity.Name);
//SessionHelper.UserSessionID = user.UserName;
SessionHelper.LoggedInUser<AspNetUser>(sessionUser, sessionUser.UserName);
}
}
}

}

WebAPI Sample:

public class AuthenticationActionFilterHelper : ActionFilterAttribute
{
public override void OnActionExecuted(HttpActionExecutedContext actionExecutedContext)
{
base.OnActionExecuted(actionExecutedContext);
}

public override System.Threading.Tasks.Task OnActionExecutedAsync(HttpActionExecutedContext actionExecutedContext, System.Threading.CancellationToken cancellationToken)
{
return base.OnActionExecutedAsync(actionExecutedContext, cancellationToken);
}

public override void OnActionExecuting(HttpActionContext actionContext)
{
base.OnActionExecuting(actionContext);
if (HttpContext.Current != null && HttpContext.Current.User != null && HttpContext.Current.User.Identity.IsAuthenticated)
{
if (SessionHelper.LoggedInUser<AspNetUser>(HttpContext.Current.User.Identity.Name) == null)
{
//SessionHelper.UserSessionID = user.Id;
AspNetUsersController aspUserCon = new AspNetUsersController();
var sessionUser = aspUserCon.GetUser(HttpContext.Current.User.Identity.Name);
//SessionHelper.UserSessionID = user.UserName;
SessionHelper.LoggedInUser<AspNetUser>(sessionUser, sessionUser.UserName);
}
}
}

public override System.Threading.Tasks.Task OnActionExecutingAsync(HttpActionContext actionContext, System.Threading.CancellationToken cancellationToken)
{
return base.OnActionExecutingAsync(actionContext, cancellationToken);
}
}

 

Lambda Expression “Magic” 🙂

Retrieve distinct parent from child elements

As the title suggests I needed to retrieve the parent from a multilevel data set:

 

First I needed to get the child elements and in this exmaple it is assumed that you have the child elements retrieved.

Once you have the child elements it is time to get the distinct parent elements. for this I needed a way to group the distinct parent from the child elements. Here are my steps:

  • Get child elements:

ExerciseRecordsController exerciseRecordsController = new ExerciseRecordsController();
var exerciseRecordsData = exerciseRecordsController.GetExerciseRecords().Where(er => er.Date > startDate && er.Date < endDate && er.Exercise.Set.UserId.ToLower().CompareTo(this.user.Id.ToLower()) == 0);

  • Define a custom extension named “DistinctBy”

public static class LambdaExtensions
{
public static IEnumerable<t> DistinctBy<t>(this IEnumerable<t> list, Func<t, object> propertySelector)
{
return list.GroupBy(propertySelector).Select(x => x.First());
}
} Original code from: http://www.elevenwinds.com/linq-distinctby-with-lambda-expression-parameter

  • Apply the new extension on the data set

var setsData = exerciseRecordsData.DistinctBy(o => o.Exercise.SetId).Select( o => o.Exercise.Set);

How to create/populate a collection with data with an unknown data type

You may ask yourself why would anyone needs this? Well I do not why would others needs this but I came into a situation where I needed this.

I had a solution where I needed to be able to create data from a back-end server WebAPI to a JS HighCharts JS library without knowing what kind of data I would be processing, also I wanted to have the possibility to extend the back-end code so that it can return any kind of data to the client and let the client figure out what to do with the data.

So how to do this?

In a human language it goes something like this: Use LINQ in your code to go through the data set, select your data and return it as and array of objects, then create a new collection by passing to the constructor your processed data as an array of objects. Ofcourse your collection must store objects as well. The data type information is going to be stored because every class in C# is a descendant of the Object class.

public class SeriesDataHighChart
{
[Key]
public long ID { get; set; }
public String Name { get; set; }
public IList<object> Data { get; set; }
}

 

// One series corresponds to one set and data for each month
SeriesDataHighChart seriesData = new SeriesDataHighChart();

seriesData.ID = chartSet.Id;
seriesData.Name = chartSet.Name;
var seriesMonthsActivityCountData = (from monthActivityCount in chartSet.ChartSetMonthsData
select new object[] { monthActivityCount.ActivityCount as object });
seriesData.Data = new List<object>(seriesMonthsActivityCountData.ToArray());

hsData.Series.Add(seriesData);

 

You could also return an array of more complex object such as a key value pairs:

var sd = from d in unparsedData
select new object[] { d.Key as object, d.Value as object };

newSeries.Data = new Data(sd.ToArray());

Avoiding “Sequence contains no elements” exception in object initializers

If you have something like this in your code:

chartExercise.ChatMonthsData.Add(new ChartExerciseMonthData
{
ActivityCount = exercise.ExerciseRecords.Where(m => m.Date.Month == month && m.Date >= startDate && m.Date <= endDate).Count(),
StartDate = DateTime.Now.StartOfMonth(month),
EndDate = DateTime.Now.EndOfMonth(month),
MonthRecordAverage = exercise.ExerciseRecords.Where(m => m.Date.Month == month && m.Date >= startDate && m.Date <= endDate).Average(a => a.Record)

});

 

The Average lambda expression will throw the above exception error message because the Where clause may return Zero elements back(Notice that for example the Count expression will not throw a similar exception).

To fix(go around the problem, yes there might be other solutions but this was mine at the moment 🙂 ) I created an anonymous function that checks if there are elements returned by the clause and only then perform the Average operation on the elements. The solution is highlighted with the green color.

chartExercise.ChatMonthsData.Add(new ChartExerciseMonthData
{
ActivityCount = exercise.ExerciseRecords.Where(m => m.Date.Month == month && m.Date >= startDate && m.Date <= endDate).Count(),
StartDate = DateTime.Now.StartOfMonth(month),
EndDate = DateTime.Now.EndOfMonth(month),
MonthRecordAverage = new Func<double>(() => {
double averageRecord = 0;
var exerciseRecordByDateRange = exercise.ExerciseRecords.Where(m => m.Date.Month == month && m.Date >= startDate && m.Date <= endDate);
if (exerciseRecordByDateRange.Count() > 0)
averageRecord = exerciseRecordByDateRange.Average(a => a.Record);

return (averageRecord);
})()
});

 Get the count for a complex data structure/hierarchy, tree like

A rather simple implementation, choose to retrieve any records inside your main records set with a where:

set.Exercises.Where(o => o.ExerciseRecords.Any(m => m.Date.Month == month)).Count()

Update Azure SQL Database via SQL Server management studio and Generated scripts

  1. Mouse second button on database > Taskas > Generate Scripts > Choose your objects (Chose objects view) > Select “Advanced” button, then in the “Script for the database engine type” select option Windows Azure SQL Database
  2. Next open the database connection with management studio to your Azure SQL Database.
  3. Create a new empty database
  4. Open a new query windows and simply add the generated script to this window and run the script against the new empty database. This will create the structure and data if you selected so.

After deploying your WebAPI you get a following error when accessing your database data “There is already an open DataReader associated with this Command which must be closed first.”

To fix this error simply add the following to your connection strings used in your web api in Azure MultipleActiveResultSets=true.

Enable WebAPI Cross-Origin Resource Sharing (CORS)

You might run into problems after deploying your WebAPI to Azure and trying to access your api from different origins. Here is a solution:

http://www.codeproject.com/Articles/742532/Using-Web-API-Individual-User-Account-plus-CORS-En

Summary of the article above: Install the following nuget package in your WebAPI project: Microsoft.AspNet.WebApi.Cors

In your webapiconfig add the following(in green):

public static class WebApiConfig
{
public static void Register(HttpConfiguration config)
{
// Web API configuration and services
// Configure Web API to use only bearer token authentication.
config.SuppressDefaultHostAuthentication();
config.Filters.Add(new HostAuthenticationFilter(OAuthDefaults.AuthenticationType));

var cors = new EnableCorsAttribute(“*”, “*”, “*”);
config.EnableCors(cors);

// Web API routes
config.MapHttpAttributeRoutes();

config.Routes.MapHttpRoute(
name: “DefaultApi”,
routeTemplate: “api/{controller}/{id}”,
defaults: new { id = RouteParameter.Optional }
);

config.MessageHandlers.Add(new Handler.AuthHandler());
}
}

Next add the following to your ApplicationOAuthProvider.GrantResourceOwnerCredentials function:

public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
context.OwinContext.Response.Headers.Add(“Access-Control-Allow-Origin”, new[] { “*” });
var userManager = context.OwinContext.GetUserManager<ApplicationUserManager>();

ApplicationUser user = await userManager.FindAsync(context.UserName, context.Password);
//SessionHelper.UserSessionID = user.Id;
AspNetUsersController aspUserCon = new AspNetUsersController();
var sessionUser = aspUserCon.GetUser(user.Id);
//SessionHelper.UserSessionID = user.UserName;
SessionHelper.LoggedInUser<AspNetUser>(sessionUser, user.UserName);
if (user == null)
{
context.SetError(“invalid_grant”, “The user name or password is incorrect.”);
return;
}

ClaimsIdentity oAuthIdentity = await user.GenerateUserIdentityAsync(userManager,
OAuthDefaults.AuthenticationType);
ClaimsIdentity cookiesIdentity = await user.GenerateUserIdentityAsync(userManager,
CookieAuthenticationDefaults.AuthenticationType);

AuthenticationProperties properties = CreateProperties(user.UserName);
AuthenticationTicket ticket = new AuthenticationTicket(oAuthIdentity, properties);
context.Validated(ticket);
context.Request.Context.Authentication.SignIn(cookiesIdentity);

}

Notice that these changes may have undesired effects. Find out if these are suitable to your needs.

Advertisements

Good to Know: Windows Azure and Web Services functionality

Hi,

Here is my knowledge source listing for Windows Azure and Web Services functionality. Hope it helps someone:

Accessing Data
ADO.NET http://msdn.microsoft.com/en-us/library/e80y5yhx(v=vs.110).aspx
.NET Framework Data Providers http://msdn.microsoft.com/en-us/library/a6cd7c08(v=vs.110).aspx
ADO.NET Entity Data Model Designer http://msdn.microsoft.com/en-us/library/vstudio/cc716685(v=vs.100).aspx
ADO.NET Entity Data Model Designer http://msdn.microsoft.com/en-us/library/vstudio/cc716685(v=vs.100).aspx
ADO.NET Entity Data Model Tools http://msdn.microsoft.com/en-us/library/vstudio/bb399249(v=vs.100).aspx
Advanced using OData in .NET: WCF Data Services http://www.codeproject.com/Articles/135490/Advanced-using-OData-in-NET-WCF-Data-Services
ASP.NET Application State Overview http://msdn.microsoft.com/en-us/library/ms178594.aspx
ASP.NET Session State Overview http://msdn.microsoft.com/en-us/library/ms178581.aspx
CacheDependency Class http://msdn.microsoft.com/en-us/library/system.web.caching.cachedependency.aspx
CacheItemPolicy Class http://msdn.microsoft.com/en-us/library/system.runtime.caching.cacheitempolicy(v=vs.110).aspx
CacheItemPriority Enumeration http://msdn.microsoft.com/en-us/library/system.web.caching.cacheitempriority.aspx
ChangeMonitor Class http://msdn.microsoft.com/en-us/library/system.runtime.caching.changemonitor(v=vs.110).aspx
Code First to an Existing Database http://msdn.microsoft.com/en-us/data/jj200620.aspx
CommandType Enumeration http://msdn.microsoft.com/en-us/library/system.data.commandtype(v=vs.110).aspx
Configuring Parameters and Parameter Data Types http://msdn.microsoft.com/en-us/library/yy6y35y8(v=vs.110).aspx
Create Database Wizard (Master Data Services Configuration Manager) http://technet.microsoft.com/en-us/library/ee633799.aspx
DataAdapter Class http://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.aspx
DataAdapter.AcceptChangesDuringFill Property http://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.acceptchangesduringfill(v=vs.110).aspx
DataContractAttribute Class http://msdn.microsoft.com/en-us/library/system.runtime.serialization.datacontractattribute.aspx
DataSet Class http://msdn.microsoft.com/en-us/library/system.data.dataset.aspx
DataSet Class http://msdn.microsoft.com/en-us/library/system.data.dataset.aspx
DataTable Class http://msdn.microsoft.com/en-us/library/system.data.datatable.aspx
DbContext Class http://msdn.microsoft.com/en-us/library/system.data.entity.dbcontext(v=vs.113).aspx
DBContext vs ObjectContexts http://www.entityframeworktutorial.net/EntityFramework4.3/dbcontext-vs-objectcontext.aspx
DbContext.SaveChanges Method http://msdn.microsoft.com/en-us/library/system.data.entity.dbcontext.savechanges(v=vs.113).aspx
DbContext.Set<TEntity> Method http://msdn.microsoft.com/en-us/library/gg696521(v=vs.113).aspx
DbDataAdapter.Fill Method (DataSet) http://msdn.microsoft.com/en-us/library/zxkb3c3d(v=vs.110).aspx
DbDataAdapter.Update Method (DataSet) http://msdn.microsoft.com/en-us/library/at8a576f(v=vs.110).aspx
Demystifying Entity Framework Strategies: Loading Related Data (Eager Loading,  Lazy Loading, Explicitly Loading) http://msdn.microsoft.com/en-us/magazine/hh205756.aspx
EdmEntityTypeAttribute Class http://msdn.microsoft.com/en-us/library/system.data.objects.dataclasses.edmentitytypeattribute(v=vs.110).aspx
EF Designer TPT Inheritance http://msdn.microsoft.com/en-us/data/jj618293.aspx
Entity Data Model Wizard http://msdn.microsoft.com/en-us/library/vstudio/bb399247(v=vs.100).aspx
Entity Framework http://msdn.microsoft.com/en-US/data/ef
Entity Framework – Database First http://msdn.microsoft.com/en-us/data/jj206878.aspx
Entity Framework (EF) Documentation http://msdn.microsoft.com/en-us/data/ee712907.aspx
Entity Framework 5: Controlling automatic query compilation http://blogs.msdn.com/b/stuartleeks/archive/2012/06/12/entity-framework-5-controlling-automatic-query-compilation.aspx
Entity Framework- Code First to a New Database http://msdn.microsoft.com/en-us/data/jj193542.aspx
EntityCommand Class http://msdn.microsoft.com/en-us/library/system.data.entityclient.entitycommand.aspx
EntityConnection Class http://msdn.microsoft.com/en-us/library/system.data.entityclient.entityconnection(v=vs.110).aspx
EntityObject Class http://msdn.microsoft.com/en-us/library/system.data.objects.dataclasses.entityobject(v=vs.110).aspx
EntityTransaction Class http://msdn.microsoft.com/en-us/library/system.data.entityclient.entitytransaction.aspx
How to: Use Lazy Loading to Load Related Objects http://msdn.microsoft.com/en-us/library/vstudio/dd456846(v=vs.100).aspx
HttpContext.Cache Property http://msdn.microsoft.com/en-us/library/system.web.httpcontext.cache(v=vs.110).aspx
Improve Performance with Entity Framework 5 http://devproconnections.com/entity-framework/improve-performance-entity-framework-5
IsolationLevel Enumeration http://msdn.microsoft.com/en-us/library/system.data.isolationlevel.aspx
LINQ (Language-Integrated Query) http://msdn.microsoft.com/en-us/library/bb397926.aspx
LINQ to Entities: Basic Concepts and Features http://www.codeproject.com/Articles/246861/LINQ-to-Entities-Basic-Concepts-and-Features
LINQ to Objects http://msdn.microsoft.com/en-us/library/bb397919.aspx
LINQ to XML [from BPUEDev11] http://msdn.microsoft.com/en-us/library/bb387098.aspx
LINQ to XML Overview http://msdn.microsoft.com/en-us/library/bb387061.aspx
Loading Related Entities (Eager Loading,  Lazy Loading, Explicitly Loading) http://msdn.microsoft.com/en-us/data/jj574232.aspx
Model-First in the Entity Framework 4 http://msdn.microsoft.com/en-us/data/ff830362.aspx
ObjectCache Class http://msdn.microsoft.com/en-us/library/vstudio/system.runtime.caching.objectcache
ObjectContext Class http://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext(v=vs.110).aspx
ObjectContext management http://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.contextoptions(v=vs.110).aspx
ObjectQuery Class http://msdn.microsoft.com/en-us/library/system.data.objects.objectquery(v=vs.110).aspx
ObjectQuery.ToTraceString Method http://msdn.microsoft.com/en-us/library/system.data.objects.objectquery.totracestring(v=vs.110).aspx
ObjectQuery<T> Class http://msdn.microsoft.com/en-us/library/bb345303(v=vs.110).aspx
Object-relational impedance mismatch http://en.wikipedia.org/wiki/Object-Relational_impedance_mismatch
OData protocol http://www.odata.org/
Open Data Protocol by Example http://msdn.microsoft.com/en-us/library/ff478141.aspx
Plain Old CLR Object(POCO) http://en.wikipedia.org/wiki/Plain_Old_CLR_Object
Precompiling LINQ Queries http://msdn.microsoft.com/en-us/magazine/ee336024.aspx
Queries in LINQ to Entities http://msdn.microsoft.com/en-us/library/vstudio/bb399367(v=vs.100).aspx
Relational database management system http://en.wikipedia.org/wiki/Relational_database_management_system
Retrieving Data Using a DataReader http://msdn.microsoft.com/en-us/library/haa3afyz(v=vs.110).aspx
SerializableAttribute Class http://msdn.microsoft.com/en-us/library/system.serializableattribute.aspx
SQL Server Connection Pooling (ADO.NET) http://msdn.microsoft.com/en-us/library/vstudio/8xx3tyca%28v%3Dvs.100%29
SqlCommand Class http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx
SqlCommand.CommandText Property http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtext(v=vs.110).aspx
SqlCommand.ExecuteReader Method http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executereader(v=vs.110).aspx
SqlCommand.ExecuteScalar Method http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executescalar(v=vs.110).aspx
SqlConnection Class http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.aspx
SqlConnectionStringBuilder Class http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder.aspx
SqlDataAdapter Class http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.aspx
SqlDataReader Class http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.aspx
SqlDataReader.Read Method http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.read.aspx
SqlParameter Class http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter.aspx
SqlTransaction Class http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqltransaction.aspx
System.Data.EntityClient Namespace http://msdn.microsoft.com/en-us/library/system.data.entityclient(v=vs.110).aspx
System.Data.SqlClient Namespace http://msdn.microsoft.com/en-us/library/System.Data.SqlClient(v=vs.110).aspx
System.Transactions Namespace http://msdn.microsoft.com/en-us/library/system.transactions.aspx
System.Xml Namespaces http://msdn.microsoft.com/en-us/library/gg145036(v=vs.110).aspx
Table-per-Type vs Table-per-Hierarchy Inheritance http://blog.devart.com/table-per-type-vs-table-per-hierarchy-inheritance.html
The ADO.NET Entity Framework Overview http://msdn.microsoft.com/en-us/library/aa697427(v=vs.80).aspx
TransactionScope Class http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx
Understanding ASP.NET View State http://msdn.microsoft.com/en-us/library/ms972976.aspx
Understanding Service-Oriented Architecture http://msdn.microsoft.com/en-us/library/aa480021.aspx
Update Model Wizard (Entity Data Model Tools) http://msdn.microsoft.com/en-us/library/vstudio/cc716705(v=vs.100).aspx
Using the DbContext API http://msdn.microsoft.com/en-us/data/gg192989.aspx
Using the REST Interface http://msdn.microsoft.com/en-us/library/ff798339.aspx
Walkthrough: Mapping Table-per-Hierarchy Inheritance in Dynamic Data http://msdn.microsoft.com/en-us/library/dd793152.ASPX
WCF Data Services 4.5 http://msdn.microsoft.com/en-us/library/cc668792(v=vs.110).aspx
WCF Data Services Overview http://msdn.microsoft.com/en-us/library/cc668794(v=vs.110).aspx
Working with Datasets in Visual Studio http://msdn.microsoft.com/en-us/library/8bw9ksd6%28v%3Dvs.110%29.aspx
Working with POCO Entities http://msdn.microsoft.com/en-us/library/vstudio/dd456853(v=vs.100).aspx
XElement Class http://msdn.microsoft.com/en-us/library/system.xml.linq.xelement.aspx
XML Documents and Data http://msdn.microsoft.com/en-us/library/2bcctyt8(v=vs.110).aspx
XmlDocument Class http://msdn.microsoft.com/en-us/library/system.xml.xmldocument.aspx
XmlReader Class http://msdn.microsoft.com/en-us/library/vstudio/system.xml.xmlreader
XmlWriter Class http://msdn.microsoft.com/en-us/library/system.xml.xmlwriter.aspx
XPath Examples http://msdn.microsoft.com/en-us/library/ms256086(v=vs.110).aspx
Designing and implementing WCF Services – Create, Configure, Secure, Consume
<basicHttpBinding> http://msdn.microsoft.com/en-us/library/ms731361(v=vs.110).aspx
<bindings> http://msdn.microsoft.com/en-us/library/ms731399(v=vs.110).aspx
<mexHttpBinding> http://msdn.microsoft.com/en-us/library/aa967390(v=vs.110).aspx
<mexHttpsBinding> http://msdn.microsoft.com/en-us/library/aa967391(v=vs.110).aspx
<mexNamedPipeBinding> http://msdn.microsoft.com/en-us/library/aa967280(v=vs.110).aspx
<netMsmqBinding> http://msdn.microsoft.com/en-us/library/ms731380(v=vs.110).aspx
<protocolMapping> http://msdn.microsoft.com/en-us/library/ee816881(v=vs.110).aspx
<wsHttpBinding> http://msdn.microsoft.com/en-us/library/ms731299(v=vs.110).aspx
Accessing Services Using a WCF Client http://msdn.microsoft.com/en-us/library/ms734691(v=vs.110).aspx
Azure Service Bus http://azure.microsoft.com/en-us/documentation/articles/fundamentals-service-bus-hybrid-solutions/
Basic [WCF Samples] http://msdn.microsoft.com/en-us/library/dd699756(v=vs.110).aspx
BasicHttpBinding Class http://msdn.microsoft.com/en-us/library/system.servicemodel.basichttpbinding(v=vs.110).aspx
BinaryMessageEncodingBindingElement Class http://msdn.microsoft.com/en-us/library/system.servicemodel.channels.binarymessageencodingbindingelement(v=vs.110).aspx
Binding [WCF Samples] http://msdn.microsoft.com/en-us/library/dd699760(v=vs.110).aspx
Chapter 7: Message and Transport Security http://msdn.microsoft.com/en-us/library/ff648863.aspx
Choosing a Message Exchange Pattern http://msdn.microsoft.com/en-us/library/aa751829(v=vs.110).aspx
CompositeDuplexBindingElement Class http://msdn.microsoft.com/en-us/library/system.servicemodel.channels.compositeduplexbindingelement(v=vs.110).aspx
Configuration Editor Tool (SvcConfigEditor.exe) http://msdn.microsoft.com/en-us/library/ms732009(v=vs.110).aspx
Configuring Services Using Configuration Files http://msdn.microsoft.com/en-us/library/ms733932(v=vs.110).aspx
Creating the Web Service Proxy http://msdn.microsoft.com/en-us/library/ms155134.aspx
Custom Binding Samples http://msdn.microsoft.com/en-us/library/vstudio/ms751479(v=vs.90).aspx
Custom Bindings http://msdn.microsoft.com/en-us/library/aa347793(v=vs.110).aspx
Data Contract Known Types http://msdn.microsoft.com/en-us/library/ms730167(v=vs.110).aspx
DataContractAttribute Class http://msdn.microsoft.com/en-us/library/system.runtime.serialization.datacontractattribute(v=vs.110).aspx
DataMemberAttribute Class http://msdn.microsoft.com/en-us/library/system.runtime.serialization.datamemberattribute(v=vs.110).aspx
Difference between BasicHttpBinding and WsHttpBinding http://www.codeproject.com/Articles/36396/Difference-between-BasicHttpBinding-and-WsHttpBind
Endpoints: Addresses, Bindings, and Contracts http://msdn.microsoft.com/en-us/library/ms733107(v=vs.110).aspx
EnumMemberAttribute Class http://msdn.microsoft.com/en-us/library/system.runtime.serialization.enummemberattribute(v=vs.110).aspx
Extending Dispatchers http://msdn.microsoft.com/en-us/library/ms734665.aspx
Extensibility [WCF Samples] http://msdn.microsoft.com/en-us/library/dd699779(v=vs.110).aspx
Fault Contract http://msdn.microsoft.com/en-us/library/ms752208(v=vs.110).aspx
Fault Contract – Handling Errors in WCF and A Very Simple WCF Service Implementation http://www.codeproject.com/Articles/376303/Fault-Contract-Handling-Errors-in-WCF-and-A-Very-S
Getting Started Tutorial http://msdn.microsoft.com/en-us/library/ms734712(v=vs.110).aspx
Host WCF in an Azure worker role (CSAzureWCFWorkerRole) https://code.msdn.microsoft.com/windowsazure/CSAzureWCFWorkerRole-38b4e51d
Hosting WCF Services http://www.codemag.com/Article/0701041
How to: Create a Transactional Service http://msdn.microsoft.com/en-us/library/ms730232(v=vs.110).aspx
How to: Create a Windows Communication Foundation Client http://msdn.microsoft.com/en-us/library/ms733133(v=vs.110).aspx
How to: Expose a Metadata Endpoint http://msdn.microsoft.com/en-us/library/azure/ee706721.aspx
How to: Implement a Windows Communication Foundation Service Contract http://msdn.microsoft.com/en-us/library/ms734686(v=vs.110).aspx
How to: Inspect or Modify Messages on the Client http://msdn.microsoft.com/en-us/library/ms733786(v=vs.110).aspx
How to: Set the Security Mode http://msdn.microsoft.com/en-us/library/ms731884(v=vs.110).aspx
How to: Use the ChannelFactory http://msdn.microsoft.com/en-us/library/ms734681(v=vs.110).aspx
IClientMessageInspector Interface http://msdn.microsoft.com/en-us/library/system.servicemodel.dispatcher.iclientmessageinspector(v=vs.110).aspx
IDispatchMessageInspector Interface http://msdn.microsoft.com/en-us/library/system.servicemodel.dispatcher.idispatchmessageinspector(v=vs.110).aspx
KnownTypeAttribute Class http://msdn.microsoft.com/en-us/library/system.runtime.serialization.knowntypeattribute(v=vs.110).aspx
Message Inspectors http://msdn.microsoft.com/en-us/library/aa717047(v=vs.110).aspx
Message Patterns in WCF Services http://msdn.microsoft.com/en-us/library/ff395349.aspx
Message Security in WCF http://msdn.microsoft.com/en-us/library/ms733137(v=vs.110).aspx
MetadataExchangeBindings Class http://msdn.microsoft.com/en-us/library/System.ServiceModel.Description.MetadataExchangeBindings(v=vs.110).aspx
MtomMessageEncodingBindingElement Class http://msdn.microsoft.com/en-us/library/system.servicemodel.channels.mtommessageencodingbindingelement(v=vs.110).aspx
NetMsmqBinding Class http://msdn.microsoft.com/en-us/library/system.servicemodel.netmsmqbinding(v=vs.110).aspx
NetNamedPipeBinding Class http://msdn.microsoft.com/en-us/library/system.servicemodel.netnamedpipebinding(v=vs.110).aspx
OneWayBindingElement Class http://msdn.microsoft.com/en-us/library/system.servicemodel.channels.onewaybindingelement(v=vs.110).aspx
OperationBehaviorAttribute Class http://msdn.microsoft.com/en-us/library/system.servicemodel.operationbehaviorattribute(v=vs.110).aspx
OperationContractAttribute Class http://msdn.microsoft.com/en-us/library/system.servicemodel.operationcontractattribute(v=vs.110).aspx
Programming WCF Security http://msdn.microsoft.com/en-us/library/ms731925(v=vs.110).aspx
Publishing Metadata http://msdn.microsoft.com/en-us/library/aa751951(v=vs.110).aspx
Reliable Sessions Overview http://msdn.microsoft.com/en-us/library/ms733136.aspx
ReliableSessionBindingElement Class http://msdn.microsoft.com/en-us/library/system.servicemodel.channels.reliablesessionbindingelement(v=vs.110).aspx
Scenario [WCF Samples] http://msdn.microsoft.com/en-us/library/dd699770(v=vs.110).aspx
Securing and Authenticating a Service Bus Connection http://msdn.microsoft.com/library/azure/dd582773.aspx
SecurityBindingElement Class http://msdn.microsoft.com/en-us/library/system.servicemodel.channels.securitybindingelement(v=vs.110).aspx
Service Bus Bindings http://msdn.microsoft.com/library/azure/hh410102.aspx
Service Bus Queues, Topics, and Subscriptions http://msdn.microsoft.com/library/azure/hh367516.aspx
ServiceBehaviorAttribute Class http://msdn.microsoft.com/en-us/library/system.servicemodel.servicebehaviorattribute(v=vs.110).aspx
ServiceContractAttribute Class http://msdn.microsoft.com/en-us/library/system.servicemodel.servicecontractattribute(v=vs.110).aspx
ServiceHost Class http://msdn.microsoft.com/en-us/library/system.servicemodel.servicehost(v=vs.110).aspx
ServiceModel Metadata Utility Tool (Svcutil.exe) http://msdn.microsoft.com/en-us/library/aa347733(v=vs.110).aspx
Sessions, Instancing, and Concurrency http://msdn.microsoft.com/en-us/library/ms731193(v=vs.110).aspx
Simplified Configuration http://msdn.microsoft.com/en-us/library/ee358768(v=vs.110).aspx
Simplified Configuration for WCF Services http://msdn.microsoft.com/en-us/library/ee530014(v=vs.110).aspx
SslStreamSecurityBindingElement Class http://msdn.microsoft.com/en-us/library/system.servicemodel.channels.sslstreamsecuritybindingelement(v=vs.110).aspx
Status codes http://www.w3.org/Protocols/HTTP/HTRESP.html
System-Provided Bindings http://msdn.microsoft.com/en-us/library/ms730879.aspx
TextMessageEncodingBindingElement Class http://msdn.microsoft.com/en-us/library/system.servicemodel.channels.textmessageencodingbindingelement(v=vs.110).aspx
TransactionFlowBindingElement Class http://msdn.microsoft.com/en-us/library/system.servicemodel.channels.transactionflowbindingelement(v=vs.110).aspx
Transactions in WCF Services http://msdn.microsoft.com/en-us/library/ff384250.aspx
Types Supported by the Data Contract Serializer http://msdn.microsoft.com/en-us/library/ms731923.aspx
Using Data Contracts http://msdn.microsoft.com/en-us/library/ms733127(v=vs.110).aspx
WCF Configuration Tools http://msdn.microsoft.com/en-us/library/vstudio/hh323723(v=vs.100).aspx
WCF Extensibility – IParameterInspector http://blogs.msdn.com/b/endpoint/archive/2011/04/28/wcf-extensibility-iparameterinspector.aspx
WCF Extensibility: Parameter Inspectors http://cgeers.com/2008/11/09/wcf-extensibility-parameter-inspectors/
Versioning Strategies http://msdn.microsoft.com/en-us/library/ff384251.aspx
Windows Communication Foundation Endpoints http://msdn.microsoft.com/en-us/library/ms733821(v=vs.110).aspx
Windows Communication Foundation Tools http://msdn.microsoft.com/en-us/library/ms732015(v=vs.110).aspx
WindowsStreamSecurityBindingElement Class http://msdn.microsoft.com/en-us/library/system.servicemodel.channels.windowsstreamsecuritybindingelement(v=vs.110).aspx
WSHttpBinding Class http://msdn.microsoft.com/en-us/library/system.servicemodel.wshttpbinding(v=vs.110).aspx
Creating and consuming Web API-based services – Design, Implement, Secure, Host and Manage, Consume
A WebAPI Basic Authentication Authorization Filter http://weblog.west-wind.com/posts/2013/Apr/18/A-WebAPI-Basic-Authentication-Authorization-Filter
AcceptVerbsAttribute Class http://msdn.microsoft.com/en-us/library/system.web.http.acceptverbsattribute%28v=vs.118%29.aspx
ActionFilterAttribute Class http://msdn.microsoft.com/en-us/library/system.web.http.filters.actionfilterattribute(v=vs.118).aspx
Add Models and Controllers http://www.asp.net/web-api/overview/data/using-web-api-with-entity-framework/part-2
Async Streaming in ASP.NET Web API http://blogs.msdn.com/b/henrikn/archive/2012/02/24/async-actions-in-asp-net-web-api.aspx
Asynchronous Programming with Async and Await (C# and Visual Basic) http://msdn.microsoft.com/en-us/library/hh191443.aspx
Authentication and Authorization in ASP.NET Web API http://www.asp.net/web-api/overview/security/authentication-and-authorization-in-aspnet-web-api
Basic Authentication in ASP.NET Web API http://www.asp.net/web-api/overview/security/basic-authentication
Content Negotiation in ASP.NET Web API http://www.asp.net/web-api/overview/formats-and-model-binding/content-negotiation
Cross-Site Request Forgery (CSRF) https://www.owasp.org/index.php/Cross-Site_Request_Forgery
Dependency Injection in ASP.NET Web API 2 http://www.asp.net/web-api/overview/advanced/dependency-injection
Enabling Cross-Origin Requests in ASP.NET Web API 2 http://www.asp.net/web-api/overview/security/enabling-cross-origin-requests-in-web-api
Enabling CRUD Operations in ASP.NET Web API 1 http://www.asp.net/web-api/overview/older-versions/creating-a-web-api-that-supports-crud-operations
Forms Authentication in ASP.NET Web API http://www.asp.net/web-api/overview/security/forms-authentication
Getting Started with ASP.NET Web API 2 (C#) http://www.asp.net/web-api/overview/getting-started-with-aspnet-web-api/tutorial-your-first-web-api
How to host your web API. http://www.asp.net/web-api/overview/hosting-aspnet-web-api
HTTP Authentication: Basic and Digest Access Authentication http://www.ietf.org/rfc/rfc2617.txt
HttpClient Class http://msdn.microsoft.com/en-us/library/system.net.http.httpclient%28v=vs.118%29.aspx
HttpClient.GetAsync Method (String) http://msdn.microsoft.com/en-us/library/hh158944(v=vs.118).aspx
HttpMessageHandler Class http://msdn.microsoft.com/en-us/library/system.net.http.httpmessagehandler(v=vs.118).aspx
HttpResponseException Class http://msdn.microsoft.com/en-us/library/system.web.http.httpresponseexception(v=vs.118).aspx
HttpResponseMessage Class http://msdn.microsoft.com/en-us/library/system.net.http.httpresponsemessage(v=vs.118).aspx
Integrated Windows Authentication http://www.asp.net/web-api/overview/security/integrated-windows-authentication
JSON and XML Serialization in ASP.NET Web API http://www.asp.net/web-api/overview/formats-and-model-binding/json-and-xml-serialization
Makecert.exe (Certificate Creation Tool) http://msdn.microsoft.com/en-us/library/bfsktky3.aspx
Media Formatters in ASP.NET Web API 2 http://www.asp.net/web-api/overview/formats-and-model-binding/media-formatters
Media Formatters in ASP.NET Web API 2 http://www.asp.net/web-api/overview/formats-and-model-binding/media-formatters
Parameter Binding in ASP.NET Web API http://www.asp.net/web-api/overview/formats-and-model-binding/parameter-binding-in-aspnet-web-api
Preventing Cross-Site Request Forgery (CSRF) Attacks in ASP.NET Web API http://www.asp.net/web-api/overview/security/preventing-cross-site-request-forgery-(csrf)-attacks
Preventing CSRF Hacks in ASP.NET WebAPI http://www.dotnetcurry.com/showarticle.aspx?id=890
Routing Service http://msdn.microsoft.com/en-us/library/ee517423(v=vs.110).aspx
Routing Services [WCF Samples] http://msdn.microsoft.com/en-us/library/ee517423(v=vs.110).aspx
synchronous Streaming in ASP.NET WebApi http://weblogs.asp.net/andresv/asynchronous-streaming-in-asp-net-webapi
Using Asynchronous Methods in ASP.NET MVC 4 http://www.asp.net/mvc/overview/performance/using-asynchronous-methods-in-aspnet-mvc-4
WEB API 2 USING ACTIONFILTERATTRIBUTE, OVERRIDEACTIONFILTERSATTRIBUTE AND IOC INJECTION http://damienbod.wordpress.com/2014/01/04/web-api-2-using-actionfilterattribute-overrideactionfiltersattribute-and-ioc-injection/
Working with SSL in Web API http://www.asp.net/web-api/overview/security/working-with-ssl-in-web-api
Deploying web applications and services
Azure Guest OS Releases and SDK Compatibility Matrix http://msdn.microsoft.com/library/azure/ee924680.aspx
Azure Service Definition Schema (.csdef File) http://msdn.microsoft.com/library/azure/ee758711.aspx
Configuring a Web Server for Web Deploy Publishing (Remote Agent) http://www.asp.net/web-forms/overview/deployment/configuring-server-environments-for-web-deployment/configuring-a-web-server-for-web-deploy-publishing-(remote-agent)
Configuring Parameters for Web Package Deployment http://www.asp.net/web-forms/overview/deployment/web-deployment-in-the-enterprise/configuring-parameters-for-web-package-deployment
Configuring Step 1: Install IIS and ASP.NET Modules http://www.iis.net/learn/application-frameworks/scenario-build-an-aspnet-website-on-iis/configuring-step-1-install-iis-and-asp-net-modules
Continuous Delivery for Cloud Services in Azure http://azure.microsoft.com/en-us/documentation/articles/cloud-services-dotnet-continuous-delivery/
Continuous delivery to Azure using Visual Studio Online http://azure.microsoft.com/en-us/documentation/articles/cloud-services-continuous-delivery-use-vso/
Export a Package through IIS Manager http://www.iis.net/learn/publish/using-web-deploy/export-a-package-through-iis-manager
Get Started with Azure Cmdlets http://msdn.microsoft.com/library/azure/jj554332.aspx
Get started with Azure Websites and ASP.NET http://azure.microsoft.com/en-us/documentation/articles/web-sites-dotnet-get-started/
How to Configure Cloud Services http://azure.microsoft.com/en-us/documentation/articles/cloud-services-how-to-configure/
How to Deploy an Azure Website http://azure.microsoft.com/en-us/documentation/articles/web-sites-deploy/
IIS Information http://www.iis.net/
Installing and Configuring Web Deploy on IIS 7 http://www.iis.net/learn/install/installing-publishing-technologies/installing-and-configuring-web-deploy
Installing NuGet http://docs.nuget.org/docs/start-here/installing-nuget
Manage Deployments in Azure http://msdn.microsoft.com/en-us/library/azure/gg433027.aspx
NetworkConfiguration Schema http://msdn.microsoft.com/library/azure/jj156091.aspx
Nuspec Reference http://docs.nuget.org/docs/reference/nuspec-reference
Package Manager Console Powershell Reference http://docs.nuget.org/docs/Reference/Package-Manager-Console-PowerShell-Reference
Reference for the Web Application Package http://www.iis.net/learn/develop/windows-web-application-gallery/reference-for-the-web-application-package
Shadow Copying Assemblies http://msdn.microsoft.com/en-us/library/ms404279(v=vs.110).aspx
Step 1: Examining the Configuration Files http://msdn.microsoft.com/en-us/library/8f6988ab.aspx
Swap Deployment http://msdn.microsoft.com/en-us/library/azure/ee460814.aspx
Team Build + Web Deployment + Web Deploy + VS 2010 = Goodness http://vishaljoshi.blogspot.nl/2010/11/team-build-web-deployment-web-deploy-vs.html
Web Deploy Command Line Syntax http://technet.microsoft.com/en-us/library/dd569106.aspx
Web Deployment Overview for Visual Studio and ASP.NET http://msdn.microsoft.com/en-us/library/dd394698.aspx
Web.config Transformation Syntax for Web Project Deployment Using Visual Studio http://msdn.microsoft.com/en-us/library/dd465326.aspx
Xcopy http://technet.microsoft.com/en-us/library/cc771254.aspx

Excel Services whitespace problems with parameterized queries when loading excel sheets

If you are having problems with spaces when accessing excel sheets with spaces in their names what you need to do is to add two single quotes on both left and right of the sheet name.

Sample query to get a HTML formatted sheet data with start and end cell definitions:
http://webapplicationname/_vti_bin/ExcelRest.aspx/Documents/file.xlsx/model/Ranges(”’sheet name with spaces goes here”!A1%7CF63′)?$format=html
The query above has a spaces in the sheet name. In the sample above the sheet name is “sheet name with spaces goes here“.

NOTICE: Add two single quote ‘ not one double quote “.

If you where to use a formatted string to fill in the missing data it would look something like this:

String excelWebServicesURL = “{0}/_vti_bin/ExcelRest.aspx/{1}/model/Ranges(”'{2}”!{3}|{4}’)?$format=html”;

0 = your site absolute URL. This means the present site location inside your site collection.

1 = the relative URL to the excel file

2 = the sheet name

3 = The cell where to start the reading of data from

4 = The cell where to end the reading of data to

Excel Webservices Anonymous parametric data access problems

Hi,

So if you are having problems accessing data with a parametric data request here are a few solutions and the reason you are having problems:

The reason: Excel Services requires read AND write privileges to the excel file you are trying to access with a parametric data access request, like the example below:
http://<ServerName>/_vti_bin/ExcelRest.aspx/Docs/Documents/sampleWorkbook.xlsx/model/Ranges(‘Sheet1!A1|G5’)?$format=html

Possible solutions:
1. Creating a domain account to be used in the IIS SharePoint application as the anonymous account with anonymous access to your public site

As the title suggests create a new domain account that you are going to use instead of the out of the box anonymous account assigned to your public site. Then you will grant to the needed file read/write access from you SharePoint user interface. The other reason why you need a domain account is that excel services requires claims tokens to authenticate and authorize a user to access information. This procedure is not going to suit your needs IF you do not want to allow write access to your excel data or other security related issues that prohibit you from using this method.

Your steps: Go to your IIS 7 => Navigate to your web application => Go into the IIS area in your application and open the Authentication option:

Untitled

Next Select “anonymous”(this should be enabled if you have a public SharePoint site), select edit from the left options panel and change the user to your newly created domain user.

Untitled2

2. Option two is to go around the problem programmatically. Here is one example from the following link that might do the trick:

http://blog.mastykarz.nl/inconvenient-excel-rest-services-anonymous-users/

SharePoint Forms Based Authentication against Active Directory with password change

Hi,

In this post I am going to guide you through the steps necessary to setup a FBA against AD with the possibility to change your password. I will not write a step by step instructions how to do it BUT based on what I had to fight and solve I will post the best possible ways to do these steps to my knowledge:

1. The first step to do is to to configure your existing web application(or create a new one) to support claims authentication and to follow the steps to configure the AD support for the forms authentication.

Configure forms-based authentication for a claims-based web application in SharePoint 2013:
http://technet.microsoft.com/en-us/library/ee806890.aspx

Migrate from classic-mode to claims-based authentication in SharePoint 2013:
http://technet.microsoft.com/en-us/library/gg251985.aspx

Also for SQL Server Authentication if needed:

http://blogs.technet.com/b/ptsblog/archive/2013/09/20/configuring-sharepoint-2013-forms-based-authentication-with-sqlmembershipprovider.aspx

http://msdn.microsoft.com/en-us/library/gg252020(v=office.14).aspx

2. The second step is to create a custom sign in page to apply custom logic to the authentication phase like changing the password of a user:

A few examples how to do it:

https://www.nothingbutsharepoint.com/sites/devwiki/articles/pages/sharepoint-custom-sign-in-and-sign-out-page-.aspx

http://blogs.technet.com/b/speschka/archive/2010/07/22/writing-a-custom-forms-login-page-for-sharepoint-2010-part-2.aspx

http://tomaszrabinski.pl/wordpress/2011/06/23/sharepoint-2010-custom-login-page/

http://blogs.msdn.com/b/kaevans/archive/2010/07/09/creating-a-custom-login-page-for-sharepoint-2010.aspx

http://www.mssharepointtips.com/tip.asp?id=1093&page=2

3. The third step is to create the custom code to change the user password:

What you need to do:

An Active Directory user with delegated privileges to the OU or CN where the authenticated users reside. This user must have the privileges to reset and change passwords.

http://www.petri.co.il/delegate-permission-reset-ad-user-account-passwords.htm

http://support.microsoft.com/kb/296999

Make use of Secure Store Service in SP2010 to store the AD account and other information securely. Notice: When accessing the Secure Store Service from the sign in page the user that will be accessing the SSS is anonymous user. So what you need to do is to use SPSecurity.RunWithElevatedPrivileges delegate.

http://social.technet.microsoft.com/wiki/contents/articles/20110.sharepoint-retrieving-credentials-from-the-secure-store-application-using-c.aspx

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spsecurity.runwithelevatedprivileges.aspx

Implement the custom .NET code to change the password with impersonation so get access to the AD(notice that the user which runs the code is anonymous)

http://msdn.microsoft.com/en-us/library/w070t6ka%28v=vs.110%29.aspx

http://www.codeproject.com/Articles/18102/Howto-Almost-Everything-In-Active-Directory-via-C#1

http://msdn.microsoft.com/en-us/library/system.directoryservices.directoryentry(v=vs.110).aspx

NOTICE: I had problems using another set of .NET class and function to perform the change password trough code. Problems with authorization against AD:

http://msdn.microsoft.com/en-us/library/system.directoryservices.accountmanagement.authenticableprincipal.setpassword(v=vs.110).aspx

4. Bonus: How to get rid of the Mixed authentication selection page for internal users of the web application.

When you access a SharePoint application that has both Forms and Windows Authentication enabled for the application SharePoint will ask the users to select which authentication to use. This is not necessarily what you want internal users to see. Most probably the functionality required is so that the internal users logs in normally as if it is an intranet website.

The following code below is meant to be used for internal users who are not accessing the site through the forms sign in page. What you need to is to create a custom httpmodule and in the handler code below identify under which page you are and based on that to directly redirect the user to the front page of the website without asking users to choose which authentication method to use. Sample code(not the best but does the trick 🙂 ):

static void context_PreRequestHandlerExecute(object sender, EventArgs e)

        {

            HttpApplication httpApp = sender as HttpApplication;

            HttpContext context = httpApp.Context;

            string httpUrl = context.Request.Url.ToString().ToLower();

            var page = HttpContext.Current.CurrentHandler as Page;

            string previousPageUrl = context.Cache[CacheKey_LoginStatus] as String;

            String intranetURL = System.Configuration.ConfigurationManager.AppSettings[“authentication page in sharepoint app setting value, this is sharepoint specific sample(modify for your environment): http://localhost:46752/_windows/default.aspx?ReturnUrl=/_layouts/Authenticate.aspx?Source=/_windows/default.aspx&amp;Source=/_windows/default.aspx “%5D ?? null;

            Uri httpUrlURI = new Uri(httpUrl);

            String localhostCalculated = httpUrlURI.AbsoluteUri.Replace(httpUrlURI.PathAndQuery, String.Empty);

            try

            {

                if (context.Request != null && String.IsNullOrEmpty(intranetURL) == false)

                {

                    if (httpUrl.Contains(“/_layouts/closeconnection.aspx?loginasanotheruser=true”))

                    {

                        context.Response.Cookies.Add(new HttpCookie(CacheKey_LoginStatus, “true”));

                    }

                    if (httpUrl.Contains(“/_layouts/signout.aspx”))

                    {

                        context.Response.Cookies.Add(new HttpCookie(CacheKey_LoginStatus, “true”));

                    }

                    bool isSignOut = false;

                    Boolean.TryParse(context.Response.Cookies[CacheKey_LoginStatus].Value, out isSignOut);

                    if (isSignOut)

                    {

                        context.Response.Cookies.Remove(CacheKey_LoginStatus);

                        context.Response.Redirect(ConfigurationManager.AppSettings[“redirect page to somewhere else than the application app settings value this can be any page you want”]);

                    }

                    else if (httpUrl.Contains(localhostCalculated + “/_login/default.aspx”))

                    {

                        context.Response.Redirect(intranetURL);

                    }

                }

            }

            catch (Exception Ex)

            {

            }

            if (page == null) return;

            page.PreInit += page_PreInit;

        }

OR you could do something like the following link where you do a IP based functionality:

http://spautomaticsignin.codeplex.com/

Possible problem areas – Good to know:

Office documents:

Authentication requests when you open Office documents:
http://support.microsoft.com/kb/2019105
How documents are opened from a Web site in Office 2003:
http://support.microsoft.com/kb/838028

For Juniper VPNs:

[SSL VPN] Known Issues and limitations when accessing Microsoft SharePoint 2003 / 2007 / 2010 resources via the Web Rewrite Access mechanism:
http://kb.juniper.net/InfoCenter/index?page=content&id=KB11501

[SSL VPN] Supported features and functionality of SharePoint 2010 when accessed via Secure Access SSL VPN’s Web/Rewrite access method:
http://kb.juniper.net/InfoCenter/index?page=content&id=KB20085

Good to know!? C# 5.0 Key Features Reference – Part 2

Hi,

This are copy notes from the main key-points found in the MS 70-483 prep book. This might be useful to someone. A checklist of things in C#.

Also check out the exam link and the actual book:

http://www.microsoft.com/learning/en-us/exam-70-483.aspx

Exam Ref 70-483: Programming in C#

Implement multithreading and asynchronous processing
Using multiple threads can improve responsiveness and enables you to make use of multiple processors.
The Thread class can be used if you want to create your own threads explicitly. Otherwise, you can use the ThreadPool to queue work and let the runtime handle things.
A Task object encapsulates a job that needs to be executed. Tasks are the recommended way to create multithreaded code.
The Parallel class can be used to run code in parallel.
PLINQ is an extension to LINQ to run queries in parallel.
The new async and await operators can be used to write asynchronous code more easily.
Concurrent collections can be used to safely work with data in a multithreaded (concurrent access) environment.
Manage multithreading
When accessing shared data in a multithreaded environment, you need to synchronize
access to avoid errors or corrupted data.
 Use the lock statement on a private object to synchronize access to a piece of code.
 You can use the Interlocked class to execute simple atomic operations.
 You can cancel tasks by using the CancellationTokenSource class with a
CancellationToken.
Implement program flow
 Boolean expressions can use several operators: ==, !=, <, >, <=, >=, !. Those operators
can be combined together by using AND (&&), OR (||) and XOR (^).
 You can use the if-else statement to execute code depending on a specific condition.
 The switch statement can be used when matching a value against a couple of options.
56 Chapter 1 Manage program flow
The for loop can be used when iterating over a collection where you know the number of iterations in advance.
A while loop can be used to execute some code while a condition is true; do-while should be used when the code should be executed at least once.
foreach can be used to iterate over collections.
Jump statements such as break, goto, and continue can be used to transfer control to another line of the program.
Create and implement events and callbacks method
 Delegates can be instantiated, passed around, and invoked.
 Lambda expressions, also known as anonymous methods, use the => operator and
form a compact way of creating inline methods.
 Events are a layer of syntactic sugar on top of delegates to easily implement the
publish-subscribe pattern.
 Events can be raised only from the declaring class. Users of events can only remove
and add methods the invocation list.
 You can customize events by adding a custom event accessor and by directly using the
underlying delegate type.
Implement exception handling
 In the .NET Framework, you should use exceptions to report errors instead of error
codes.
 Exceptions are objects that contain data about the reason for the exception.
 You can use a try block with one or more catch blocks to handle different types of
exceptions.
 You can use a finally block to specify code that should always run after, whether or not
an exception occurred.
 You can use the throw keyword to raise an exception.
 You can define your own custom exceptions when you are sure that users of your code
will handle it in a different way. Otherwise, you should use the standard .NET Framework
exceptions.
Create types
 Types in C# can be a value or a reference type.
 Generic types use a type parameter to make the code more flexible.
 Constructors, methods, properties, fields, and indexer properties can be used to create
a type.
 Optional and named parameters can be used when creating and calling methods.
 Overloading methods enable a method to accept different parameters.
 Extension methods can be used to add new functionality to an existing type.
 Overriding enables you to redefine functionality from a base class in a derived class.
Consume types
 Boxing occurs when a value type is treated as a reference type.
When converting between types, you can have an implicit or an explicit conversion.
An explicit conversion is called casting and requires special syntax.
You can create your own implicit and explicit user-defined conversions.
The .NET Framework offers several helper methods for converting types.
The dynamic keyword can be used to ease the static typing of C# and to improve
interoperability with other languages.
Enforce encapsulation
Encapsulation is important in object-oriented software. It hides internal details and
improves the usability of a type.
Data can be encapsulated with a property.
Properties can have both a get and a set accessor that can run additional code, commonly
known as getters and setters.
Types and type elements can have access modifiers to restrict accessibility.
The access modifiers are public, internal, protected, protected, internal, and private.
Explicit interface implementation can be used to hide information or to implement
interfaces with duplicate member signatures.
Create and implement a class hierarchy
Inheritance is the process in which a class is derived from another class or from an interface.
An interface specifies the public elements that a type must implement.
A class can implement multiple interfaces.
A base class can mark methods as virtual; a derived class can then override those methods to add or replace behavior.
A class can be marked as abstract so it can’t be instantiated and can function only as a base class.
A class can be marked as sealed so it can’t be inherited.
The .NET Framework offers default interfaces such as IComparable, IEnumerable, IDisposable and IUnknown.
Find, execute, and create types at runtime by using reflection
A C# assembly stores both code and metadata.
Attributes are a type of metadata that can be applied in code and queried at runtime.
Reflection is the process of inspecting the metadata of a C# application.
Through reflection you can create types, call methods, read properties, and so forth.
The CodeDOM can be used to create a compilation unit at runtime. It can be compiled or converted to a source file.
Expression trees describe a piece of code. They can be translated to something else (for example, SQL) or they can be compiled and executed.
Manage the object life cycle
 Memory in C# consists of both the stack and the heap.
 The heap is managed by the garbage collector.
 The garbage collector frees any memory that is not referenced any more.
 A finalizer is a special piece of code that’s run by the garbage collector when it removes
an object.
 IDisposable can be implemented to free any unmanaged resources in a deterministic
way.
 Objects implementing IDisposable can be used with a using statement to make sure
they are always freed.
 A WeakReference can be used to maintain a reference to items that can be garbage
collected when necessary.
Manipulate strings
A string is an immutable reference type.
When doing a lot of string manipulations, you should use a StringBuilder.
The String class offers a lot of methods for dealing with strings like IndexOf, LastIndexOf, StartsWith, EndsWith, and Substring.
Strings can be enumerated as a collection of characters.
Formatting is the process of displaying an object as a string.
You can use format strings to change how an object is converted to a string.
You can implement formatting for your own types.
Validate application input
 Validating application input is important to protect your application against both
mistakes and attacks.
 Data integrity should be managed both by your application and your data store.
 The Parse, TryParse, and Convert functions can be used to convert between types.
 Regular expressions, or regex, can be used to match input against a specified pattern
or replace specified characters with other values.
 When receiving JSON and XML files, it’s important to validate them using the built-in
types, such as with JavaScriptSerializer and XML Schemas.
Perform symmetric and asymmetric
encryption
 An asymmetric algorithm uses a public and private key that are mathematically linked.
 Hashing is the process of converting a large amount of data to a smaller hash code.
 Digital certificates can be used to verify the authenticity of an author.
 CAS are used to restrict the resources and operations an application can access and
execute.
 System.Security.SecureString can be used to keep sensitive string data in memory.
Manage assemblies
An assembly is a compiled unit of code that contains metadata.
An assembly can be strongly signed to make sure that no one can tamper with the content.
Signed assemblies can be put in the GAC.
An assembly can be versioned, and applications will use the assembly version they were developed with. It’s possible to use configuration files to change these bindings.
A WinMD assembly is a special type of assembly that is used by WinRT to map non-native languages to the native WinRT components.
Debug an application
Visual Studio build configurations can be used to configure the compiler.
 A debug build outputs a nonoptimized version of the code that contains extra instructions
to help debugging.
 A release build outputs optimized code that can be deployed to a production
environment.
 Compiler directives can be used to give extra instructions to the compiler. You can use
them, for example, to include code only in certain build configurations or to suppress
certain warnings.
 A program database (PDB) file contains extra information that is required when debugging
an application.
Implement diagnostics in an application
 Logging and tracing are important to monitor an application that is in production and
should be implemented right from the start.
 You can use the Debug and TraceSource classes to log and trace messages. By configuring
different listeners, you can configure your application to know which data to send
where.
 When you are experiencing performance problems, you can profile your application to
find the root cause and fix it.
 Performance counters can be used to constantly monitor the health of your applications.
Perform I/O operations
 You can work with drives by using Drive and DriveInfo.
 For folders, you can use Directory and DirectoryInfo.
 File and FileInfo offer methods to work with files.
 The static Path class can help you in creating and parsing file paths.
 Streams are an abstract way of working with a series of bytes.
 There are many Stream implementations for dealing with files, network operations,
and any other types of I/O.
 Remember that the file system can be accessed and changed by multiple users at the
same time. You need to keep this in mind when creating reliable applications.
 When performing network requests, you can use the WebRequest and WebResponse
classes from the System.Net namespace.
 Asynchronous I/O can help you create a better user experience and a more scalable
application.
Consume data
 ADO.NET uses a provider model that enables you to connect to different types of
databases.
 You use a DbConnection object to create a connection to a database.
 You can execute queries that create, update, read, and delete (CRUD) data from a
database.
 When creating queries it’s important to use parameterized queries so you avoid SQL
injection.
Objective 4.3: Query and manipulate data and objects by using LINQ CHAPTER 4 291
You can consume a web service from your application by creating a proxy for it.
You can work with XML by using the XmlReader, XmlWriter, XPathNavigator, and XmlDocument classes.
Query and manipulate data and objects by using LINQ
 LINQ, which stands for Language Integrated Query, is a uniform way of writing queries
against multiple data sources.
 Important language features when working with LINQ queries are implicit typing, object
initialization syntax, lambdas, extension methods, and anonymous types.
 You can use LINQ with a method-based syntax and the query syntax.
 LINQ queries are deferred-execution, which means that the query executes when it is
first iterated.
 You can use LINQ to XML to query, create, and update XML.
Serialize and deserialize data
 Serialization is the process of transforming an object to a flat file or a series of bytes.
 Deserialization takes a series of bytes or a flat file and transforms it into an object.
 XML serialization can be done by using the XmlSerializer.
 You can use special attributes to configure the XmlSerializer.
 Binary serialization can be done by using the BinaryFormatter class.
 WCF uses another type of serialization that is performed by the DataContractSerializer.
 JSON is a compact text format that can be created by using the DataContractJsonSerializer.
Store data in and retrieve data from collections
 The .NET Framework offers both generic and nongeneric collections. When possible,
you should use the generic version.
 Array is the most basic type to store a number of items. It has a fixed size.
 List is a collection that can grow when needed. It’s the most-used collection.
 Dictionary stores and accesses items using key/value pairs.
 HashSet stores unique items and offers set operations that can be used on them.
 A Queue is a first-in, first-out (FIFO) collection.
 A Stack is a first-in, last-out (FILO) collection.
 You can create a custom collection by inheriting from a collection class or inheriting
from one of the collection interfaces.

Good to know!? C# 5.0 Key Features Reference – Part 1

Hi here is my reference links to C# 5.0. hope it helps someone!! 🙂

Manage program flow – Multithreading, asynchronous processing, events and callbacks, exception handling

Asynchronous Programming with Async and Await (C# and Visual Basic) http://msdn.microsoft.com/en-us/library/vstudio/hh191443.aspx
C# Operators http://msdn.microsoft.com/en-us/library/6a71f45d.aspx
CancellationTokenSource Class http://msdn.microsoft.com/en-us/library/system.threading.cancellationtokensource.aspx
Covariance and contravariance http://blogs.msdn.com/b/ericlippert/archive/tags/covariance+and+contravariance/
Delegate.GetInvocationList Method http://msdn.microsoft.com/en-us/library/system.delegate.getinvocationlist.aspx
Exceptions and Exception Handling (C# Programming Guide) http://msdn.microsoft.com/en-us/library/ms173160.aspx
Flow Control http://msdn.microsoft.com/en-us/library/hh147286%28v=vs.88%29.aspx
Interlocked Methods http://msdn.microsoft.com/en-us/library/System.Threading.Interlocked_methods.aspx
Jump Statements http://msdn.microsoft.com/en-us/library/d96yfwee.aspx
Lambda Expressions (C# Programming Guide) http://msdn.microsoft.com/en-us/library/vstudio/bb397687.aspx
lock Statement (C# Reference) http://msdn.microsoft.com/en-us/library/c5kehkcz.aspx
Parallel LINQ (PLINQ) http://msdn.microsoft.com/en-us/library/dd460688.aspx
System.Collections.Concurrent Namespace http://msdn.microsoft.com/en-us/library/system.collections.concurrent.aspx
System.Threading.Tasks Namespace http://msdn.microsoft.com/en-us/library/system.threading.tasks.aspx
Thread Class http://msdn.microsoft.com/en-us/library/system.threading.thread.aspx
ThreadLocal<T> Class http://msdn.microsoft.com/en-us/library/dd642243.aspx
ThreadPool Class http://msdn.microsoft.com/en-us/library/system.threading.threadpool.aspx
Using Delegates (C# Programming Guide) http://msdn.microsoft.com/en-us/library/ms173171%28v=vs.90%29.aspx
Volatile Class http://msdn.microsoft.com/en-us/library/system.threading.volatile.aspx

Types – Create types, Consume types, encapsulation, class hierarchy, reflection, string/text manipulation

Abstract and Sealed Classes and Class Members (C# Programming Guide) http://msdn.microsoft.com/en-us/library/ms173150.aspx
Access Modifiers (C# Reference) http://msdn.microsoft.com/en-us/library/wxh6fsc7.aspx
Anonymous Methods (C# Programming Guide) http://msdn.microsoft.com/en-us/library/0yw3tz5k.aspx
Attributes (C# and Visual Basic) http://msdn.microsoft.com/en-us/library/z0w1kczw.aspx
Basic String Operations http://msdn.microsoft.com/en-us/library/a292he7t.aspx
Best Practices for Using Strings in the .NET Framework
http://msdn.microsoft.com/en-us/library/dd465121.aspx
C# – Understanding The NET Garbage Collector http://www.csharphelp.com/2010/02/c-understandin-the-garbage-collector/
Constructor Design http://msdn.microsoft.com/en-us/library/vstudio/ms229060(v=vs.100).aspx
CultureInfo Class http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo.aspx
Enumeration Types (C# Programming Guide) http://msdn.microsoft.com/en-us/library/vstudio/cc138362.aspx
ExceptionDispatchInfo Class http://msdn.microsoft.com/en-us/library/system.runtime.exceptionservices.exceptiondispatchinfo.aspx
Expression Trees (C# and Visual Basic) http://msdn.microsoft.com/en-us/library/bb397951.aspx
Extension Methods (C# Programming Guide) http://msdn.microsoft.com/en-us/library/vstudio/bb383977.aspx
Finalize Methods and Destructors http://msdn.microsoft.com/en-us/library/0s71x931.aspx
Generics (C# Programming Guide) http://msdn.microsoft.com/en-us/library/512aeb7t.aspx
IDisposable Interface http://msdn.microsoft.com/en-us/library/system.idisposable.aspx
Immutability in C# Part One: Kinds of Immutability http://blogs.msdn.com/b/ericlippert/archive/2007/11/13/immutability-in-c-part-one-kinds-of-immutability.aspx
Interfaces (C# Programming Guide) http://msdn.microsoft.com/en-us/library/vstudio/ms173156.aspx
IUnknown interface http://msdn.microsoft.com/en-us/library/windows/desktop/ms680509%28v=vs.85%29.aspx
Managed Extensibility Framework (MEF)
http://msdn.microsoft.com/en-us/library/dd460648.aspx
Operator Keywords (C# Reference) http://msdn.microsoft.com/en-us/library/bewds7kc%28v=vs.90%29.aspx
Properties (C# Programming Guide) http://msdn.microsoft.com/en-us/library/x9fsa0sw.aspx
The Big Ball of Mud and Other Architectural Disasters http://www.codinghorror.com/blog/2007/11/the-big-ball-of-mud-and-other-architectural-disasters.html
Types (C# Programming Guide) http://msdn.microsoft.com/en-us/library/vstudio/ms173104.aspx
unsafe (C# Reference) http://msdn.microsoft.com/en-us/library/chfa2zb8.aspx
Using Conversion Operators (C# Programming Guide) http://msdn.microsoft.com/en-us/library/85w54y0a.aspx
using Statement http://msdn.microsoft.com/en-us/library/yh598w02.aspx
Using the CodeDOM http://msdn.microsoft.com/en-us/library/y2k85ax6.aspx
Using the StringBuilder Class http://msdn.microsoft.com/en-us/library/2839d5h5.aspx
Using Type dynamic (C# Programming Guide) http://msdn.microsoft.com/en-us/library/dd264736.aspx
Walkthrough: Creating and Using Dynamic Objects (C# and Visual Basic) http://msdn.microsoft.com/en-us/library/ee461504.aspx
WeakReference Class http://msdn.microsoft.com/en-us/library/system.weakreference.aspx
virtual (C# Reference) http://msdn.microsoft.com/en-us/library/9fkccyh4.aspx

Application management and development and security – Validation, encryption, assemblies, debugging, diagnostics

.NET Framework Cryptography Model http://msdn.microsoft.com/en-us/library/0ss79b2x.aspx
.NET Framework Cryptography Model http://msdn.microsoft.com/en-us/library/0ss79b2x.aspx
.NET Framework Regular Expressions http://msdn.microsoft.com/en-us/library/hs600312.aspx
Analyzing Application Performance by Using Profiling Tools http://msdn.microsoft.com/en-us/library/z9z62c29.aspx
Authenticode http://technet.microsoft.com/en-us/library/cc750035.aspx
Beginners Guide to Performance Profiling http://msdn.microsoft.com/en-us/library/ms182372.aspx
C# Preprocessor Directives http://msdn.microsoft.com/en-us/library/ed8yd1ha.aspx
Code Access Security http://msdn.microsoft.com/en-us/library/930b76w0%28v=vs.90%29.aspx
Conditional (C# Programming Guide) http://msdn.microsoft.com/en-us/library/4xssyw96%28v=vs.90%29.aspx
Debug Class http://msdn.microsoft.com/en-us/library/system.diagnostics.debug.aspx
Debugger Roadmap http://msdn.microsoft.com/en-us/library/k0k771bt.aspx
Debugging, Tracing, and Profiling http://msdn.microsoft.com/en-us/library/7fe0dd2y.aspx
EventLog Class http://msdn.microsoft.com/en-us/library/system.diagnostics.eventlog.aspx
Gacutil.exe (Global Assembly Cache Tool) http://msdn.microsoft.com/en-us/library/ex0ss12c.aspx
JavaScriptSerializer Class http://msdn.microsoft.com/en-us/library/system.web.script.serialization.javascriptserializer.aspx
Makecert.exe (Certificate Creation Tool) http://msdn.microsoft.com/en-us/library/bfsktky3%28v=vs.110%29.aspx
Object.GetHashCode Method http://msdn.microsoft.com/en-us/library/system.object.gethashcode%28v=vs.110%29.aspx
Parsing Strings http://msdn.microsoft.com/en-us/library/b4w53z0y.aspx
PDB Files (C# and Visual Basic) http://msdn.microsoft.com/en-us/library/ms241903%28v=vs.90%29.aspx
PerformanceCounter Class http://msdn.microsoft.com/en-us/library/system.diagnostics.performancecounter.aspx
Regular Expression Language – Quick Reference http://msdn.microsoft.com/en-us/library/az24scfc.aspx
Runtime Profiling http://msdn.microsoft.com/en-us/library/w4bz2147.aspx
SecureString Class http://msdn.microsoft.com/en-us/library/system.security.securestring.aspx
Sn.exe (Strong Name Tool) http://msdn.microsoft.com/en-us/library/k5b5tt23.aspx
Step 1: Examining the Configuration Files http://msdn.microsoft.com/en-us/library/8f6988ab.aspx
Stopwatch Class http://msdn.microsoft.com/en-us/library/system.diagnostics.stopwatch.aspx
Symbol Server and Symbol Stores http://msdn.microsoft.com/en-us/library/ms680693%28VS.85%29.aspx
System.ComponentModel.DataAnnotations Namespace http://msdn.microsoft.com/en-us/library/system.componentmodel.dataannotations.aspx
System.Diagnostics Namespace http://msdn.microsoft.com/en-us/library/system.diagnostics.aspx
TraceSource Class http://msdn.microsoft.com/en-us/library/system.diagnostics.tracesource.aspx
Using DebuggerDisplay Attribute http://msdn.microsoft.com/en-us/library/x810d419.aspx
XML Schema Definition Tool (Xsd.exe) http://msdn.microsoft.com/en-us/library/x6c1kb0s.aspx

Data access and manipulation – I/O operations, consume data, LINQ data manipulation, serialization, collections

101 LINQ Samples http://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b
ADO.NET Architecture http://msdn.microsoft.com/en-us/library/27y4ybxw.aspx
ADO.NET DataSets http://msdn.microsoft.com/en-us/library/zb0sdh0b.aspx
Arrays Tutorial http://msdn.microsoft.com/en-us/library/aa288453%28v=vs.71%29.aspx
BinaryFormatter Class http://msdn.microsoft.com/en-us/library/system.runtime.serialization.formatters.binary.binaryformatter.aspx
Collections (C# and Visual Basic) http://msdn.microsoft.com/en-us/library/ybcx56wz.aspx
Collections and Data Structures
http://msdn.microsoft.com/en-us/library/7y3x785f.aspx
ConfigurationManager Class http://msdn.microsoft.com/en-us/library/system.configuration.configurationmanager.aspx
DataContractSerializer Class http://msdn.microsoft.com/en-us/library/system.runtime.serialization.datacontractserializer.aspx
DataContractSerializer Sample http://msdn.microsoft.com/en-us/library/ms752244.aspx
DbConnection, DbCommand and DbException http://msdn.microsoft.com/en-us/library/9hy8csk1.aspx
DbConnectionStringBuilder Class http://msdn.microsoft.com/en-us/library/system.data.common.dbconnectionstringbuilder.aspx
Directory Class http://msdn.microsoft.com/en-us/library/system.io.directory.aspx
DirectorySecurity Class http://msdn.microsoft.com/en-us/library/system.security.accesscontrol.directorysecurity.aspx
DriveInfo Class http://msdn.microsoft.com/en-us/library/system.io.driveinfo.aspx
Encoding Class http://msdn.microsoft.com/en-us/library/system.text.encoding.aspx
Entity Framework http://msdn.microsoft.com/en-us/data/ef.aspx
Examples of XML Serialization http://msdn.microsoft.com/en-us/library/58a18dwa.aspx
File Class http://msdn.microsoft.com/en-us/library/system.io.file.aspx
FileInfo Class http://msdn.microsoft.com/en-us/library/system.io.fileinfo.aspx
FileStream Class http://msdn.microsoft.com/en-us/library/system.io.filestream.aspx
Getting Started with LINQ in C# http://msdn.microsoft.com/en-us/library/bb397933.aspx
How to: Extend the Async Walkthrough by Using Task.WhenAll (C# and Visual Basic) http://msdn.microsoft.com/en-us/library/vstudio/hh556530.aspx
How to: Parse XML with XmlReader http://msdn.microsoft.com/en-us/library/cc189056%28v=vs.95%29.aspx
HttpClient Class http://msdn.microsoft.com/en-us/library/system.net.http.httpclient.aspx
Implementing an Implicit Transaction using Transaction Scope http://msdn.microsoft.com/en-us/library/ee818746.aspx
MemoryStream Class http://msdn.microsoft.com/en-us/library/system.io.memorystream.aspx
NonSerializedAttribute Class http://msdn.microsoft.com/en-us/library/system.nonserializedattribute.aspx
Parameters and Execution Plan Reuse http://msdn.microsoft.com/en-us/library/ms175580.aspx
Path Class http://msdn.microsoft.com/en-us/library/system.io.path.aspx
Retrieving and Modifying Data in ADO.NET http://msdn.microsoft.com/en-us/library/ms254937.aspx
Serialization (C# and Visual Basic) http://msdn.microsoft.com/en-us/library/vstudio/ms233843.aspx
SQL Injection http://msdn.microsoft.com/en-us/library/ms161953%28v=sql.105%29.aspx
SqlCommand Class http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx
SqlConnection Class http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.aspx
SqlDataReader Class http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.aspx
StreamReader Class http://msdn.microsoft.com/en-us/library/system.io.streamreader.aspx
StreamWriter Class http://msdn.microsoft.com/en-us/library/system.io.streamwriter.aspx
System.IO.Compression Namespace http://msdn.microsoft.com/en-us/library/system.io.compression.aspx
System.Net Namespace http://msdn.microsoft.com/en-us/library/system.net.aspx
Using Data Contracts http://msdn.microsoft.com/en-us/library/ms733127.aspx
Using the DbContext API http://msdn.microsoft.com/en-us/data/gg192989%28v=msdn.10%29.aspx
var (C# Reference) http://msdn.microsoft.com/en-us/library/bb383973.aspx
Web.config Transformation Syntax for Web Project Deployment Using Visual Studio http://msdn.microsoft.com/en-us/library/dd465326.aspx
WebRequest Class http://msdn.microsoft.com/en-us/library/system.net.webrequest.aspx
WebResponse Class http://msdn.microsoft.com/en-us/library/system.net.webresponse.aspx
What Is Windows Communication Foundation http://msdn.microsoft.com/en-us/library/ms731082.aspx
XML Standards Reference http://msdn.microsoft.com/en-us/library/ms256177.aspx
XmlAttributes.XmlArray Property http://msdn.microsoft.com/en-us/library/system.xml.serialization.xmlattributes.xmlarray.aspx
XmlAttributes.XmlArrayItems Property http://msdn.microsoft.com/en-us/library/system.xml.serialization.xmlattributes.xmlarrayitems.aspx
XmlAttributes.XmlAttribute Property http://msdn.microsoft.com/en-us/library/system.xml.serialization.xmlattributes.xmlattribute.aspx
XmlAttributes.XmlElements Property http://msdn.microsoft.com/en-us/library/system.xml.serialization.xmlattributes.xmlelements.aspx
XmlAttributes.XmlIgnore Property http://msdn.microsoft.com/en-us/library/system.xml.serialization.xmlattributes.xmlignore.aspx
XmlDocument http://msdn.microsoft.com/en-us/library/system.xml.xmldocument.aspx
XmlReader http://msdn.microsoft.com/en-us/library/system.xml.xmlreader.aspx
XmlSerializer Class http://msdn.microsoft.com/en-us/library/system.xml.serialization.xmlserializer.aspx
XmlWriter http://msdn.microsoft.com/en-us/library/system.xml.xmlwriter.aspx
XPathNavigator http://msdn.microsoft.com/en-us/library/system.xml.xpath.xpathnavigator.aspx

Other important links:

ENTITY FRAMEWORK http://msdn.microsoft.com/en-us/data/ef.aspx
Visual Studio Plugins http://www.nuget.org/
Database ConnectionStrings http://www.connectionstrings.com/
Json.NET http://json.codeplex.com/
LINQPad http://www.linqpad.net/