# Update documents

## Update one document

To update a document in MongoDB you need to configure 2 basic things:

1. A filter definition that defines which document should be updated
2. An update definition that defines what should be updated in the matched document

After configuring the above two, you use the `UpdateOne` method on an `IMongoCollection<T>` reference.

{% tabs %}
{% tab title="Syntax" %}

```csharp
IMongoCollection<T>
    .UpdateOne(FilterDefinition<T> filter, 
                UpdateDefinition<T> update)
```

{% endtab %}
{% endtabs %}

The following example updates the phone number of a user's document filter by its *id*.

{% tabs %}
{% tab title="C#" %}
{% code title="UpdateDocuments.cs" %}

```csharp
var personsCollection = usersDatabase.GetCollection<User>("users");

// Create an equality filter
var filter = Builders<User>.Filter
    .Eq(person => person.Id, appPerson.Id);

// Create an update definition using the Set operator    
var update = Builders<User>.Update
    .Set(person => person.Phone, "123-456-789");

// Update the document
var personUpdateResult = await personsCollection.UpdateOneAsync(filter, update);
if (personUpdateResult.MatchedCount == 1 && personUpdateResult.ModifiedCount == 1)
{
    Utils.Log( $"Document {appPerson.Id} Updated");
}
```

{% endcode %}
{% endtab %}

{% tab title="Bson" %}

```csharp
// Get a collection reference
var bsonPersonCollection = usersDatabase.GetCollection<BsonDocument>("users");

// Create an equality filter
var bsonSingleFilter = Builders<BsonDocument>.Filter.Eq("_id", appPerson.Id);

// Create a Set update definition
var bsonUpdate = Builders<BsonDocument>.Update.Set("phone", "123-456-678");

// Update the document
var bsonPersonUpdateResult = 
    await bsonPersonCollection.UpdateOneAsync(bsonSingleFilter, bsonUpdate);
if (bsonPersonUpdateResult.MatchedCount == 1 && 
    bsonPersonUpdateResult.ModifiedCount == 1)
{
    Utils.Log("Person updated");
}
```

{% endtab %}

{% tab title="Shell" %}

```javascript
db.users.updateOne(
{_id: ObjectId("5e8a35e2cc20587f34f0cc48") }, 
{ $set: {  phone: "123-456-789" }})

--------------------
// sample result
{
	"acknowledged" : true,
	"matchedCount" : 1,
	"modifiedCount" : 1
}

--------------------

// sample document
{
	"_id" : ObjectId("5e89b1db4cd4d45b2039f401"),
	"gender" : 1,
	"firstName" : "Jo",
	"lastName" : "Goyette",
	"userName" : "Jo.Goyette",
	"avatar" : "https://s3.amazonaws.com/uifaces/faces/twitter/colgruv/128.jpg",
	"email" : "Jo.Goyette32@yahoo.com",
	"dateOfBirth" : ISODate("1995-09-13T17:24:30.390+03:00"),
	"address" : {
		"street" : "658 Batz Parks",
		"suite" : "Suite 166",
		"city" : "Lake Veronica",
		"state" : "New Mexico",
		"zipCode" : "09760-2248",
		"geo" : {
			"lat" : 41.4404,
			"lng" : 110.3882
		}
	},
	"phone" : "488-973-7447",
	"website" : "kavon.org",
	"company" : {
		"name" : "Rodriguez, Cormier and West",
		"catchPhrase" : "Focused interactive frame",
		"bs" : "visualize clicks-and-mortar ROI"
	},
	"salary" : 4043,
	"monthlyExpenses" : 2428,
	"favoriteSports" : [
		"Moto GP",
		"Water Polo",
		"MMA",
		"Baseball",
		"Formula 1",
		"Basketball",
		"Darts",
		"Cricket",
		"Ice Hockey",
		"Snooker",
		"Boxing"
	],
	"profession" : "Visual Designer"
}
```

{% endtab %}
{% endtabs %}

{% hint style="info" %}
&#x20;`UpdateOne` method returns an `UpdateResult` result that indicates the result of the update operation.&#x20;

1. **MatchedCount**: The number of documents matched your filter definition
2. **ModifiedCount**: The number of documents updated
3. **IsAcknowledged**: Indicates whether the result is acknowledged
4. **UpsertedId**: The ***upserted*** id, if one exists

Remember that if the document already has the same value that you want to update to, `modifiedCount` will be 0
{% endhint %}

## Update multiple documents

To update many documents at once, follow the same process but this time use the `UpdateMany` method.

{% tabs %}
{% tab title="Syntax" %}

```csharp
IMongoCollection<T>
    .UpdateMany(FilterDefinition<T> filter, 
                UpdateDefinition<T> update)
```

{% endtab %}
{% endtabs %}

The following example filters user documents having *salary* greater than 1200 and less than 3500 and set the *salary* value to 4000.

{% tabs %}
{% tab title="C#" %}
{% code title="UpdateDocuments.cs" %}

```csharp
// Create a filter by combining a Greater & Less than filters
var salaryFilter = Builders<User>.Filter
    .And(
        Builders<User>.Filter.Gt(person => person.Salary, 1200),
        Builders<User>.Filter.Lt(person => person.Salary, 3500)
        );

// This is just for demonstration - validate the update result
var totalPersons = await personsCollection
    .Find(salaryFilter).CountDocumentsAsync();

// Create an update definition using the Set operator 
var updateDefinition = Builders<User>.Update
    .Set(person => person.Salary, 4000);

var updateResult = await personsCollection
    .UpdateManyAsync(salaryFilter, updateDefinition);

if (updateResult.MatchedCount.Equals(totalPersons))
{
    Utils.Log($"Salary has been updated for {totalPersons}");
}
```

{% endcode %}
{% endtab %}

{% tab title="Bson" %}

```csharp
// Create a filter by combining a Greater & Less than filters
var bsonSalaryFilter = Builders<BsonDocument>.Filter
    .And(
        Builders<BsonDocument>.Filter.Gt("salary", 1200),
        Builders<BsonDocument>.Filter.Lt("salary", 3500)
    );

// Create an update definition using the Set operator 
var bsonUpdateDefinition =
    Builders<BsonDocument>.Update.Set("salary", 4000);

var bsonUpdateResult = await bsonPersonCollection
    .UpdateManyAsync(bsonSalaryFilter, bsonUpdateDefinition);
```

{% endtab %}

{% tab title="Shell" %}

```javascript
db.users.updateMany(
    { $and: [{ salary: { $gt: 1200} }, {salary: { $lt: 3500} }] },
    { $set: { salary: 4000  } }
)

--------------------

// sample result
{
	"acknowledged" : true,
	"matchedCount" : 20,
	"modifiedCount" : 20
}
```

{% endtab %}

{% tab title="Data" %}

```javascript
// sample data
{
	"_id" : ObjectId("5e89b1db4cd4d45b2039f401"),
	"gender" : 1,
	"firstName" : "Jo",
	"lastName" : "Goyette",
	"userName" : "Jo.Goyette",
	"avatar" : "https://s3.amazonaws.com/uifaces/faces/twitter/colgruv/128.jpg",
	"email" : "Jo.Goyette32@yahoo.com",
	"dateOfBirth" : ISODate("1995-09-13T17:24:30.390+03:00"),
	"address" : {
		"street" : "658 Batz Parks",
		"suite" : "Suite 166",
		"city" : "Lake Veronica",
		"state" : "New Mexico",
		"zipCode" : "09760-2248",
		"geo" : {
			"lat" : 41.4404,
			"lng" : 110.3882
		}
	},
	"phone" : "488-973-7447",
	"website" : "kavon.org",
	"company" : {
		"name" : "Rodriguez, Cormier and West",
		"catchPhrase" : "Focused interactive frame",
		"bs" : "visualize clicks-and-mortar ROI"
	},
	"salary" : 4043,
	"monthlyExpenses" : 2428,
	"favoriteSports" : [
		"Moto GP",
		"Water Polo",
		"MMA",
		"Baseball",
		"Formula 1",
		"Basketball",
		"Darts",
		"Cricket",
		"Ice Hockey",
		"Snooker",
		"Boxing"
	],
	"profession" : "Visual Designer"
},

/* 2 createdAt:4/5/2020, 1:24:27 PM*/
{
	"_id" : ObjectId("5e89b1db4cd4d45b2039f400"),
	"gender" : 1,
	"firstName" : "Krista",
	"lastName" : "Terry",
	"userName" : "Krista2",
	"avatar" : "https://s3.amazonaws.com/uifaces/faces/twitter/thatonetommy/128.jpg",
	"email" : "Krista56@gmail.com",
	"dateOfBirth" : ISODate("1962-01-01T08:33:16.332+02:00"),
	"address" : {
		"street" : "2129 Littel Ranch",
		"suite" : "Apt. 754",
		"city" : "Lake Mekhiland",
		"state" : "Maine",
		"zipCode" : "82783-2819",
		"geo" : {
			"lat" : 80.7146,
			"lng" : -160.1533
		}
	},
	"phone" : "1-900-550-1115 x68908",
	"website" : "burley.biz",
	"company" : {
		"name" : "Toy LLC",
		"catchPhrase" : "Cloned encompassing emulation",
		"bs" : "architect 24/365 networks"
	},
	"salary" : 4514,
	"monthlyExpenses" : 6098,
	"favoriteSports" : [
		"Basketball",
		"Volleyball",
		"Formula 1",
		"Darts",
		"Baseball",
		"Table Tennis",
		"Ice Hockey"
	],
	"profession" : "Founder / Entrepreneur"
}
```

{% endtab %}
{% endtabs %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://chsakell.gitbook.io/mongodb-csharp-docs/getting-started/quick-start/update-documents.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
