taylonr

public class DataProfiler : IProfiler
{
    public DataProfiler()
    {
	Enabled = true;
    }

    public bool Enabled { get; set; }

    public void Update(PetaPocoSqlInfo info)

taylonr

public class DataProfiler : ISqlProfiler
{
    public DataProfiler()
    {
	Enabled = true;
    }

    public bool Enabled { get; set; }

    public void Update(PetaPocoSqlInfo info)

taylonr

[GlimpsePlugin]
public class PetaPocoGlimpsePlugin : IGlimpsePlugin
{
    public object GetData(HttpContextBase context)
    {
    	if (context.Items[DataProfiler.PetaKey] == null)
		return new List<object[]> { new[] { "Log" }, new[] { "No database requests   or database logging not switched on (Compilation debug='true' or ForceLogging='true' on
PetaPoco.DatabaseWithLogging)", "warn" } };

	var sqls = new List<object[]> {new[] {"#", "Time(ms)", "Sql", "Parameters"}};

taylonr

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

taylonr

public interface ISqlProfiler
{
	bool Enabled { get;}

	void Update(PetaPocoSqlInfo info);
}

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

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

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

        [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

// 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