LINQ Code and Tips
Entity Framework - Get a value of Column
pageTitle = db.Pages.Where(x => x.PageId == pageId).Select(x => x.PageTitle).SingleOrDefault();
Entity Framework - How to Get the current maximum value of a column
pageId = db.Pages.Max(x => x.PageId);
How to update a single colum value using EF 6 (.NET Framework)
private void MenuItem_Click(object sender, EventArgs e) | |
{ | |
int index = PasswordsDataGridView.Rows.GetFirstRow(DataGridViewElementStates.Selected); | |
if (index != -1) | |
{ | |
// Color | |
ToolStripMenuItem item = (ToolStripMenuItem)sender; | |
string rowcolor = item.Text; | |
int passwordId = Convert.ToInt32(PasswordsDataGridView.Rows[index].Cells["PasswordId"].Value); | |
int rowcolorId = GetRowColorId(rowcolor); | |
using (PasswordManagerContext context = new PasswordManagerContext()) | |
{ | |
Password password = context.Passwords.Find(passwordId); | |
password.RowColor = rowcolorId; | |
context.SaveChanges(); | |
} | |
ReloadPasswordsInDataGridView(); | |
// Go back to original updated record .. | |
PasswordsDataGridView.Rows[index].Selected = true; | |
} | |
} |