We have seen many Applications use Relational Database Management System (RDBMS) like SQL Server, Oracle, MYSQL etc. as data repositories to applications. Almost all the relational databases support:
- Huge data storage
- Support transactions (ACID)
- Provide SQL to communicate to data
- Vertical Scalability
- Security
- Fragmentation, replication , clustering etc
There are some problems in RDBMS, which many systems have experienced.
- Relational Databases need a schema; we cannot add records to a database which have not been defined in the schema earlier.
- We can’t add a record which does not fit the schema; for example, we cannot insert an integer data type to a DateTime data type in SQL Server.
- We cannot add multiple items into a field.
- We need to add nulls to unused columns in a row, which gives a performance hit.
- Expensive regarding product cost, hardware, and maintenance; and there are a lot of problems with speed and availability
- The overhead of writing complex SQL queries.
To
avoid all these problems, the industry has come up/is coming up with the concept of NO
SQL, which has the features given below:.
- No Overhead of transactions.
- No complex SQL queries.
- No burden of upfront schema design.
- Provides easy and frequent changes to DB.
- Fast development.
- Performance improvement.
- No single point of failure.
To
accomplish all these features, some of the industry leaders have come up with a new NO SQL
database, and some of the leading NO SQL database providers are Cassandra, Couchbase, Amazon DynamoDB, MongoDB, Oracle No SQL Database, Clustrix, memSQL etc.
Image Source –Google Search
There are many providers which give us more information on this available NO SQL in the market here.
These NO SQL databases differ from others due to the features. The characteristics which distinguish them is how to store the data. Some of them store the data by a document, some of them store the element by a key name, some of them store the data by graph or some of them are in the memory of NO SQL.
MongoDB is the most widely used NO SQL database because it manages high volumes of structured or non structured data and is faster in terms of processing, as well as efficient and scalable in nature.
Where NO SQL can be
used
Consider an application -- when it goes to production, it works fine. After a few years down the line, the data keeps on growing and lots of performance issues come up. A lot of effort is required by the DBA and developers as to where to partition the data, rearrange the index, implement master and slave data, etc. Some portions of the system data are static (read only), and we can put in MongoDB like Master Database records. (Dropdown values in some cases).
The Product information and product catalog, which is static, can be kept in MongoDB.
There are some external systems where we are not aware of what would be the nature of the data, such as XML, JSON, String, and binary information (Basically unstructured data).These record values can be kept in MongoDB.
NO SQL has not replaced RDBMS. RDBMS and NO SQL both can be used together to achieve a high performing system.
We will learn here how to get MongoDB, how to store the data in MongoDB, and how to do some operations in MongoDB.
MongoDB is an open source NO SQL Database. The official website for MongoDB is here. To download MongoDB, go to the below URL and download the appropriate version of the operating system you have in your machine.
![]()
I have downloaded the highlighted version here.
The installation steps are very easy, just download the exe and click “next” and follow the screenshots, given below:
![]()
![]()
Once you install MongoDB, the folders with the path must have the files, given below:
![]()
In the root folder of installation, create a folder C:\data\db. In this path, MongoDB stores the data.
![]()
After the installation, go to the command prompt and go to the path “C:\Program Files\MongoDB\Server\3.2\bin”,
Type mongod command to start the database.
![]()
MongoDB has started now.
![]()
Basic Commands in MongoDB
Go to the command prompt and go to the path C:\Program Files\MongoDB\Server\3.2\bin
C:\Program Files\MongoDB\Server\3.2\bin>mongo
Now the screen will be shown, as given below:
![]()
In the test DB, I want to store some information into studentsInformation collection. The insert statement will be as follows:.
- db.studentsInformation.insert({StudentId : "1002",Name:"SMIT",Address:"45 Main st",City:"Compton", State:"LA",Country:"USA", Department:"CIVIL ENGINEERING", Marks:"90"})
![]()
We have createda MongoDB database and inserted some data into it. Let’s create an ASP.NET Web page and see how to do some operations in it.
Go to Visual Studio, create an ASP.NET Web Application.
Add a dummy page named MongoDBOperation.aspx.
Go to Tool and then go to NuGet Package Manager Console and type “Install-Package mongocsharpdriver -Version 1.8.3”, given in the screenshot, below:
![]()
Once we install MongoDB Driver for C#, the required Dlls will be referred to in the project.
Fetching the data from MongoDB is as follows:
MongoDBOperation.aspx
MongoDBOperation.aspx.cs
- using MongoDBDemo.Model;
- using MongoDB.Bson;
- using MongoDB.Driver;
- using System;
- using System.Configuration;
- using System.Web.UI.WebControls;
-
-
- namespace MongoDBDemo
- {
- public partial class MongoDBOperation : System.Web.UI.Page
- {
-
- protected void Page_Load(object sender, EventArgs e)
- {
- string con = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
- MongoServer server = MongoServer.Create(con);
- MongoDatabase myDB = server.GetDatabase("test");
- MongoCollection<studentsInformation> Students = myDB.GetCollection<studentsInformation>("studentsInformation");
-
-
- grdStudentInformation.DataSource = Students.FindAll();
- grdStudentInformation.DataBind();
- }
-
- protected void btnSave_Click(object sender, EventArgs e)
- {
-
- string con = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
- MongoServer server = MongoServer.Create(con);
- MongoDatabase myDB = server.GetDatabase("test");
- MongoCollection<studentsInformation> collection = myDB.GetCollection<studentsInformation>("studentsInformation");
-
-
-
- BsonDocument newstudentInfo = new BsonDocument{
- {"StudentId",txtStudentId.Text.ToString()},
- {"Name",txtStudentName.Text.ToString()},
-
- {"Address",txtAddress.Text.ToString()},
- {"City",txtCity.Text.ToString()},
-
- {"State",txtState.Text.ToString()},
- {"Country",txtCountry.Text.ToString()},
-
- {"Department",txtDepartment.Text.ToString()},
- {"Marks",txtMarks.Text.ToString()},
- };
- collection.Insert(newstudentInfo);
- }
-
- protected void OnSelectedIndexChanged(object sender, EventArgs e)
- {
- GridViewRow row = grdStudentInformation.SelectedRow;
- ViewState["Idval"] = row.Cells[0].Text;
- txtStudentId.Text = row.Cells[1].Text;
- txtStudentName.Text = row.Cells[2].Text;
- txtAddress.Text = row.Cells[3].Text;
-
- txtCity.Text = row.Cells[4].Text;
- txtState.Text = row.Cells[5].Text;
-
- txtCountry.Text = row.Cells[6].Text;
- txtDepartment.Text = row.Cells[7].Text;
- txtMarks.Text = row.Cells[8].Text;
- }
-
-
- protected void btnUpdate_Click(object sender, EventArgs e)
- {
- string con = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
- MongoServer server = MongoServer.Create(con);
- MongoDatabase myDB = server.GetDatabase("test");
- MongoCollection<studentsInformation> collection = myDB.GetCollection<studentsInformation>("studentsInformation");
-
- IMongoQuery query = MongoDB.Driver.Builders.Query.EQ("_id", ViewState["Idval"].ToString());
- IMongoUpdate update = MongoDB.Driver.Builders.Update.Set("StudentId", txtStudentId.Text.ToString())
- .Set("Name", txtStudentName.Text.ToString())
- .Set("Address", txtAddress.Text.ToString())
- .Set("City", txtCity.Text.ToString())
- .Set("State", txtState.Text.ToString())
- .Set("Country", txtCountry.Text.ToString())
- .Set("Department", txtDepartment.Text.ToString())
- .Set("Marks", txtMarks.Text.ToString());
- collection.Update(query, update);
- }
- }
- }
![]()
We saw MongoDB data interaction from an ASP.NET UI Page.
I hope you understood the basic concepts of NO SQL and how to use Mongo DB in an ASP.NET page. Thanks for your valuable time for reading it.