Exemple #1
0
 public static Member Create(IDataReader reader)
 {
     var i = new Member();
     i.Id = reader.GetInt32(reader.GetOrdinal("Id"));
     i.FirstName = reader.GetString(reader.GetOrdinal("FirstName"));
     i.LastName = reader.GetString(reader.GetOrdinal("LastName"));
     return i;
 }
Exemple #2
0
        public static void Main(string[] args)
        {
            var stopwatch = Stopwatch.StartNew();
            using (var db = new Database("Island"))
            {
                Console.WriteLine("Using the call Execute(string sql, params IParameter[] parameters)");
                db.Execute("insert into Member (FirstName, LastName) values (@firstName, @lastName)",
                    new Parameter("@firstName", SqlDbType.VarChar, "John", 50),
                    new Parameter("@lastName", SqlDbType.VarChar, "Smith", 50));

                Console.WriteLine();
                Console.WriteLine("Using the call Query<T>(string sql, params IParameter[] parameters)");
                var list1 = db.Query<Member>("select Id, FirstName, LastName from Member where Id=@Id", new Parameter("@Id", SqlDbType.Int, 1));
                foreach (var item in list1)
                {
                    Console.WriteLine("[{0}] {1} {2}", item.Id, item.FirstName, item.LastName);
                }

                Console.WriteLine();
                Console.WriteLine("Using the call Query<T>(string sql, Func<IDataReader, T> factory, params IParameter[] parameters)");
                var list2 = db.Query<Member>(
                    "select Id, FirstName, LastName from Member where Id=@Id",
                    r => {
                        var i = new Member();
                        i.Id = r.GetInt32(r.GetOrdinal("Id"));
                        i.FirstName = r.GetString(r.GetOrdinal("FirstName"));
                        i.LastName = r.GetString(r.GetOrdinal("LastName"));
                        return i;
                    },
                    new Parameter("@Id", SqlDbType.Int, 2));
                foreach (var item in list2)
                {
                    Console.WriteLine("[{0}] {1} {2}", item.Id, item.FirstName, item.LastName);
                }

                Console.WriteLine();
                Console.WriteLine("Using the call Query<T>(string sql)");
                var list3 = db.Query<Member>("select Id, FirstName, LastName from Member");
                foreach (var item in list3)
                {
                    Console.WriteLine("[{0}] {1} {2}", item.Id, item.FirstName, item.LastName);
                }

                Console.WriteLine();
                Console.WriteLine("Using dynamic");
                var list4 = db.Query<dynamic>("select Id, FirstName, LastName from Member");
                foreach (var item in list4)
                {
                    Console.WriteLine("[{0}] {1} {2}", item.Id, item.FirstName, item.LastName);
                }

                db.Execute("delete from Member where FirstName = @firstName and LastName = @lastName",
                    new Parameter("@firstName", SqlDbType.VarChar, "John", 50),
                    new Parameter("@lastName", SqlDbType.VarChar, "Smith", 50));
            }

            Console.WriteLine();
            Console.WriteLine("Using the transactions");
            using (var db = new Database("Island"))
            {
                db.BeginTransaction();
                db.Execute("insert into Member (FirstName, LastName) values (@firstName, @lastName)",
                   new Parameter("@firstName", SqlDbType.VarChar, "John", 50),
                   new Parameter("@lastName", SqlDbType.VarChar, "Smith", 50));
                db.RollbackTransaction();

                var list = db.Query<Member>(
                    "select Id, FirstName, LastName from Member where FirstName=@firstName and LastName=@LastName",
                    r => {
                        var i = new Member();
                        i.Id = r.GetInt32(r.GetOrdinal("Id"));
                        i.FirstName = r.GetString(r.GetOrdinal("FirstName"));
                        i.LastName = r.GetString(r.GetOrdinal("LastName"));
                        return i;
                    },
                    new Parameter("@firstName", SqlDbType.VarChar, "John", 50),
                    new Parameter("@lastName", SqlDbType.VarChar, "Smith", 50)
                );
                foreach (var item in list)
                {
                    Console.WriteLine("[{0}] {1} {2}", item.Id, item.FirstName, item.LastName);
                }
            }
            stopwatch.Stop();
            Console.WriteLine("{0}ms", stopwatch.ElapsedMilliseconds);
            Console.ReadLine();
        }