private void CreateServer()
{
server = null;
try
{
Console.WriteLine("Getting Servicer object......");
#pragma warning disable CS0618 // Type or member is obsolete
server = client.GetServer();
#pragma warning restore CS0618 // Type or member is obsolete
Console.WriteLine("Server object created Successfully....");
Console.WriteLine("Server :" + server.ToString());
}
catch (Exception ex)
{
Console.WriteLine("Filed to getting Server Details");
Console.WriteLine(ex.Message);
}
}
public static void Connect()
{
Console.WriteLine("Mongo DB Test Application");
Console.WriteLine("====================================================");
Console.WriteLine("Started By:Kailash Chandra Behera");
Console.WriteLine("Started On: 14 July 2014");
Console.WriteLine("Configuration Setting: 172.16.1.24:27017");
Console.WriteLine("====================================================");
Console.WriteLine("Initializaing connection");
string connectionString = "mongodb://localhost:27017";
Console.WriteLine("Creating Client..........");
MongoClient client = null;
try
{
client = new MongoClient(connectionString);
Console.WriteLine("Client Created Successfuly........");
Console.WriteLine("Client: " + client.ToString());
}
catch (Exception ex)
{
Console.WriteLine("Filed to Create Client.......");
Console.WriteLine(ex.Message);
}
Console.WriteLine("Initianting Mongo Db Server.......");
MongoServer server = null;
try
{
Console.WriteLine("Getting Servicer object......");
server = client.GetServer();
Console.WriteLine("Server object created Successfully....");
Console.WriteLine("Server :" + server.ToString());
}
catch (Exception ex)
{
Console.WriteLine("Filed to getting Server Details");
Console.WriteLine(ex.Message);
}
Console.WriteLine("Initianting Mongo Databaser.........");
MongoDatabase database = null;
try
{
Console.WriteLine("Getting reference of database.......");
database = server.GetDatabase("kara_db");
Console.WriteLine("Database Name : " + database.Name);
}
catch (Exception ex)
{
Console.WriteLine("Failed to Get reference of Database");
Console.WriteLine("Error :" + ex.Message);
}
try
{
Console.WriteLine("Deleteing Collection Symbol");
database.DropCollection("Symbol");
}
catch (Exception ex)
{
Console.WriteLine("Failed to delete collection from Database");
Console.WriteLine("Error :" + ex.Message);
}
Console.WriteLine("Getting Collections from database Database.......");
MongoCollection symbolcollection = null;
try
{
symbolcollection = database.GetCollection <Symbol>("Symbols");
Console.WriteLine(symbolcollection.Count().ToString());
}
catch (Exception ex)
{
Console.WriteLine("Failed to Get collection from Database");
Console.WriteLine("Error :" + ex.Message);
}
ObjectId id = new ObjectId();
Console.WriteLine("Inserting document to collection............");
try
{
Symbol symbol = new Symbol();
symbol.Name = "Star";
symbolcollection.Insert(symbol);
id = symbol.ID;
Console.WriteLine(symbolcollection.Count().ToString());
}
catch (Exception ex)
{
Console.WriteLine("Failed to insert into collection of Database " + database.Name);
Console.WriteLine("Error :" + ex.Message);
}
try
{
//Console.WriteLine("Preparing Query Document............");
//List<Symbol> query = symbolcollection.AsQueryable<Entity>().Where<Entity>(sb => sb.Name == "Kailash").ToList();
//Symbol symbol = symbolcollection.AsQueryable<Entity>().Where<Entity>(sb => sb.ID == id).ToList();
}
catch (Exception ex)
{
Console.WriteLine("Failed to query from collection");
Console.WriteLine("Exception :" + ex.Message);
}
}
public IActionResult Index()
{
Console.WriteLine("Configuration Setting: 172.16.1.24:27017");
Console.WriteLine("====================================================");
string connectionString = "mongodb://localhost:27017";
Console.WriteLine("Creating Client..........");
MongoClient client = null;
try
{
client = new MongoClient(connectionString);
Console.WriteLine("Client Created Successfuly........");
Console.WriteLine("Client: " + client.ToString());
}
catch (Exception ex)
{
Console.WriteLine("Filed to Create Client.......");
Console.WriteLine(ex.Message);
}
Console.WriteLine("Initianting Mongo Db Server.......");
MongoServer server = null;
try
{
Console.WriteLine("Getting Servicer object......");
server = client.GetServer();
Console.WriteLine("Server object created Successfully....");
Console.WriteLine("Server :" + server.ToString());
}
catch (Exception ex)
{
Console.WriteLine("Filed to getting Server Details");
Console.WriteLine(ex.Message);
}
Console.WriteLine("Initianting Mongo Databaser.........");
MongoDatabase database = null;
try
{
Console.WriteLine("Getting reference of database.......");
database = server.GetDatabase("admin");
Console.WriteLine("Database Name : " + database.Name);
}
catch (Exception ex)
{
Console.WriteLine("Failed to Get reference of Database");
Console.WriteLine("Error :" + ex.Message);
}
Console.WriteLine("Getting Collections from database Database.......");
MongoCollection symbolcollection = null;
try
{
if (database.GetCollection("Symbols").Exists())
{
symbolcollection = database.GetCollection("Symbols");
Console.WriteLine(symbolcollection.Count().ToString());
}
else
{
database.CreateCollection("Symbols");
}
}
catch (Exception ex)
{
Console.WriteLine("Failed to Get collection from Database");
Console.WriteLine("Error :" + ex.Message);
}
Symbol symbol;
Console.WriteLine("Inserting document to collection............");
try
{
ObjectId id = new ObjectId();
for (int i = 0; i < 10; i++)
{
symbol = new Symbol();
symbol.Name = "Option" + i;
symbol.Value = i;
symbolcollection.Insert(symbol);
id = symbol._id;
}
Console.WriteLine(symbolcollection.Count().ToString());
}
catch (Exception ex)
{
Console.WriteLine("Failed to insert into collection of Database " + database.Name);
Console.WriteLine("Error :" + ex.Message);
}
try
{
Console.WriteLine("Preparing Query Document............");
List <Symbol> query = symbolcollection.AsQueryable <Symbol>().ToList();
Console.WriteLine(query);
List <SelectListItem> li = new List <SelectListItem>();
for (int i = 0; i < query.Count(); i++)
{
li.Add(new SelectListItem {
Text = query[i].Name, Value = query[i].Value.ToString()
});
}
ViewData["country"] = li;
}
catch (Exception ex)
{
Console.WriteLine("Failed to query from collection");
Console.WriteLine("Exception :" + ex.Message);
}
Console.WriteLine("");
Console.WriteLine("====================================================");
return(View());
}
