예제 #1
0
        public void Start(IDataClient client)
        {
            if (client.TableExists("users"))
            {
                client.RemoveTable("users");
            }

            client.AddTable("users",
                            AutoIncrement("id").AsPrimaryKey(),
                            String("username", 50).NotNull(),
                            String("password", 50).NotNull()
                            );
            client.AddUniqueKey("un_users", "users", "username");

            client.Insert
            .Into("users")
            .Columns("username", "password")
            .Values("foo", "bar")
            .Values("foo2", "bar")
            .Values("foo3", "bar");

            var userInsert = new UserInsert {
                Username = "******",
                Password = "******"
            };

            client.Insert
            .Into("users")
            .Object(userInsert);

            userInsert.Username = "******";

            var id = client.Insert
                     .Into("users")
                     .ObjectAnd(userInsert)
                     .Return <int>("Id");

            var loadedUser = client.LoadById <User>("users", id, u => u.Id);

            Console.WriteLine("LoadById User: "******"foo4";
            var password = "******";

            client.ExecSqlFormattable($"insert into users (username, password) values ({username}, {password})");

            var users = client.Select
                        .AllColumns()
                        .From("users")
                        .Where(Filter.Eq("username", "foo"))
                        .OrderBy(OrderBy.Ascending("username"))
                        .SkipTake(0, 2)
                        .Map <User>();

            Console.WriteLine("Count: " + users.Count);
            foreach (var user in users)
            {
                Console.WriteLine("User: "******"foo%";
            var foos   = client.QueryFormattable($"select username, password from users where username like {filter}").Map <Foo>();

            Console.WriteLine("Count: " + foos.Count);
            foreach (var foo in foos)
            {
                Console.WriteLine("Foo: " + foo.Username);
            }
            Console.WriteLine("End----");
        }