C#

Richard Deeming wrote:

You can't change attributes at run-time;

public async Task<IActionResult> Get(int id, CancellationToken cancellationToken)
{
    Group someGroup = await context.Groups.Include(g => g.Users).FirstOrDefaultAsync(g => g.Id == id, cancellationToken);
    if (someGroup is null) return NotFound();
    
    return Ok(new
    {
        someGroup.Id,
        someGroup.Name,
        someGroup.SomeOtherProperty,
        Users = someGroup.Users.Select(user => new
        {
            user.Id,
            user.Username,
            user.EmailAddress,
        }
    });
}

Gerry Schmitz wrote:

stop retrieving at the appropriate level

DerekT-P wrote:

I'm just surprised there's not more control over serialisation!

DerekT-P wrote:

There are use cases where I want certain related objects, and others where I don't. There are multiple combinations of multiple objects. I guess it might be possible to artificially construct classes that have the required lower levels in various combinations, but that would be bringing aspects of user interface design over into the class structure of the business layer

Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

if (textBox6.Text != "" && textBox7.Text != "" && textBox8.Text != "")

Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

string query = "update employee set employee_id='" + this.textBox6.Text + "',employee_name='" + this.textBox7.Text + "',employee_salary='" + this.textBox8.Text + "' where employee_id='" + this.textBox6.Text + "';";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Parameters.AddWithValue("@employee_id", id);
cmd.Parameters.AddWithValue("@employee_name", name);
cmd.Parameters.AddWithValue("@employee_salary", salary);

string query = "UPDATE employee SET employee_name=@empName, employee_salary=@empSalary WHERE employee_id=@empId";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Parameters.AddWithValue("@empId", id);
cmd.Parameters.AddWithValue("@empName", name);
cmd.Parameters.AddWithValue("@empSalary", salary);

cmd.ExecuteNonQuery();
DialogResult dr = MessageBox.Show("Are you sure to update row?", "Confirmation", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
MessageBox.Show("Record Updated Successfully");