rally25rs

SELECT SUBSTRING(st.text, ( r.statement_start_offset / 2 ) + 1, 
              ( ( CASE WHEN r.statement_end_offset <= 0
                       THEN DATALENGTH(st.text) 
              ELSE r.statement_end_offset END - 
        r.statement_start_offset ) / 2 ) + 1) AS statement_text ,
		r.session_id,
		r.status,
		r.command,
		r.cpu_time,
		r.total_elapsed_time

rally25rs

/* ***
 * This sample is again from an ORM tool that I had been working on.
 *
 * This is simply an example of a "factory" pattern that I wrote a few years ago.
 * This factory is designed to return the same IDataBinder instance when the same
 * database connection string is passed in.
 * *** */

rally25rs

    using System.Web.Mvc;
    using Microsoft.VisualStudio.TestTools.UnitTesting;

    /// <summary>
    /// MSTest Asserts for unit testing MVC3 Controllers.
    /// </summary>
    public static class AssertMvc
    {
        public static T ResultIs<T>(object result)
            where T : ActionResult

rally25rs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Text;

namespace AnythingToCsv
{
    public static class EnumerableExtensions
    {

rally25rs

# .gitignore for .NET projects
 
# Standard VS.NET
obj
bin
*.csproj.user
*.suo
*.cache
Thumbs.db

rally25rs

/* ***
 * This is a method from an object-relation-mapping (ORM) tool that I had started to write.
 * I eventually stopped working on it, ad instead contributed time to the open source
 * SubSonic project instead.
 *
 * This method is an example of generating DynamicMethods to be used at runtime to check and
 * set some properties any an arbitrary type. This was used over straight reflection every time
 * because reflection can be fairly slow. The use of a DynamicMethod is much quicker.
 * *** */

rally25rs

window.fileStorage =
    save: (name, data) ->
        deferred = $.Deferred()

        fail = (error) =>
            deferred.reject(error)

        gotFileSystem = (fileSystem) =>
            fileSystem.root.getFile(name, { create: true, exclusive: false }, gotFileEntry, fail)

rally25rs

// By default, Json.Encode will turn an ExpandoObject into an array of items,
// because internally an ExpandoObject extends IEnumerable<KeyValuePair<string, object>>.
// You can turn it into a non-list JSON string by first wrapping it in a DynamicJsonObject.
[TestMethod]
public void JsonEncodeAnExpandoObjectByWrappingItInADynamicJsonObject()
{
    dynamic expando = new ExpandoObject();
    expando.Value = 10;
    expando.Product = "Apples";

rally25rs

using System;
using System.Collections.Generic;
using System.Linq.Expressions;
using System.Web.Mvc;

namespace Web.Extensions
{
    public static class HtmlHelperDisplayNameExtensions
    {
        /// <summary>

rally25rs

using System;
using System.Collections;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data.Entity;
using System.Linq;
using System.Linq.Expressions;

namespace Rally25rs.Gist.Data
{