[Feature Request] How can we access it using .NET?

[darcome]

Purpose of the feature.
Being able to use it from a .net 9 application.

[safern]

Hello @darcome -- could you please elaborate on what's your intent? Is your intent to connect using a MongoDB driver or just connecting directly using PostgreSQL?

[shuaitian-git]

Hi @darcome, could you help provide more context here? thanks!

[darcome]

Hi veryone, I was asking how to connect to the database using .NET, but I suppose the postgres driver can be used, and then write the documentdb commands like they were normal SQL queries, correct?

[seesharprun]

@darcome

If you're asking how to connect to documentdb using the MongoDB driver for .NET, you can follow these steps. I'm using .NET 10, but you can backport the instructions to .NET 9:

1. Run the DocumentDB container. For example, you can run it locally in Docker per (https://devblogs.microsoft.com/cosmosdb/documentdb-local-mongodb-api-on-your-machine/):

   docker run --detach --tty --publish 10260:10260 --env USERNAME=<username> --env PASSWORD=<password> ghcr.io/microsoft/documentdb/documentdb-local:latest

2. Create a new C# script file with the /.cs* extension. Put in this code for a baseline script to upsert a single item to a collection.

   #:package MongoDB.Driver@3.*
   
   using MongoDB.Driver;
   
   MongoCredential credential = MongoCredential.CreateCredential(
       databaseName: "admin", // Must be authentication database
       username: "<username>",
       password: "<password>"
   );
   MongoClientSettings settings = new()
   {
       Credential = credential,
       Server = new MongoServerAddress("localhost", 10260),
       UseTls = true,
       AllowInsecureTls = true
   };
   MongoClient client = new(settings);
   
   IMongoDatabase database = client.GetDatabase("<database-name>");
   IMongoCollection<Product> collection = database.GetCollection<Product>("<collection-name>");
   
   ReplaceOneResult result = await collection.ReplaceOneAsync<Product>(
       filter: d => d._id == "aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb",
       replacement: new Product(
           _id: "aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb",
           category: "gear-surf-surfboards",
           name: "Yamba Surfboard",
           quantity: 12,
           price: 850.00m,
           clearance: false
       ),
       options: new ReplaceOptions { IsUpsert = true }
   );
   
   Console.WriteLine($"MATCHED:\t{result.MatchedCount}");
   Console.WriteLine($"MODIFIED:\t{result.ModifiedCount}");
   
   record Product(
       string _id,
       string category,
       string name,
       int quantity,
       decimal price,
       bool clearance
   );

3. Run the script file:

   dotnet run <filename>.cs

Important

Don't forget to replace the <username> and <password> placeholders.

[safern]

@darcome - that is correct. You can just use a .NET postgres driver like Npgsql and run postgres queries using our postgres APIs.