Devart.Data.MongoDB 1.0.248

ADO.NET Provider for MongoDB

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 and Entity Framework Core, while native MongoDB commands remain available.

The provider works with .NET Framework, .NET Core, .NET.

More information at dotConnect for MongoDB.

Installation

1. Install the NuGet Package

Install-Package Devart.Data.MongoDB

2. Activate license

• Free Trial License: Evaluate the full capabilities of dotConnect for MongoDB in a non-commercial environment—ideal for development and testing. Start your free trial
• Commercial License: Deploy dotConnect for MongoDB in commercial applications and access full technical support with a valid license. Purchase a license

MongoDB C Driver

The provider works through the MongoDB C Driver 1.23 (libmongoc). The Devart.Data.MongoDB package carries it for Windows x86 and x64 - libmongoc-1.0.dll, libbson-1.0.dll, sqlite3.dll of the SQL engine and the Visual C++ runtime vcruntime140.dll - and they are copied to the build output: into runtimes\win-x86|x64\native for .NET, into the Native\win-x86 / Native\win-x64 subfolders for .NET Framework. To use other copies, specify their folder with the Native Library Path connection string parameter.

Work with EF Core

For projects using Entity Framework Core with MongoDB, install the Devart.Data.MongoDB.EFCore package.

Compatibility

The following table show which version of this package to use with which version of frameworks.

Key Features

• SQL for MongoDB: Query collections with SELECT, joins and aggregates, and change them with INSERT, UPDATE, DELETE, through the built-in SQL engine.
• Native commands: Run MongoDB JSON commands and read the result documents directly.
• Transactions: BeginTransaction and TransactionScope run the commands in a MongoDB transaction on a replica set or a sharded cluster.
• Full ADO.NET Compatibility: Supports DbConnection, DbCommand, DbDataReader, DbDataAdapter, DataSet and DataTable for seamless integration into .NET applications.
• Entity Framework Core: LINQ queries and SaveChanges for MongoDB collections with the Devart.Data.MongoDB.EFCore package.
• Real-Time Monitoring: Track database operations using the dbMonitor utility.
• Visual Studio Integration: Server Explorer, typed DataSet generation and component editors in Visual Studio.
• Priority Support and Continuous Improvement: Backed by dedicated technical support and regular updates.

Usage

To help you get started quickly, here's a simple code example demonstrating how to connect to a MongoDB database and query a collection with SQL.

using Devart.Data.MongoDB;

namespace MongoDBConsoleApp
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Host=localhost;Port=27017;Database=test;User Id=user;Password=password;Sql Engine=True;License Key=**********";

            using (MongoDBConnection connection = new MongoDBConnection(connectionString))
            {
                connection.Open();

                using (MongoDBCommand command = new MongoDBCommand("SELECT name FROM customers LIMIT 10", connection))
                using (var reader = command.ExecuteReader())
                {
                    while (reader.Read())
                        Console.WriteLine(reader.GetString(0));
                }
            }
        }
    }
}

Basic Connection Strings

For more detailed tutorials, API reference, and advanced examples, visit our Getting Started guide.

Related Packages

• Devart.Data.MongoDB.EFCore

Support Area

• Documentation
• Request form
• Feedback page
• Product history