public Task Get(int id) { using (var command = _connection.CreateCommand()) { command.CommandText = @"SELECT * FROM Task WHERE Id = @taskId"; command.AddParameter("taskId", id); command.ExecuteNonQuery(); return(ToList(command).First()); } }
public void Create(CheckListItem item) { using (var command = _connection.CreateCommand()) { command.CommandText = @"INSERT INTO CheckListItem (Name, Description, [Order], TaskId, Done) VALUES(@name, @description, @order, @taskId, @done)"; command.AddParameter("name", item.Name); command.AddParameter("description", item.Description); command.AddParameter("order", item.Order); command.AddParameter("taskId", item.TaskId); command.AddParameter("done", Convert.ToString(item.Done)); command.ExecuteNonQuery(); } }