Beginning Database Design Solutions, 2nd Edition

23MongoDB Atlas in C#

This chapter's example uses C# to build a NoSQL document database in the cloud. It uses the MongoDB Atlas database to save and query the data shown in Table 23.1 about assignments for East Los Angeles Space Academy graduates.

TABLE 23.1: Assignment data

FIRSTNAME	LASTNAME	POSITION	RANK	SHIP
Joshua	Ash	Fuse Tender	6th Class	Frieda's Glory
Sally	Barker	Pilot		Scrat
Sally	Barker	Arms Master		Scrat
Bil	Cilantro	Cook's Mate		Scrat
Al	Farnsworth	Diplomat	Hall Monitor	Frieda's Glory
Al	Farnsworth	Interpreter		Frieda's Glory
Major	Major	Cook's Mate	Major	Athena Ascendant
Bud	Pickover	Captain	Captain	Athena Ascendant

If you skipped Chapter 22, “MongoDB Atlas in Python,” which built a similar example in Python, return to that chapter and read the beginning and the first four sections, which are described in the following list:

• “Not Normal but Not Abnormal” talks a bit about data that doesn't fit well in a relational database but that does fit in a document database.
• “XML, JSON, and BSON” gives a few details about the XML, JSON, and BSON formats that are commonly used by document databases.
• “Install MongoDB Atlas” explains how to create a MongoDB Atlas database in the cloud.
• “Find the Connection Code” tells how you can find the connection code that allows your program to connect to the database.

When you reach “Create the Program” in Chapter 22, return here and start on the following sections.

CREATE THE PROGRAM

To create a C# ...