LINQ

Insert, Update, and Delete Operations of LINQ

Insert, Update, and Delete Operations You perform Insert, Update, and Delete operations in LINQ to SQL by adding, changing, and removing objects in your object model. By default, LINQ to SQL translates your actions to SQL and submits the changes to the database. LINQ to SQL offers maximum flexibility in manipulating and persisting changes that you… Continue reading Insert, Update, and Delete Operations of LINQ

iOS

Making table cells reorderable

Today let us discuss how to make UITableView cells reorderable:   Use your TableExample project from the introductory UITableViewController tutorial or download TableExample.zip as a starting point.   In FruitsTableViewController, overwrite the UIViewController method viewDidLoad and enable the editing mode for the UITableView:   override func viewDidLoad() { super.viewDidLoad() self.tableView.isEditing = true }   Alternatively, you… Continue reading Making table cells reorderable

iOS

How to parse JSON with Swift

We’ll look at how to parse a JSON array that we could use to display a list of items in a table view. More spefically, we’ll use the following JSON (copied and tweaked from David Owens II) to display a list of blog titles in our app. {     “blogs”: [         {             “needspassword”: true,             “id”: 73,… Continue reading How to parse JSON with Swift

SQL

The difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN

INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table. RIGHT JOIN: returns all rows from the right table, even if there are no matches in the left table. FULL JOIN: returns rows when… Continue reading The difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN