Update
This method is used to updates an existing row in the table.
Code Snippets
Below is the sample code to update a row into the [dbo].[Person]
table.
using (var connection = new SqlConnection(connectionString))
{
var person = new Person
{
Id = 10045,
Name = "John Doe",
Address = "New York",
DateOfBirth = DateTime.Parse("2020-01-01"),
IsActive = true,
DateInsertedUtc = DateTime.UtcNow
};
var updatedRows = connection.Update<Person>(person);
}
By default, the primary column is used as a qualifier. You can override it by simply passing the primary key in the
what
argument.
using (var connection = new SqlConnection(connectionString))
{
var person = new Person
{
Name = "John Doe",
Address = "New York",
DateOfBirth = DateTime.Parse("2020-01-01"),
IsActive = true,
DateInsertedUtc = DateTime.UtcNow
};
/* var updatedRows = connection.Update<Person>(person, what: 10045); // Same as below */
var updatedRows = connection.Update<Person>(person, 10045);
}
Targeting a Table
You can also target a specific table by passing the literal table like below.
using (var connection = new SqlConnection(connectionString))
{
var person = new Person
{
Id = 10045,
Name = "John Doe",
Address = "New York",
DateOfBirth = DateTime.Parse("2020-01-01"),
IsActive = true,
DateInsertedUtc = DateTime.UtcNow
};
var updatedRows = connection.Update<Person>("[dbo].[Person]",
entity: person);
}
Or via Anonymous Type.
using (var connection = new SqlConnection(connectionString))
{
var person = new
{
Id = 10045,
Name = "John Doe",
Address = "New York",
DateOfBirth = DateTime.Parse("2020-01-01"),
IsActive = true,
DateInsertedUtc = DateTime.UtcNow
};
var updatedRows = connection.Update("[dbo].[Person]",
entity: person);
}
Or via Dictionary<string, object>
or ExpandoObject.
using (var connection = new SqlConnection(connectionString))
{
var person = new Dictionary<string, object>
{
{ "Id", 10045 },
{ "Name", "John Doe" },
{ "Address", "New York" },
{ "DateOfBirth", DateTime.Parse("2020-01-01") },
{ "IsActive", true },
{ "CreatedDateUtc", DateTime.UtcNow }
};
var id = connection.Update("[dbo].[Customer]",
entity: person);
}
Specific Columns
You can also target a specific columns to be updated by passing the list of fields to be included in the fields
argument.
using (var connection = new SqlConnection(connectionString))
{
var person = new Person
{
Id = 10045,
Name = "John Doe",
Address = "New York",
DateOfBirth = DateTime.Parse("2020-01-01"),
IsActive = true,
DateInsertedUtc = DateTime.UtcNow
};
var fields = Field.Parse<Person>(e => new
{
e.Name,
e.DateOfBirth,
e.DateInsertedUtc
})
var id = connection.Update<Person>(entity: person,
fields: fields);
}
Or via dynamics.
using (var connection = new SqlConnection(connectionString))
{
var person = new
{
Id = 10045,
Name = "John Doe",
Address = "New York",
DateOfBirth = DateTime.Parse("2020-01-01"),
IsActive = true,
DateInsertedUtc = DateTime.UtcNow
};
var id = connection.Update("[dbo].[Person]",
entity: person,
fields: Field.From("Name", "DateOfBirth", "DateInsertedUtc"));
}
Table Hints
To pass a hint, simply write the table-hints and pass it in the hints
argument.
using (var connection = new SqlConnection(connectionString))
{
var updatedRows = connection.Update<Person>(person,
hints: "WITH (TABLOCK)");
}
Or, you can use the SqlServerTableHints class.
using (var connection = new SqlConnection(connectionString))
{
var updatedRows = connection.Update<Person>(person,
hints: SqlServerTableHints.TabLock);
}