dotConnect for MongoDB is an ADO.NET data provider for MongoDB. Its built-in SQL engine exposes MongoDB collections as tables, so the data can be queried and changed with SQL, DataSet/DataTable components, and Entity Framework Core, while native MongoDB commands in JSON remain available.

dotConnect for MongoDB is actively developed and supported by Devart. If you have questions about dotConnect for MongoDB, email the developers at [email protected] or visit the dotConnect for MongoDB webpage.

Advantages of dotConnect for MongoDB

SQL over MongoDB

dotConnect for MongoDB allows you to work with MongoDB collections as tables. You can use SELECT, INSERT, UPDATE, and DELETE statements, joins, and SQLite functions over collections. Nested fields of documents are available as columns.

Native MongoDB Commands

In addition to SQL, dotConnect for MongoDB allows you to execute native MongoDB commands, such as find, aggregate, and other database commands, written in Extended JSON.

Comprehensive Support for ADO.NET Technology Features

dotConnect for MongoDB supports ADO.NET features and technologies, including provider factory, connection string builder, metadata schemas, asynchronous commands, connection pooling, transactions, and TransactionScope.

Database Application Development Extensions

dotConnect for MongoDB has a set of design-time tools that streamline the development process. dotConnect for MongoDB integrates with Visual Studio 2017-2026 and includes Server Explorer integration, DataSet Wizard, and design-time component editors.

Provider-Specific Technologies

dotConnect for MongoDB has extra components designed to simplify some tasks. In particular, MongoDBScript executes a series of SQL statements, MongoDBLoader loads external data into MongoDB collections, and MongoDBDump backs up and restores the data of a collection.

Entity Framework Core Support

Entity Framework Core is an object-relational mapping framework with a focus on objects instead of relational data. dotConnect for MongoDB supports Entity Framework Core, including embedded documents and database-first scaffolding.

Both Connected and Disconnected Models

dotConnect for MongoDB combines connected and disconnected data access models in a single MongoDBDataTable component, which allows you to design more flexible application architecture and use the full power of data binding.

Key features

• Access to MongoDB 3.6 and later through the MongoDB C driver
• SQL and native MongoDB commands
• All current BSON types, including Decimal128
• .NET Framework and .NET support
• Entity Framework Core support
• Connected and disconnected model support
• Auxiliary components for SQL scripts and bulk data transfer
• Query execution monitoring
• Royalty-free per-developer, per-team, or per-site licensing

For more information, see Features.