MongoDB CRUD Operations Using C#

In this article, we will learn how to perform CRUD operations using ASP.NET MVC and MongoDB. In my previous articles, I explained the basic functions of MongoDB that are required to insert, update, and delete the data. The purpose of this series of articles is to learn how we use MongoDB with .NET applications. In the last few articles, we have learned MongoDB with C# Console applications. You can check my previous articles here -

You can check how to set up the MongoDB environment from Here.

Step for CRUD Operation

Step 1

Open Visual Studio and create a new project.

CRUD Operations Using ASP.NET MVC and MongoDB

Name it as CrudOperation_MvcandMongoDB.

Choose the Template tpe as MVC.

Step 2

Add MongoDB Drivers for C# using NuGet Package Manager.

Add the required Namespace for MongoDB.

using MongoDB.Driver;
using MongoDB.Bson;

Step 3

Now, add a connection string in the web.config file and add the follwoing line in the App Settings section of that file.

<add key="connectionString" value="mongodb://localhost"/>

Step 4

Add a class in Models folder and name it EmployeeDetails.

Now, add the following lines.

public String Id { get; set; }
public string Name { get; set; }
public string Department { get; set; }
public string Address { get; set; }
public string City { get; set; }
public string Country { get; set; }

Step 5

Click on Controller Folder and add a new empty controller and name it Home Controller

Step 6

Now add a Connection string in Web.config File and Web.config and add the follwoing line in App settings section. Now Add using System.Configuration in Controller and add an actionmethod to insert data into the database. Add the following Namespace to import Model.

using CrudOperation_MvcandMonGoDB.Models;

Add these lines in the action method to insert data into database

[HttpPost]
public ActionResult Index(EmployeeDetails Emp)
{
if (ModelState.IsValid)
{
string constr = ConfigurationManager.AppSettings["connectionString"];
var Client = new MongoClient(constr);
var DB = Client.GetDatabase("Employee");
var collection = DB.GetCollection<EmployeeDetails>("EmployeeDetails");
collection.InsertOneAsync(Emp);
return RedirectToAction("emplist");
}
return View();
}

Now click on the index method and add a view and add the following code in the View.

@model CrudOperation_MvcandMonGoDB.Models.EmployeeDetails
<div class="col-md-12">
<h2>Employee Detail</h2>
</div>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<hr />
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Department, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Department, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Department, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Address, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Address, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Address, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.City, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.City, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.City, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Country, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Country, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Country, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Add" class="btn btn-primary" />
</div>
</div>
</div>
}
@section Scripts {
@Scripts.Render("~/bundles/jqueryval")
}

Run the Project and try to insert data

Now open Robo 3T and check the data is inserted

Record is successfully inserted into the database

Step 7

Now we retrieve data from the database. Add an Actionmethod and add the following code to retrieve data from the database.

public ActionResult emplist()
{
string constr = ConfigurationManager.AppSettings["connectionString"];
var Client = new MongoClient(constr);
var db = Client.GetDatabase("Employee");
var collection = db.GetCollection<EmployeeDetails>("EmployeeDetails").Find(new BsonDocument()).ToList();
return View(collection);
}

Now add a view to display data and add the following code.

@model IEnumerable<CrudOperation_MvcandMonGoDB.Models.EmployeeDetails>
@{
ViewBag.Title = "Employee Details";
}
<h3 style="text-align:center">Employee Details</h3>
<p>
@Html.ActionLink("Add New Employee", "Index")
</p>
<table class="table">
<tr>
<th>
@Html.DisplayNameFor(model => model.Name)
</th>
<th>
@Html.DisplayNameFor(model => model.Department)
</th>
<th>
@Html.DisplayNameFor(model => model.Address)
</th>
<th>
@Html.DisplayNameFor(model => model.City)
</th>
<th>
@Html.DisplayNameFor(model => model.Country)
</th>
<th></th>
</tr>
@foreach (var item in Model) {
<tr>
<td>
@Html.DisplayFor(modelItem => item.Name)
</td>
<td>
@Html.DisplayFor(modelItem => item.Department)
</td>
<td>
@Html.DisplayFor(modelItem => item.Address)
</td>
<td>
@Html.DisplayFor(modelItem => item.City)
</td>
<td>
@Html.DisplayFor(modelItem => item.Country)
</td>
<td>
@Html.ActionLink("Edit", "Edit", new { id=item.Id }) |
@Html.ActionLink("Delete", "Delete", new { id=item.Id })
</td>
</tr>
}
</table>

Run the Project

Step 8

Add a new Method for deleting data based on Id and add the following code to delete data

public ActionResult Delete(string id)
{
if (ModelState.IsValid)
{
string constr = ConfigurationManager.AppSettings["connectionString"];
var Client = new MongoClient(constr);
var DB = Client.GetDatabase("Employee");
var collection = DB.GetCollection<EmployeeDetails>("EmployeeDetails");
var DeleteRecored = collection.DeleteOneAsync(
Builders<EmployeeDetails>.Filter.Eq("Id", id));
return RedirectToAction("emplist");
}
return View();
}

Step 9

For editing data add Actionmethod and add code for editing data.

public ActionResult Edit(EmployeeDetails Empdet)
{
if (ModelState.IsValid)
{
string constr = ConfigurationManager.AppSettings["connectionString"];
var Client = new MongoClient(constr);
var Db = Client.GetDatabase("Employee");
var collection = Db.GetCollection<EmployeeDetails>("EmployeeDetails");
var update = collection.FindOneAndUpdateAsync(Builders<EmployeeDetails>.Filter.Eq("Id", Empdet.Id), Builders<EmployeeDetails>.Update.Set("Name", Empdet.Name).Set("Department", Empdet.Department).Set("Address", Empdet.Address).Set("City", Empdet.City).Set("Country", Empdet.Country));
return RedirectToAction("emplist");
}
return View();
}

Now add a view

@model CrudOperation_MvcandMonGoDB.Models.EmployeeDetails
@{
ViewBag.Title = "Edit";
}
<h2>Edit</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
<div class="form-horizontal">
<h4>EmployeeDetails</h4>
<hr />
@Html.ValidationSummary(true, "", new { @class = "text-danger" })
@Html.HiddenFor(model => model.Id)
<div class="form-group">
@Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Department, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Department, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Department, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Address, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Address, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Address, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.City, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.City, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.City, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
@Html.LabelFor(model => model.Country, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.EditorFor(model => model.Country, new { htmlAttributes = new { @class = "form-control" } })
@Html.ValidationMessageFor(model => model.Country, "", new { @class = "text-danger" })
</div>
</div>
<div class="form-group">
<div class="col-md-offset-2 col-md-10">
<input type="submit" value="Save" class="btn btn-default" />
</div>
</div>
</div>
}
<div>
@Html.ActionLink("Back to List", "Index")
</div>

Now we run the project.

Summary

In this article, we learned about Crud operations using Asp.net MVC and MongoDB. This article gives you a basic understanding of how we can use MongoDB with Asp.net MVC applications. In the next article, we will learn registration and logging in using Asp.net MVC and MongoDB.

16 Comments

Join the conversation! Your thoughts help the community grow.

Sandeep Kumar11y ago
nice share sir :)
Humayun Kabir Mamun11y ago
Nice...
Pankaj Kumar Choudhary11y ago
Thanks Rakesh Chavda Sir.......
Pankaj Kumar Choudhary11y ago
Thanks Abhishek Singh Sir.............
Pankaj Kumar Choudhary11y ago
thanks Ankit Bansal Sir.........
Pankaj Kumar Choudhary11y ago
Thanks Sumit Joshi Sir...........
Pankaj Kumar Choudhary11y ago
Thanks Sibeesh Venu Sir...........
Pankaj Kumar Choudhary11y ago
Thanks Harshad Pansuriya............
Pankaj Kumar Choudhary11y ago
Thanks Nilesh Jadav Sir..........
Rakesh11y ago
Nice work
Abhishek Kumar11y ago
very nice for beginners...Thanks for sharing..
Ankit Bansal11y ago
good one...
Sumit Joshi11y ago
good one.
Sibeesh Venu11y ago
Nice Share :)
Harshad Pansuriya11y ago
Nice One
Nilesh Jadav11y ago
Great Work Pankaj Kumar Choudhary