.NET connector for MongoDB with ORM support

dotConnect for MongoDB is an ADO.NET provider that enables .NET applications to connect to MongoDB and work with its data using SQL. It provides direct access to MongoDB through standard ADO.NET interfaces, supports modern .NET platforms, and integrates with popular development tools and ORM frameworks.

  • Integration with Entity Framework Core, Dapper, and NHibernate
  • Full compliance with ADO.NET standards
  • Secure SSL/TLS connections
  • SQL queries to MongoDB collections, including JOIN and GROUP BY
  • Support for MongoDB data types: ObjectId, embedded documents, and arrays
  • Integration with Microsoft Visual Studio

Easy integration with MongoDB

Connect to MongoDB without dealing with driver-specific settings or complex configurations. Simply specify the server, database, and credentials to connect.

No need to learn the API

Work with MongoDB data without learning the MongoDB Query API or building complex aggregation pipelines. Use familiar SQL statements to query and manage your data.

User-friendly ADO.NET classes

Work with MongoDB using familiar ADO.NET classes and standard methods. Execute queries, retrieve data, and manage connections as with other ADO.NET providers.

Easy connection to MongoDB

dotConnect for MongoDB includes everything it needs to connect to MongoDB: the native MongoDB client libraries ship with the installer and the NuGet packages, so there is nothing else to install. Developers can establish connections, execute SQL queries against MongoDB collections, and retrieve data using familiar ADO.NET components.

  • MongoDB client libraries included, nothing else to install
  • SQL queries to MongoDB collections and native MongoDB commands in JSON
  • Authentication with a user name and password, including a separate authentication database
  • Secure connections over SSL/TLS with server certificate validation through the Windows certificate store and client certificates
  • Connections to replica sets and multiple servers

Advanced ORM support

dotConnect for MongoDB supports popular ORM frameworks and integrates with Entity Developer, Devart's visual ORM designer, available as a separate product. Developers can use familiar object-oriented approaches to access and process MongoDB data within .NET applications.

Entity Framework Core

3.1, 8-11

NHibernate

1.x-5.x

Dapper

1.x, 2.x

Entity Developer helps developers generate entity classes and data access models from existing database structures, reducing manual coding and simplifying application maintenance.

Compatibility and integration

Platforms

  • .NET 5.0-11.0
  • .NET Framework 4.5.1-4.8
  • .NET Core 2.0-3.1

Data source

MongoDB 3.6 and later

Visual Studio integration

  • Visual Studio 2017-2026
  • Data source connections
  • Design-time data access components
  • Component editors and DataSet Generator

ORM integration

  • Entity Framework Core
  • NHibernate
  • Dapper

Single connector for all your SQL queries

dotConnect for MongoDB lets you query MongoDB collections as tables with SQL. The built-in SQL engine processes the queries, so you can work with MongoDB data using familiar SQL statements instead of the MongoDB query API.

  • Data management via SQL queries: Retrieve and manage MongoDB data by writing and executing SQL queries.
  • Full CRUD support: Run SELECT, INSERT, UPDATE, and DELETE statements against MongoDB collections.
  • Advanced SQL capabilities: Use JOINs, GROUP BY, WHERE conditions, and other SQL features, and DDL statements to create tables and indexes.
  • Native MongoDB commands: Send MongoDB commands in JSON when the Sql Engine option is turned off.

How dotConnect for MongoDB works

dotConnect for MongoDB parses the SQL query and passes it to the local SQL engine.

The engine retrieves the required data from MongoDB and processes it.

The result is returned to the application.