Introduction
The main goal of this article to explains how to work with MongoDB using C Sharp. will help you to learn create database, create database, create collection, insert document into collection, remove document from collection and query from collection etc. To work with MongoDB you need to download MongoDB C sharp driver that supports to work with MongoDB.
Getting Started
Working with Mongo DB is the same as working in Linq and entity framework. Mongo DB contains same feature, same work style that Linq and Entity FrameWork have. This is one of the great features of mongo DB.
First download the driver then add the reference of two dlls names (MogoDB BOSON and MongoDbdriver) and use the reference of following namespaces.
using MongoDB.Bson;
using MongoDB.Driver;
using MongoDB.Driver.Builders;
using MongoDB.Driver.GridFS;
using MongoDB.Driver.Linq;
Connection String Syntax
Default Connection String: "mongodb://localhost"Above connection string will connection to local default server having port 27017, you can use customized connection like "mongodb://192.162.1.xx:27017"
Creating Client
MongoClient client = new MongoClient(connectionString);
Like SQL connection you are required you create Mongo Db client,above code creats object of Mongoclient which takes connection strig as parameter.Getting Server Reference
MongoServer server = client.GetServer();
Above code gets reference of mongo server, its calls GetServer() function of mongo client that returns objects of mongo server;Getting Database Reference
Create mongo database to get collection (Table in Sql server), where you store your. MongoDatabase database = server.GetDatabase("Test");
This code calls GetDatabase function to get reference of mongo databse . the Get Database function takes name of server as parameter, if database not availabel Mongo DB creates a database with specified name in the parameter and returns the database . Here code trying to get reference of test database.Getting Reference of Collection
Like SQL server mongo db database contains collection to store data. To get reference of collection, it is required to call get collection function of mongo db database. MongoCollection symbolcollection= database.GetCollection<Symbol>("Symbols")
The getcollection function takes symbol name as parameter and returns reference of collection, like get database collection it also create if collection not available specified name in the parameter it creates a collection having same name. Here symbol is an entity that specifies type of collection.Getting Reference of Collection List
List of mongo collection can also be get by calling GetCollections function of database, it return all collection available in the database in list. List<MongoCollection> collections=database.GetCollections();
Drop Collection from Database
database.DropCollection("Symbols");
Drop Collection function of mongo database class deletes collection specified the name in the parameter from database.Insert into Collection
Symbol symbol = new Symbol ();
symbol.Name = “Star”;
collections.Insert(symbol);
symbol is a class, above code inserts an object of symbol into collection. In below mention you would have noticed id which that type is ObjectID. Property id is not mentioned in the above code because this is optional, if you do not mention mongo db collection like SQL table automatically gives an id number to it. Like auto generated id column in the SQL server table. public class Symbol
{
public string Name { get; set; }
public ObjectId ID { get; set; }
}
Querying form Collection
List< Symbol > query = symbolcollection.AsQueryable<Symbol>().Where<Entity>(sb => sb.Name == "Star").ToList();
Summary
In this article we have discussed how to work in mongodb using C#, Hope this article may helpful to you
Thanks