using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Diagnostics;

using System.Data.SqlClient;

using System.Data.Metadata.Edm;

using System.Reflection;

using System.Data.EntityClient;

using System.Data.Linq;

using ServiceStack.DataAnnotations;

namespace SqlMapper

{

class Post

{

public int Id { get; set; }

public string Text { get; set; }

public DateTime CreationDate { get; set; }

public DateTime LastChangeDate { get; set; }

public int? Counter1 { get; set; }

public int? Counter2 { get; set; }

public int? Counter3 { get; set; }

public int? Counter4 { get; set; }

public int? Counter5 { get; set; }

public int? Counter6 { get; set; }

public int? Counter7 { get; set; }

public int? Counter8 { get; set; }

public int? Counter9 { get; set; }

}

class Program

{

public static readonly string connectionString = "Data Source=IO\\SQLEXPRESS;Initial Catalog=tempdb;Integrated Security=True";

//public static readonly string connectionString = "Data Source=.;Initial Catalog=tempdb;Integrated Security=True";

public static SqlConnection GetOpenConnection()

{

var connection = new SqlConnection(connectionString);

connection.Open();

return connection;

}

static void RunPerformanceTests()

{

var test = new PerformanceTests();

Console.WriteLine("Running 500 itrations that load up a post entity");

test.Run(500);

}

static void Main(string[] args)

{

#if DEBUG

RunTests();

#else

EnsureDBSetup();

RunPerformanceTests();

#endif

Console.ReadKey();

}

private static void EnsureDBSetup()

{

using (var cnn = GetOpenConnection())

{

var cmd = cnn.CreateCommand();

cmd.CommandText = @"

if (OBJECT_ID('Posts') is null)

begin

create table Posts

(

Id int identity primary key,

[Text] varchar(max) not null,

CreationDate datetime not null,

LastChangeDate datetime not null,

Counter1 int,

Counter2 int,

Counter3 int,

Counter4 int,

Counter5 int,

Counter6 int,

Counter7 int,

Counter8 int,

Counter9 int

)

set nocount on

declare @i int

declare @c int

declare @id int

set @i = 0

while @i < 5000

begin

insert Posts ([Text],CreationDate, LastChangeDate) values (replicate('x', 2000), GETDATE(), GETDATE())

set @id = @@IDENTITY

set @i = @i + 1

end

end

";

cmd.Connection = cnn;

cmd.ExecuteNonQuery();

}

}

private static void RunTests()

{

var tester = new Tests();

foreach (var method in typeof(Tests).GetMethods(BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly))

{

Console.Write("Running " + method.Name);

method.Invoke(tester, null);

Console.WriteLine(" - OK!");

}

}

}

}