using System;

using Dapper;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.Linq.Mapping;

using System.Data.Linq;

using System.Data.SqlClient;

using System.Diagnostics;

​

public class Program

{

    public static void Main()

    {

        //User user = new User();

        string connString = "Server=tcp:dcq7rctfid.database.windows.net,1433;Database=ircbot;User ID=id;Password=pass;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;";

        var sw = new Stopwatch();

        long test1;

        using (var db = new ircbotDataContext(connString))

        {

            sw.Start();

            var query = (

                from u in db.Users

                where u.ID > 10

                orderby u.ID descending

                select u).Take(50);

            sw.Stop();

            Console.WriteLine("L2S: " + sw.ElapsedTicks);

        }

​

        sw.Reset();

        using (var conn = new SqlConnection(connString))

        {

            sw.Start();

            var query = conn.Query("SELECT * FROM [users] WHERE ID > 10 ORDER BY ID DESC").Take(50);

            sw.Stop();

            Console.WriteLine("Dapper: {0}", sw.ElapsedTicks);

        }

    //Console.WriteLine("Hello World");

    }

​

    public class ircbotDataContext : DataContext

    {

        public ircbotDataContext(string cs): base (cs)

        {

        }

​

        public ircbotDataContext(SqlConnection con): base (con)

        {

        }

​

        public Table<User> Users;

    }

​

    [Table(Name = "users")]

    public class User

    {

        [Column(Name = "ID", IsPrimaryKey = true)]

        public int ID

        {

            get;

            set;

        }

​

        [Column(Name = "Nick", CanBeNull = false)]

        public string Nick

        {

            get;

            set;

        }

​

        [Column(Name = "Ident", CanBeNull = false)]

        public string Ident

        {

            get;

            set;

        }

​

        [Column(Name = "Mode", CanBeNull = true)]

        public string Mode

        {

            get;

            set;

        }

​

        [Column(Name = "LastHeard", CanBeNull = false)]

        public DateTime LastHeard

        {

            get;

            set;

        }

​

        [Column(Name = "Channel", CanBeNull = false)]

        public string Channel

        {

            get;

            set;

        }

​

        [Column(Name = "Points", CanBeNull = true)]

        public long Points

        {

            get;

            set;

        }

​

        [Column(Name = "FirstSeen", CanBeNull = false)]

        public DateTime FirstSeen

        {

            get;

            set;

        }

​

        [Column(Name = "Location", CanBeNull = true)]

        public string Location

        {

            get;

            set;

        }

​

        [Column(Name = "Debt", CanBeNull = true)]

        public int Debt

        {

            get;

            set;

        }

​

        [Column(Name = "LastState", CanBeNull = true)]

        public string LastState

        {

            get;

            set;

        }

​

        [Column(Name = "LastMessage", CanBeNull = true)]

        public string LastMessage

        {

            get;

            set;

        }

​

        [Column(Name = "Greeting", CanBeNull = true)]

        public string Greeting

        {

            get;

            set;

        }

​

        [Column(Name = "Grounded", CanBeNull = true)]

        public bool Grounded

        {

            get;

            set;

        }

​

        [Column(Name = "IsBotAdmin", CanBeNull = true)]

        public bool IsBotAdmin

        {

            get;

            set;

        }

​

        [Column(Name = "UserProfile", CanBeNull = true)]

        public int UserProfile

        {

            get;

            set;

        }

​

        [Column(Name = "LinkingKey", CanBeNull = true)]

        public string LinkingKey

        {

            get;

            set;

        }

    }

}