C# to get database and collection in cosmos db sql api

Question

I am writing C# application where trying to retrieve database and collection using following connection strings. But not sure what I am missing.

const string cosmos = @"<connection-string>";
const string cosmos_database = "Enctr";
const string cosmos_collection = "account";

SqlConnection client = new SqlConnection(cosmos);
var database = client.GetDatabase(cosmos_database);
var collection = database.GetCollection<BsonDocument>(cosmos_collection);

Its not allowing me to use below 2 lines:

var database = client.GetDatabase(cosmos_database);
var collection = database.GetCollection<BsonDocument>(cosmos_collection);

SqlConnection is not a cosmos db client, totally different thing — Crowcoder
– Crowcoder, Commented Mar 10, 2021 at 1:23
Have a try this: CosmosClient client = new CosmosClient(cosmos); var database = client.GetDatabase(cosmos_database); var collection = database.GetCollection<BsonDocument>(cosmos_collection); — Steve Johnson
– Steve Johnson, Commented Mar 10, 2021 at 1:24
Thanks Steve. It complains about CosmosClient. I tried to include using Microsoft.Azure.Cosmos; but it doesn't allow — Dinesh Madhup
– Dinesh Madhup, Commented Mar 10, 2021 at 1:40
I installed Microsoft.Azure.Cosmos package for CosmosClient. However, the line var collection = database.GetCollection<BsonDocument>(cosmos_collection) is not allowed. It says - "Database doesn't contain definition for GetCollection....." — Dinesh Madhup
– Dinesh Madhup, Commented Mar 10, 2021 at 1:49

Steve Johnson · Accepted Answer · 2021-03-10 02:13:31Z

2

As @Crowcoder says, SqlConnection is not a cosmos db client, you should use CosmosClient and use GetContainer() to get your container in Cosmos DB. Try the following code:

const string cosmos = @"<connection-string>";
const string cosmos_database = "Enctr";
const string cosmos_collection = "account";

CosmosClient client = new CosmosClient(cosmos);
var database = client.GetDatabase(cosmos_database);
var collection = database.GetContainer(cosmos_collection);

answered Mar 10, 2021 at 2:13

Steve Johnson

8,8081 gold badge11 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# to get database and collection in cosmos db sql api

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related