Getting productive with WAMS: how to update data for a specific row in a table


Like I promised, I will share some of the Azure goodness I learned during creating my last app.

This post is all about how to update a specific table entry (like a user’s data) in a Azure SQL table from an Windows Phone app.

First, we need to make sure that there is some data from the user we want to update. I used the LookupAsync () method to achieve that.

IMobileServiceTable<userItems> TableToUpdate = App.MobileService.GetTable<userItems>();
IMobileServiceTableQuery<userItems> query = TableToUpdate.Where(useritem => useritem.TwitterId == App.TwitterId);

var useritemFromAzure = await query.ToListAsync();
var useritemLookUp = await TableToUpdate.LookupAsync(useritemFromAzure.FirstOrDefault<userItems>().Id);

If we want a specific entry, we need a search criteria to find our user and fetch the id of the user’s table entry. In my case, I used the Twitter Id for the query as every user has this on my project.

Now that we have the table row id, we can easily update the data of this specific row with the UpdateAsync() method.

We need to declare which columns should be updated and asign the values to it first. After that, we simply call the UpdateAsync() method.

useritemLookUp.TwitterId = App.TwitterId;
useritemLookUp.LastCheckedAt = DateTime.Now;
useritemLookUp.OSVersion = "WP8";
useritemLookUp.AppVersion = App.VersionNumber;

await TableToUpdate.UpdateAsync(useritemLookUp);

Please note that you need a items class/model to create the update data (which you should have already before thinking about updating the data).

You should wrap this code in a try{}/catch{} block to be able to react to the Exceptions that possibly can be thrown and display a matching message to the user.

That’s already all about updating a specific row in a WAMS SQL table.

As always I hope this post is helpful for some of you.

Happy coding!

Posted by msicc in Azure, Dev Stories, 1 comment

The WinPhan is joining msicc.net!

Well, I’m back. Some of you know me from Twitter, Facebook, and various WP news blog sites as WinPhan7. For those that don’t know me, nice to meet you. I’ve evolved slightly, I now go by a more encompassing title: The WinPhan, but you can also call me Sean. I’m not a developer, although I am interested in learning the trade. In all honesty, I use a chainsaw in the woods for a living…but MAN, do I love technology! More than that, I admire what Microsoft is doing to innovate technology!

I’m not going to make my first post too long, as you read more of my articles you’ll see I can be long winded on my soapbox. So here’s a little about myself and my love for Microsoft. I’ve never been a fan of Apple, their proprietary malarkey, the way they take advantage of their faithful consumer base, or their iPoop products! I have even more disdain for Google, their horrid mess of a mobile OS, their antics, and their dishonest ways! Don’t get me wrong, I don’t think Microsoft can walk on water. They’ve made some not so popular decisions, but speaking in terms of the past few years it’s my honest opinion that you would be hard pressed to find ANY company in ANY industry that has matched the innovation and positive movement that Microsoft has. With the release of Windows 8 and all that it encompasses, it’s a work of absolute beauty to me.

I’m married and have 2 out of our 4 kids still living at home so we have many Microsoft products. Currently we have the Xbox360, 9 Windows Phones(2 HTC 7 Pros, 2 HTC Titans, 1 Samsung Focus S, 2 Nokia Lumia 900’s, and 2 Nokia Lumia 920), 3 laptops(Acer Aspire with Windows 7, HP G72 with Windows 7, and my little HP Pavilion g6 is now running Windows 8), and a Zune HD. We even have a couple desktops and a couple Windows Mobile Phones sitting around, suffice to say, we are a Microsoft home.

The Windows Phone experience is what turned it all into a real passion for me though, yes even pre-Mango was a beautiful experience for me. It all just made sense, what it was, what was soon coming, and what needed to be done in the future. Here I sit now able to enjoy my Lumia 920 running WP8 and think a couple years back to the moment when the sales person tried to talk me into an Android as opposed to the little giant HTC 7 Pro. Best tech decision I ever made was right then! I’m blown away by the support Windows Phone offers, I’m blown away at how dedicated our dev community is, and I’m blow away by how unified and interactive our WinPhan community is! Like many of the readers here, I’m proud to have been part of Microsoft’s ground movement from the beginning, I’m a proud WinPhan!

I ‘ve got lots to say but I’ll save that for future posts. I’ll be writing more consistently now that winter nears and I find myself indoors a lot more. Thanks for reading and you can catch me on Twitter: @TheWinPhan



Posted by TheWinPhan in Microsoft, Windows, Windows Phone, Xbox, 7 comments
Windows Phone 8 – the next generation

Windows Phone 8 – the next generation

Today I will write about my impressions on Windows Phone 8, the next generation of Windows Phone. First thing I can tell you: I am really impressed what Microsoft has done here.

This Post will be about my favorite features on Windows Phone 8, if anyone prefers other features, feel free to leave a comment below.

Individual start screen

Of course, the first feature I absolutely love is the new start screen. Every user can now individually change the tile sizes from small to middle to big. This way every device will have another look:


Windows Phone 8 start screen

None of the hopefully exploding numbers will look like any other. Best thing: this is one of the features that will come also to existing Windows Phones. I can´t wait to make my start screen look even more individual.

The new lock screen

Screenshot (35)

The Windows Phone 8 lock screen can be taken over by Windows Phone apps. There are several ways they can do it.

  • show images as wallpaper
  • show information from within the app as lock screen (partly/full takeover)
  • show number of new notifications

The photo above shows how the completely rewritten Facebook app for Windows Phone takes over the look screen by showing randomly changed Facebook photos.

I can’t wait to see what my fellow dev colleagues are doing to give us an awesome user experience. For my apps, I am currently investigating what possibilities I have to give you some awesomeness. With my app MSicc´s Blog it will be for sure something related to new posts, so you won’t miss any news from it. For my other apps I am currently searching a helpful way.


Benefits for the little one´s and parents: Kids corner

Screenshot (47)

Joe Belfiore demonstrated kids corner in an really awesome way. He let show his kids this awesome feature. Our kids are often asking us to let them play with our phones. We are of course afraid they could do something that they shouldn’t like sending messages or other things like this. Microsoft has done a fantastic job in adding a separated section for our kids, where we can add apps and games that are safe to use for our little stars. Can´t wait to introduce this to my 6 year old daughter (my son wants his own Windows Phone, so let’s see if he was brave enough in Santa´s eyes).

Xbox Music – finally also in Germany with pass

Screenshot (58)

As I wrote earlier, Microsoft finally unleashed Xbox Music for Windows Phone, Windows 8 and Xbox. Here are some additional features that are available in Windows Phone 8:

  • seamless syncing of Playlists and Albums
  • Xbox Music streaming via the cloud
  • apps can interact with Xbox Music
  • streaming to Xbox via SmartGlass

I am really happy that Microsoft finally added more countries to the Music Pass. If you haven´t activated your pass, you really should do it right now.


There are more awesome features:

  • SkyDrive syncing of photos, office documents
  • DataSmart
  • Voice Commanding of the phone and apps
  • Wallet
  • restructured Windows Phone Store
  • in app purchases
  • Rooms in people hub
  • many ways devs can improve their apps (I will do separate posts about them)
  • and more

I will cover them from my point of view as soon as I get my hands on a Windows Phone 8 device. Which leads me to the launch line up of Windows Phone devices:

Screenshot (61)

From left to the right we have the Lumia 920, Lumia 820 by Nokia, the Ativ S by Samsung and the 8S as well as the 8X by HTC.

What are your favorite features? Which device are you looking forward to? Leave a comment below.

Posted by msicc in Microsoft, Windows Phone, 6 comments
Fishing Knots + update to version 1.6 and some other changes

Fishing Knots + update to version 1.6 and some other changes

Today I submitted version 1.6 of Fishing Knots to the Marketplace.

It contains only a few new features:

– overhauled user interface

– integrated Italian and German language

– minor bug fixes

Here is a short video that demonstrates the new version:

Breaking changes are coming to “Angelknoten +” and “Nodi della pesca +”.

As I integrated the German and Italian language in Fishing Knots to make it easier for me to maintain the app (one is easier than three), both before mentioned apps will be discontinued.

Once you installed the update to 1.5.9, you will be prompted to install “Fishing Knots +”. The app will be free for one week to give everybody the possibility to install it for free.

Why am I doing this?

That´s relatively easy to explain: This was my first app ever and I wasn’t aware of the localization possibilities in the beginning of development. So I did three apps. Now that I know how I can integrate additional languages to an app, this has to be changed.

I am sorry for any inconvenience and hope you will understand this move.

“Fishing Knots +” will be the version I will update constantly.

Posted by msicc in my apps, 0 comments

Microsoft is preparing the real take-off of Windows Phone


Today at the SF Windows Phone Summit, Microsoft showed us a sneak peek how they are preparing the take-off of Windows Phone. First of all, according to Joe Belfiore, the following features are only a part. There will be more to come, as they did not show all consumer features.

A shared core to break into new Galaxies

Microsoft is porting over the whole Windows 8 core to Windows Phone. This leads to fantastic new possibilities, including new hardware specs:

  • Multi-core CPU support (dualcore and more!)
  • New screen resolutions: added 1280×768 (WXGA or 720p+) and 1280*720 (720p)
  • MicroSD card support
  • Internet Explorer 10
  • Wallet: enables your phone to be a wallet where you can store credit cards, coupons etc as well as carrier based billing for secure SIM capable endpoints. It enables also in-app purchases, so we will see more apps with premium content
  • Nokia Maps and Drive built in on all Windows Phones!
  • NFC wireless sharing between devices
  • Over the Air (OTA) updates for Windows Phone OS
  • 50 languages, Marketplace will be available in over 180 countries

A new cockpit

Microsoft improved the whole Start screen. What we know for now is that we will get more colors, and even more important, more tile sizes. You can watch the video below to get a feeling for what is coming:

Developers are taking seat in first row

Also for developers there is much more to come:

  • Finally Native code support (C, C++) which will lead to more powerful apps and games
  • In-app payments
  • Integration of VoIP and Video chat for all developers
  • Multitasking enhancements
  • Speech API´s
  • Cloud based compilation by Microsoft
  • Current apps will be recompiled by Microsoft for Windows Phone 8

Joe Belfiore announced already that the developer tools and coding sessions will be available later this summer.

Enterprise will be on board

  • Device encryption
  • United Extensible Firmware Interface (UEFI)
  • Remote management
  • Company Hub and apps

Existing Windows Phones

Sadly existing Windows Phones are not able to work with Windows Phone 8. But there will be a 7.8 update for existing devices.

What we know until now: the Start screen will be ported. Still we do not know any more about the other features that will come, so please try to calm down. The update will bypass all carriers, so ALL Windows Phones will be updated to this OS version.

You can read the official announcement here.

I am excited. Really excited. How about you?

Posted by msicc in Microsoft, Windows Phone, 0 comments

Microsoft improves SkyDrive


Microsoft is giving Windows Live/Microsoft account users free cloud storage. Today Microsoft released the SkyDrive for Windows app alongside some changes of SkyDrive.

First: Finally there is an official SkyDrive app for Windows desktop.


You can download it here. The app lets you manage your SkyDrive from your PC. After installing the app, the whole content will be downloaded to your PC, so you can keep your SkyDrive always synced. The SkyDrive folder integrates natively into the Windows Explorer, and supports drag&drop of files.

Second: Fetch you file through SkyDrive.com


As I reported in an earlier post, Microsoft gives us the ability to access our files from a remote PC. Only thing is that the target PC has to be on. I will test this feature in the coming days and will give you a tutorial on how to use it.

Third: SkyDrive storage updates

storage plans

Every SkyDrive user gets 7GB for free from now on. You can purchase additional storage space:

  • SkyDrive +20 GB, 8 Euro/year
  • SkyDrive +50 GB, 19 Euro/year
  • SkyDrive +100 GB, 37 Euro/year

But that´s not all. Click here to secure your 25 GB storage. All users that have been using SkyDrive before April 22nd can opt in to keep their 25 GB of free storage.

Fourth: SkyDrive for Windows Phone/other devices

Yesterday I posted about an update to version 2.0 of SkyDrive at 1800PocketPC.com. Microsoft applied this update also to their iOS and their OS X Lion version. You can download the apps at the source below.

Update 1:

Microsoft also posted a comparison of all services:


source: Building Windows 8 Blog

Posted by msicc in Microsoft, 0 comments

Microsoft releases a small update to SkyDrive


The SkyDrive Team at Microsoft announced a small update. They announced it not like usual as a blog post, but as a SkyDrive document this time.

Microsoft´s online storage now supports the Open Document Format (ODF). This format is an XML-based file format for spreadsheets, chart, presentations and word processing documents (from Wikipedia).


Until yesterday, we were able to share our SkyDrive uploads on Facebook and LinkedIn. From today on, we are also able to share them on Twitter!

As you can see on the tweet, Microsoft has now also a new short url for sharings via SkyDrive: “sdrv.ms”. Also our photos posted via Windows Phone´s people hub have this short url now instead of the primary far too long url.

Last but not least Microsoft screwed up the file size for upload in the browser to 300 MB. This will be helpful if you want to share videos. I will test this in the next few days and report about it.

Microsoft added that they have still some really big things to come soon. I am really curios how Microsoft will improve SkyDrive and what new killer features we will get.

Source: http://sdrv.ms/JbpjH4

Posted by msicc in Microsoft, 0 comments

Bing Video search updated to make searching for videos easier

Microsoft is constantly updating its Bing service, and now the video search has received an update. Once you search a video, your result page will look like this:

Screenshot (95)

If you go with your mouse over a video, it starts immediately to play. So you can see before going to the video´s page whether it is worth or not.

As you can see on the image above, you can also detail your search terms by length, resolution as well as set sources.

The most impressing thing for me is the “infinite scrolling”, which is also available on image search. You can scroll and scroll, and Bing adds automatically further results. No need to click on a “next page” button, this is providing a “fast and fluid” experience.

The update is available in all countries where Bing Video currently is available.

What do you think about this? Shot me a comment below.

source: winbeta.org via Bing

Posted by msicc in Bing, 0 comments
(Updated) Update shows up for unlocked HTC Titan and HTC Radar

(Updated) Update shows up for unlocked HTC Titan and HTC Radar

Today I received a notification on my HTC Titan that an update is available.

Well, of course I tried to update my Titan. I have a carrier version of the HTC Titan, and updated manually to the 8107.79 (because of the annoying keyboard bug).

Read my full article at 1800PocketPC.com.

Posted by msicc in Windows Phone, 0 comments