taylonr

public interface ICar
{
    void ConnectBattery();
    void SendPowerToStarter();
    void AddFuelToCylinder(int cylinderNumber);
    void AddAirToCylinder(int cylinderNumber);
    void SendSparkToPlug(int plugNumber);
    void TurnCrankshaft();
}

taylonr

 public ActionResult Index()
        {
            var m = Database.Open().Media.FindByName("KitKat Killer");

            return View(new Media{Name = m.Name, Url = m.Url});
        }

 public class Media
    {
        public int Id { get; set; }

taylonr

use OmniAuth::Builder do
  provider :twitter, ENV['TWITTER_KEY'], ENV['TWITTER_SECRET']
  provider :facebook, ENV['FACEBOOK_KEY'], ENV['FACEBOOK_SECRET']
end

get '/auth/:provider/callback' do
  auth = request.env['omniauth.auth']

  user = User.where(:provider => auth["provider"], :uid => auth["uid"].to_i).first() ||
      User.create(:provider => auth["provider"], :uid => auth["uid"].to_i, :name => auth['info']['name'])

taylonr

// make sure to add autofac to the project

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Autofac;
using Autofac.Configuration;

namespace ValidationTest

taylonr

        [Test]
        public void Should_Add_User()
        {
            var user = new UserInput {Email = "autotest@example.com", FirstName = "automated", LastName = "user", Password = "abc"};

            using (var host = new InMemoryHost(new Configuration()))
            {
                var req = new InMemoryRequest
                              {
                                  Uri = new Uri("http://localhost/users"),

taylonr

var sql = new Sql().Append("declare @@result int")
    .Append("exec GetData @userId, @date", 
        new {userId = userId, @date = DateTime.Now})
    .Append("select @@result);

var ret = Database.ExecuteScalar<int>(sql);

taylonr

var returnCode = Database.ExecuteScalar<int>(
    "exec GetData @userId, @date", 
     new {userId = userId, @date = DateTime.Now});

taylonr

CREATE TYPE [dbo].[MyRecords] AS TABLE(
	[Id] [int] NOT NULL,
	[ModuleId] [int] NOT NULL,
	[Code] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
	PRIMARY KEY CLUSTERED 
(
	[Id] ASC,
	[ModuleId] ASC,
	[Code] ASC
)WITH (IGNORE_DUP_KEY = OFF)

taylonr

public interface ISqlProfiler
{
	bool Enabled { get;}

	void Update(PetaPocoSqlInfo info);
}

taylonr

public class SqlInfo
{
	public double Time { get; set; }
	public string FormattedSql { get; set; }
	public string Sql { get; set; }
	public IDataParameterCollection Parameters { get; set; }
}