During the last couple days I've been experimenting with MongoDB and its C# driver, cleverly written by Sam Corder. I'm investigating it as a replacement for a SQL Server database I am using in a web application that is higly community driven. This specific characteristic is the one that makes the NoSQL movement rise atop regular RDBMS systems like SQL Server or MySQL, since it is hard to mantain relational integrity in these scenarios. Other key features of MongoDB are focus on performance and scalability.
K. Scott Allen already wrote a quick intro on using the C# driver, so I used it as a tutorial for my first steps. Here are some thoughts I'd like to share on this topic:
- I don't like being held by the verbosity of instantiating Document objects every time I want to manipulate the database, so I've written method overloads for the main operations, like Insert, Update, Find and Delete that receive a plain object and only then convert them to Document. This allows us to leverage anonymous objects in C# and makes the code cleaner:
1: Mongo mongo = new Mongo();
2: mongo.Connect();
3: Database db = mongo["testdb"];
4: var col = db["users"];
5:
6: foreach(Document d in col.Find(new { name = "John Doe"}).Documents)
7: {
8: int johnId = d["_id"];
9: int johnName = d["name"];
10: }
The code with this implementation is available on my fork of the driver at github an will hopefully be merged with the master soon.
- MongoDB allows storage of files in the database, as well, through the GridFS specification. The C# api is already implemented and functional. Follow an example for writing a file to the database:
1: void Main()
2: {
3: Mongo mongo = new Mongo();
4: mongo.Connect();
5: Database db = mongo["test"];
6: var collection = db["testcollection"];
7: GridFile file = new GridFile(db);
8:
9: using(GridFileStream fs = file.Create("mycv")) // define the file name
10: {
11: ReadWriteStream(File.OpenRead(@"C:\Data\felipelima_en.doc"), fs);
12: }
13: }
14:
15: public static void ReadWriteStream(
16: Stream readStream,
17: Stream writeStream)
18: {
19: Byte[] buffer = new Byte[Int16.MaxValue];
20: int bytesRead = readStream.Read(buffer, 0, Int16.MaxValue);
21: // write the required bytes
22: while (bytesRead > 0)
23: {
24: writeStream.Write(buffer, 0, bytesRead);
25: bytesRead = readStream.Read(buffer, 0, Int16.MaxValue);
26: }
27: readStream.Close();
28: writeStream.Close();
29: }
Database files work just like plain Documents and will be assigned an Id upon creation. Therefore, they can be later queried just like a regular document.
This was just a quick glance over MongoDB and C# integration. I'm planning on using it on a large project and will post here my findings. More to come.
