Beispiel #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //string connectionString = "mongodb://localhost";
            string connectionString = "mongodb://dbh11.mongolab.com:27117/";
            MongoServer server = MongoServer.Create(connectionString);
            MongoDatabase db = server.GetDatabase("hmicmsm", new MongoCredentials("amey1", "somepwd"));
            //MongoCredentials credentials = new MongoCredentials("username", "password");
            //MongoDatabase salaries = server.GetDatabase("salaries", credentials);

            //get the table
            MongoCollection<Subscriber> subscriberCollection = db.GetCollection<Subscriber>("Subscriber");

            //get all rows of the table as a cursor
            MongoCursor<Subscriber> subscribers = subscriberCollection.FindAll();
            PopulateLabel(subscribers);
            //where clause
            var query = new QueryDocument("FirstName", "John");
            PopulateLabel(subscriberCollection.Find(query));

            //find one does not return a cursor
            PopulateLabel(subscriberCollection.FindOne());

            //Insert
            Subscriber sub = new Subscriber
            {
                SubscriberId = 111,
                PrimaryEmailAddress = "*****@*****.**",
                FirstName = "Amey",
                LastName = "Test"
            };
            subscriberCollection.Insert(sub);
            PopulateLabel(subscriberCollection.FindAll());

            //QueryComplete q = Query.And(
            //    Query.EQ("FirstName", "Ernest"),
            //    Query.EQ("LastName", "Hemingway")
            //);

            //            var update = Update.Set("LastName", "Chow");
            //subscriberCollection.Remove(q);
            //PopulateLabel(subscriberCollection.FindAll());
        }
Beispiel #2
0
        private void PopulateLabel(Subscriber s)
        {
            if (s != null)
            {
                lblSome.Text += "SubscriberId: " + s.SubscriberId;
                lblSome.Text += " Email: " + s.PrimaryEmailAddress;
                lblSome.Text += " First Name: " + s.FirstName;
                lblSome.Text += " Last Name: " + s.LastName;

                lblSome.Text += "   ---   ";
            }
        }