var clientConfiguration = GetConfiguration("couchbase.json"); ClusterHelper.Initialize(clientConfiguration); var bucket = ClusterHelper.GetBucket("flamebucket"); var bucketManager= bucket.CreateManager(); bucketManager.CreateN1qlPrimaryIndex(false); bucket.Upsert("google:one", new Blog { Id = 1, BlogName = "i 1th blog" }); bucket.Upsert("google:two", new Blog { Id = 2, BlogName = "i 2th blog" }); bucket.Upsert("flame:three", new Blog { Id = 3, BlogName = "i 3th blog" }); bucket.Upsert("ro:four", new Blog { Id = 4, BlogName = "i 4th blog" }); bucket.Upsert("ro:five", new Blog { Id = 5, BlogName = "i 5th blog" }); while (true) { Console.Clear(); Console.WriteLine("please input google flame ro"); string keyprefix = Console.ReadLine(); if (keyprefix.StartsWith("q")) { break; } var query = bucket.CreateQuery("flamedesigndoc", "allkeys", false).StartKey(keyprefix).EndKey(keyprefix+ "\ufff0"); var result = bucket.Query<Blog>(query); foreach (var row in result.Rows) { Console.WriteLine(" key: "+row.Key); Console.WriteLine("=====id:"+row.Value.Id +" blogName: "+ row.Value.BlogName); } Console.ReadLine(); } Console.Read();