|
DB");//, credentials//MyCompany
MongoCollection departments = myCompany.GetCollection("Departments");
departments.Drop();
}
#endregion
#region Employees
///
/// Retrieve employees from MyCompany database.
///
///
public static List GetEmployees()
{
List lst = new List();
MongoServer server = MongoServer.Create(ConnectionString);
MongoCredentials credentials = new MongoCredentials("geovindu", "geovindu");
MongoDatabase myCompany = server.GetDatabase("geovinDB");//, credentials//无验证密码登录
MongoCollection employees = myCompany.GetCollection("Employees");
foreach (Employee employee in employees.FindAll())
{
lst.Add(employee);
}
return lst;
}
///
/// Inserts sample employees data in MyCompany database
///
private static void CreateEmployees()
{
// add 5 sample Employees
for (int i = 1; i <= 5; i++)
{
string departmentId = "4f180083ef31ba0da8000010";
CreateEmployee("FirstName" + i, "LastName" + i, "Address" + i, "City" + i, departmentId);
}
}
///
/// Insert the employee
///
///
///
private static void CreateEmployee(string firstName, string lastName, string address, string city, string departmentId)
{
MongoServer server = MongoServer.Create(ConnectionString);
MongoCredentials credentials = new MongoCredentials("geovindu", "geovindu");
MongoDatabase myCompany = server.GetDatabase("geovinDB");//, credentials//MyCompany
MongoCollection employees = myCompany.GetCollection("Employees");
BsonDocument employee = new BsonDocument {
{ "FirstName", firstName },
{ "LastName", lastName },
{ "Address", address },
{ "City", city },
{ "DepartmentId", departmentId }
};
employees.Insert(employee);
}
///
/// Delete all data in employees collection in MyCompany database
///
public static void DeleteEmployees()
{
MongoServer server = MongoServer.Create(ConnectionString);
MongoCredentials credentials = new MongoCredentials("geovindu", "geovindu");
MongoDatabase myCompany = server.GetDatabase("geovinDB");//, credentials//MyCompany
MongoCollection employees = myCompany.GetCollection("Employees");
employees.Drop();
}
#endregion
}
#region Department
///
/// Department represents a single item(record) stored in Departments collection.
///
class Department
{
public ObjectId _id { get; set; }
public string DepartmentName { get; set; }
public ObjectId HeadOfDepartmentId { get; set; }
}
#endregion
#region Employee
///
/// Department represents a single item(record) stored in Employees collection.
///
class Employee
{
public ObjectId _id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Address { get; set; }
public string City { get; set; }
public ObjectId DepartmentId { get; set; }
}
#endregion
}
?
|