TowardsDeath

var tags = from tag in data.Tag
           join articleTag in data.ArticleTag on tag.Id equals articleTag.TagId
           join articlesWithRole in
               (
                  from articleTag in data.ArticleTag
                  join tagRole in data.TagForRole on articleTag.TagId equals tagRole.TagId
                  select new
                  {
                      ArticleId = articleTag.ArticleId,
                      Role = tagRole.Role

TowardsDeath

var tags = from t in data.Tag
           where t.Title == tagTitle || t.Title == subTagTitle
           select t.Id;

var list = ( from articlesWithTags in
                 (
                      from articleTag in data.ArticleTag
                      where tags.Contains( articleTag.TagId )
                      select articleTag
                  )

TowardsDeath

SELECT 
	DISTINCT TOP 1 COUNT(*) AS [LPAV_]
FROM 
(
	SELECT 
		[LPLA_1].[Id]
	FROM 
		[Tag] [LPLA_1]
	WHERE 
		[LPLA_1].[Title] = 'title1'

TowardsDeath

using System;
using System.Linq;
using System.ServiceModel.Syndication;
using System.Web.Mvc;
using System.Xml;

namespace Web
{
    public class RssController : Controller
    {

TowardsDeath

$.ajax({
    type: 'POST',
    url: '/files/upload', 
    /* jQuery automatically processes and transforms Ajax data into a querystring.
     * It should not do that with our binary data. */
    processData: false,
    data: file,
    /* The 'upload' object and onprogress event are part of the new XmlHttpRequest (XHR) 2.
     * With jQuery v1.7.2 there's no direct way to access this event, 
     * so we need to manually access the core XmlHttpRequest object to attach an event handler. 

TowardsDeath

Keybase proof

I hereby claim:

• I am donormal on github.
• I am donormal (https://keybase.io/donormal) on keybase.
• I have a public key ASB4gwRND0EgPRZ1zSAK_KvFVtUkmLEx8BNe8ndK3MkSbQo

To claim this, I am signing this object: