예제 #1
0
        static void Main(string[] args)
        {
            var conn = new ClickHouseConnection("Compress=True;CheckCompressedHash=False;Compressor=lz4;Host=192.168.10.110;Port=9000;Database=geekbuying;User=default;Password=;");

            conn.Open();
            CreateTable(conn);

            try
            {
                var user = new TestUser()
                {
                    ResisterDate = DateTime.Now, ResisterTime = DateTime.Now, Age = 18, Name = "张三2"
                };
                var user2 = new TestUser()
                {
                    ResisterDate = DateTime.Now, ResisterTime = DateTime.Now, Age = 18, Name = "张三"
                };
//                conn.Insert(user);
                Console.WriteLine("Insert single success.");

                conn.InsertBulk(new List <TestUser>()
                {
                    user, user2
                });
                Console.WriteLine("Insert multi success.");
            }
            catch (Exception e)
            {
                Console.WriteLine(e.ToString());
            }
            conn.Close();
        }
예제 #2
0
        public void TestInsertBulk()
        {
            var user = new TestUser()
            {
                ResisterDate = DateTime.Now, ResisterTime = DateTime.Now, Age = 18, Name = "уехЩ23"
            };
            var user2 = new TestUser()
            {
                ResisterDate = DateTime.Now, ResisterTime = DateTime.Now, Age = 18, Name = "уехЩ3"
            };

            var users = new List <TestUser>()
            {
                user, user2
            };

            conn.InsertBulk(users);
        }