MongoDB CRUD Operation in ASP MVC.Net

Table of Content:-

1. MongoDB Setup and Installations

2. Add a User Registration Page and Save Records in MongoDB

3. Get User Records from MongoDB through LINQ

4. Edit/Update Records in MongoDB

5. Delete/Drop Records from MongoDB through LINQ

MongoDB Setup and Installations:-

1. Download MongoDB using below link, http://www.mongodb.org/downloads?_ga=1.20290616.1294468948.1419862328

2. Setup MongoDB as per below link instructions, http://docs.mongodb.org/manual/tutorial/install-mongodb-on-windows/

Stayed Informed – YouTube Video link for Setup MongoDB

Stayed Informed - Why use MongoDB in MVC .Net?

The main Reason is to Use MongoDB with ASP.Net MVC are,

1. So Faster Development.

2. Minimal Migrations.

3. Easier Collaborations.

4. Maintainable Design.

5. Much Rich Behaviours.

6. Scalability.

7. GridFS

MongoDB Connection for ASP.NET MVC,

//Type 1
//Using config app Settings.
<appSettings>
  <add key="connectionString" value="Server=localhost:27017"/>
</appSettings>

 //CREATE AN INSTANCE OF MONGOSERVER USING THE CONNECTION STRING.
MongoServer client = MongoServer.Create(ConfigurationManager.AppSettings["connectionString"]);

//Type 2
//CREATE AN INSTANCE OF MONGOSERVER USING THE SERVER CONNECTION PORT.
MongoServer client = MongoServer.Create("Server=localhost:27017");

//Type 2
//INITIALIZES A NEW INSTACE OF THE MONGOCLIENT CLASS.
MongoClient client = new MongoClient();

Example Source code for MongoDb with MVC 5 as,

using System;
using System.Web.Mvc;
using MongoDB.Driver;
using MongoDB.Bson;
using MongoDB.Driver.Builders;
using System.Linq;

namespace MongoDemoApp.Controllers
{
    public class UserController : Controller
    {
        public ActionResult Index()
        {
            //CREATE AN INSTANCE OF MONGOSERVER USING THE CONNECTION STRING.
            //MongoServer server = MongoServer.Create(ConfigurationManager.AppSettings["connectionString"]);

            //CREATE AN INSTANCE OF MONGOSERVER USING THE SERVER CONNECTION PORT.
            //MongoServer client = MongoServer.Create("Server=localhost:27017");

            //INITIALIZES A NEW INSTACE OF THE MONGOCLIENT CLASS.
            MongoClient client = new MongoClient();
                      
            //GET MONGO SERVER.
            var server = client.GetServer();

            //GET MONGO DATABASE.
            var db = server.GetDatabase("MongoDemo");

            //GET MONGO COLLECTION.
            var collection = db.GetCollection("UsersDetail");

            //ADD COLLECTION ROWS IN THE USERS DETAIL DOCUMENT.
            collection.Save(new Users {
                    name ="Anil Singh",
                    site ="code-sample.com",
                    CretaeDate =DateTime.Now
            });

            //DROP COLLECTION
            //collection.Drop();

            return View(collection);
        }

        [HttpPost]
        public ActionResult Add(Users userObj)
        {
            MongoServer serverObj = MongoServer.Create("Server=localhost:27017");
            MongoDatabase dbObj = serverObj.GetDatabase("MongoDemo");

            MongoCollection<BsonDocument> addUser = dbObj.GetCollection<BsonDocument>("Users");

            //INSERT INTO USERS DOCUMENT.
            addUser.Insert<Users>(userObj);

            return View();
        }

        //BIND USER ON EDIT VIEW.
        public ActionResult Edit(int id)
        {
            MongoServer serverObj = MongoServer.Create("Server=localhost:27017");
            MongoDatabase dbObj = serverObj.GetDatabase("MongoDemo");

            IMongoQuery query = Query.EQ("id", id);
            var user = dbObj.GetCollection("Users").Find(query).FirstOrDefault();

            return View(user);
        }

        //UPDATE USER
        [HttpPost]
        public ActionResult Edit(Users userObject)
        {
            MongoServer serverObj = MongoServer.Create("Server=localhost:27017");
            MongoDatabase dbObj = serverObj.GetDatabase("MongoDemo");

            IMongoQuery query = Query.EQ("id", userObject.id);

            //UPDATE USERS DOCUMENT
            IMongoUpdate updateQuery = Update.Set("name", userObject.name)
                .Set("site", userObject.site)
                .Set("CretaeDate", DateTime.Now);

            var user = dbObj.GetCollection("Users").Find(query).SingleOrDefault();
            dbObj.GetCollection("Users").Update(query, updateQuery);

            return RedirectToAction("GetUserList");
        }

        //DELETE USER
        public ActionResult Delete(int id)
        {
            MongoServer serverObj = MongoServer.Create("Server=localhost:27017");
            MongoDatabase dbObj = serverObj.GetDatabase("MongoDemo");

            IMongoQuery query = Query.EQ("id", id);

            //DELETE USERS DOCUMENT BY ID
            dbObj.GetCollection("Users").Remove(query);

            return View();
        }

        public class Users
        {
            public ObjectId id { get; set; }
            public string name { get; set; }
            public string site { get; set; }
            public DateTime CretaeDate { get; set; }
        }
    }
}