Interview with a Visual C# MVP Wiki Ninja – Sara Silva

Today was published my interview for Wiki Ninjas blog.

” Wiki Ninjas is a group of authors who celebrate and evangelize the community catalyst and social-authoring excellence that is called TechNet Wiki “

wiki ninjas

The full interview is here:

Interview with a Visual C# MVP Wiki Ninja – Sara Silva

My first experience about my new Nokia X

In the last week I received a Nokia X device, I know that the news about it are not goods, Microsoft kills off its Nokia Android phones, but it did not died, yet.

Normally I use Nokia Lumia 925 and 920 with Windows Phone 8.1 Dev Preview and the first moments with Nokia X was to do the same I usually do when I do a hard reset or work with a new device. The first thing I do is to set my Microsoft account for upload all my contacts, but I did not find a way to do this in Nokia X and was sad for me! Another thing was taken screenshots, I use this feature a lot, and in Nokia X is possible to take screenshots pressing Volum Down + Power button, really nice.

About the contacts I can do the basic operation and I can import/export contacts or connect to my accounts, but not find a way to connect Microsoft account, like I do in WP.

Here is a sample the accounts I connected
connected contacts

The information about my device is here

about phone

Is not the Nokia X2, but is nice for explore it.


The action center is similar to Windows Phone, but in Windows Phone I have more information and options that is very useful to quicky definitions.

action center

Nokia X allow to have a track about all operation in my device, interesting in some case like a download made from website and I did not where was saved.


The lock screen is complete different from Windows Phone and I is updated constantly, for example I have some e-mail that I marked as unread and sometime the device tells me you have emails to read, even I visit the email app and quit. I did not liked it :)



Another thing I was strange for me, is related with email accounts. I setted two different emails accounts and would like to have two icons for it, but I only have one and in email I need to select each email account want to see, and the notification about the number the emails to read is relative to the email account selected… I prefer the Windows Phone way! :)

In this moment, I am using apps like facebook, twitter, skype, email, …and it has a similar experiencie as in Windows Phone.

In future, I want to try more apps and I want to see how easy is to port apps from Android to Nokia X and deploy from Xamarin.

Note: I installed an Android app that is in development and was easy, I installed only the apk! I did not need any developer account like in Windows Phone, was nice.


[TechNet Wiki] Windows Phone and Windows Store Apps Technical Guru – June 2014

Yesterday was published the The Microsoft TechNet Guru Awards! (June 2014) from TechNet Wiki and for the second consecutive month I won the

Windows Phone and Windows Store Apps Technical Guru - June 2014 

Technical Guru


I am really happy! :)

You can read my article here:

Creating Windows Phone and Window 8.1 applications using Microsoft App Studio


DataTable Design View for Azure SQL Database

This article has the goal to show a way to explore an Azure SQL Database, in especial the datatable design view.

Microsoft SQL Server Management Studio   is a great tool for management our databases, but for how is using Azure SQL Database there is an “issue” we find in the first time we try to explorer the database. When we try to see a table in design mode we cannot do it, only is possible to use SQL script, what can be a slow process for how don´t have so much experience with SQL.

Visual Studio 2013 allow to explore SQL database and has feature for show de design view.

Let’s see how it works for show an Azure SQL Database.

First in Server explorer, we need to connect to Azure account and then selecting the SQL Database we should click in “Open SQL Server Object Explorer” like we can see in the follow image:

open explorar

After this, will be show a popup to connect to the database (you maybe need to set your IP in Azure Firewall)


Now we are connected to the Azure SQL Database:


In this sample is used a free database with two scheme (dbo and testforblob).

Now we are available to see the data and see the table in design view, for it we should use the context menu:

open design

The result of “View Designer” is:


In this view we can edit the table definition using design view.

And the result of “View Data” is


In this view we can change the data about orders that is a quickly way for it, without SQL.

In conclusion, Visual Studio 2013 has a great mode to explorer database and allow to have design view for Azure SQL Database what is very useful for management databases. And the other great thing is I not need to have Microsoft SQL Server Management Studio  installed in our machine (at least for simple and basic task!)

Comunidade Portuguesa de SharePoint, 34ª reunião presencial dia 12/07/2014!


Caros SharePointianos,  no próximo Sábado dia 12/07/2014 , irá ter lugar a 34ª Reunião da Comunidade
Portuguesa de SharePoint.
É muito importante a presença de todos, e como é habitual , as reuniões da Comunidade irão decorrer presencialmente.

Atenção,  esta reunião realizar-se-á nas novas  instalações da Microsoft na Expo.

Assim, este Sábado iremos assistir às seguintes sessões:
Integrating Office 365 with Xamarin apps
Nesta sessão, a Sara Silva irá apresentar uma solução de integração do Office 365 com aplicações Xamarin tendo como principal objectivo o de maximizar o código partilhado.


Eu Sara Silva, Novabase

Bio-Sketch: Microsoft MVP – Visual C#, Nokia Developer Champion, licenciada em Matemática – Especialidade em Computação, pela Universidade de Coimbra, e  é Microsoft Certified Profissional Developer.

Atualmente o seu foco de desenvolvimento incide em Windows Phone, Windows 8 Store Apps, Xamarin e Azure.
O seu blog é e o twitter é @saramgsilva.


Beginning SharePoint Development
SharePoint is a huge Microsoft platform that is been evolving since 2001.
So “im a  newbie in SharePoint what’s out there for me ? Where and how can i start?”
In this session learn what do you have to know to start your SharePoint development, environments, drawbacks, tools, and hard sweated lessons from an developer that refuses to retired


me Rodrigo Pinto, everis

Bio-Sketch: With 15 years of experience in Software Engineering & Architecture, Rodrigo Pinto is a Solution Architect, SharePoint MVP, Specialist & Evangelist at Everis.
Responsible for the SharePoint area tends to use innovation in creating new solutions and development strategies.
Speaker since 2009 , is delivering regular sessions in Microsoft Events: Techdays, RoadtoSharePoint, Lightup SharePoint, Microsoft RoadShow, SharePoint Connections, European SharePoint Conference,User Group Meetings and online events.


He Started the SharePoint Portuguese User Group and loves the idea By and For the Community.


É um membro activo da Comunidade Portuguesa de SharePoint




09:30: Recepção dos participantes

10:00: Abertura

10:05: Sessão: “Integrating Office 365 with Xamarin apps” com Sara SilvaNovabase

11:05: Coffee-break

11:20: Sessão: “Beginning SharePoint Development” com Rodrigo Pintoeveris

12:20: Painel de discussão

13:00: Final da Reunião & Lunch

( Almoço em grupo para convívio. A participação no almoço é opcional.)

Aquele abraço, com muitos disposes à mistura !
Rodrigo Pinto, SharePoint MVP, Specialist, Evangelist
SharePointPt Founder
SharePointPT- Comunidade Portuguesa de SharePoint
SharePointPt Site:
SharePointPt no FaceBook:
SharePointPt no Twitter:
SharePointPt Email Account :;


Como chegar:

 O local do evento é no Auditório da Microsoft na Expo (perto do Oceanário)


MSFT, Software para Microcomputadores, Lda.
(Subsidiária da Microsoft Corporation)
Rua do Fogo de Santelmo, Lote 2.07.02
1990 – 110 Lisboa

Microsoft Game Dev Camp – Lisboa

Microsoft Game Dev Camp | Lisboa

Microsoft Game Dev Camp | Lisboa
Event ID: 1032590886

Microsoft Lisbon Experience

Rua do Fogo de Santelmo, Lote 2.07.02
Lisboa Lisboa 1990 – 110
Register by Email:
Language(s): English.
Product(s): Microsoft Visual Studio, Windows, Windows Azure, Windows Phone and Xbox.
Audience(s): Academic, Additional Information Worker, Designer, Developer Generalist, Marketing – Partners, NonProfessional Developer, Pro Dev/Programmer, Project Manager, Tech Influencing BDM, Tech Support – Partners and Tester.

You probably dream all day of creating the next big game. Not the next Angry | Flappy thing, but *your* game. Your idea. The one that will get everyone to talk about it on the bus, on the beach, and will drive parents and bosses nuts all around the world. The one that will have video walkthroughs done by guys 1,000kms from you, and competitions of prizes that you only see in magazines. You’re probably already on your way to make it. Or you’re starting. And on your spare time of dreaming and building that dream, you visit those amazing conference sites for Game Creators like GDC, DEVELOP, and others – on your web browser, because you can’t (yet) make the trip. Or, heck, you just build games because you love them.

We want to help you create that game – and take the next step with the ones you’re already building. Right here inPortugal

That’s why we created the first GAME DEV CAMP on the next 18th of Julytogether with some of the *hottest* names of the game developer industry, both from our country and Europe. The big event will bring together 300+ attendees who, like you, are quite literally living the dream of creating awesome games – and with 25+ sessions divided in 5 Tracks to help you choose between topics like Dev, Game Design, Visual Arts, Marketing&Management and a special track of sessions called “INSPIRE”, the hardest thing will be picking which ones to attend! We will bring you some of the best examples of games “made in Portugal” and their stories, but also a sneak peek into some of the new developments in the industry ;-)

See you in Lisbon!

The Microsoft Developer Experience & Evangelism Team



The registration for Microsoft Game Dev Camp is free (or, as we say in Portuguese, “à borlix”) and, until the 30th of June is open *EXCLUSIVELY* to all the community of game developers – and especially the ones who are building games “made in Portugal”! So, do you have a game, a startup, a project or even an idea in development for a game and you feel part of this community? All you have to do to secure one of the seats available – 250 only! – is send an e-mail with your registration data for you and every member of your team (if applicable), to GAMEDEVPT@MICROSOFT.COM.What do you need to send for each? Name, address, email, telephone and game – URL, idea description, you choose! – or, in alternative, tell us in a sentence why you deserve to be at the event) ;-)

Then you’ll receive a confirmation e-mail that you can use to brag to everyone you know – with our support!

OPEN REGISTRATION: we’ll also have some special dates where you’ll be able to guarantee your spot, if you’re not able to secure one with the requirements above! On the 1st of July between 09h00 and 19h00 (today!) we’ll make 100* seatsavailable for open registration right here on the site (on that right menu, where it says “Register” - *now open!*)! And more to come, depending on the seats still available ;-)

*first-come-first-served, and we’ll close registration when the maximum capacity is achieved!

Note: there will be a *free bus service* serving the trip Porto-Lisbon-Porto and limited seats will be managed in partnership with Nerdmonkeys and PressPlay. For more info on this special transport send an e-mail to with the title “GameDevBus: registration request” and we’ll get you in touch with the team that is organizing the trip! ;-)




Together with our friends from GameSparks, BioDroid, Gameover.Sapo.PT, Bica Studios and Nerdmonkeys, we’re polishing up the final agenda for the Game Dev Camp, which we will announce on the 1st  week of July :-)

But we’ll be launching a good set of teasers until then right here on the registration page. The best part is that these sessions will be led by some of the biggest experts on the topics both in our country (and responsible for some of the most amazing games “made in Portugal”) and beyond. Stay tuned!



Creating Windows Phone and Window 8.1 applications using Microsoft App Studio


This article aims to present the Microsoft App Studio for creating applications for Windows Phone 8.1 and Windows 8.1.

A few months ago Microsoft released Windows Phone App Studio Beta, a service that allows any person without programming skills to can create applications for Windows Phone in just 4 steps: have an idea, add content, choose style and use the application. Recently, more specifically in the Microsoft //Build/ event, that took place last April, a new version of the service was released alongside the beta version of Windows App Studio, which in addition to the Windows Phone applications, allows the creation of Windows 8.1 applications.

The service can be accessed from To start with this service, the user is required to have an account or, in case the user doesn’t have an account of these, any Microsoft Id will work. For accounts that not fits with theses, the email account can be associated with Microsoft Id, and for it the user should use the link or in login page, click in Sign up.


The first time we do the login, the website will show a screen for allow the App Studio to access our account, which can be changed later if we wish to. After this, we need to accept the terms of use and we need to define the user for the email account we are using.

At this moment, we are ready for start creating application! For it we only need to click the button “Start new project”.


App Studio provides a set of templates for help the users in creating application. Theses templates are application demos for a specific context which are more used.



Noteworthy is that all the templates are C # / XAML applications and are available for both Windows Phone 8.1 and Windows 8.1, except for the Web App Template which is only available for Windows Phone.

When selecting a template of type “Empty App” we are creating an application from scratch. This template is often used when the other templates do not meet the needs of the user or for more advanced users who already have some experience with App Studio.

The user will set all kinds of content, styles and will have to use all your creativity to build a “great app”. In the case of the “Web App Template” the user will also create the application from scratch, but in this case is given a base Url which will be the starting point of the application and have access to some buttons on “AppBar”, this template is ideal for website that suits to the mobile devices. On the other hand, other templates allow to have a quick guide
in the application we are building and we only have to change the data and customize the application.


Now, let’s see in practice how we create applications with these templates.


Contoso Ltd Template

After we select the template, a screen will be shown where we can have a first look at the app. This is a simple simulation the app for Windows Phone and Windows 8.1 that does not allow to navigate to the details pages.


This screen allows us to have an idea about the application without installing it. Let’s see the configuration for this template.



The first page shows the application name and logo (left, at the top) and shows all definitions for the content of the app, which, in this case, has five sections:

  • About us is an HTML section
  • Catalogue is a dynamic collection section
  • Team is a dynamic collection section
  • News is a Bing section
  • Contact us is a menu section which has menu actions

There’s a limit of up to six sections. After each section is created we can edit, delete or move the section position with the goal to define the best order for it.

For each section we can select one of the following options:

  • RSS – A list of sets of information based on an RSS feed that you enter when creating the data source.
  • Html – A single page of static text that you enter.
  • Youtube – A list of videos with titles and descriptions based on a YouTube channel or search that you enter when creating the data source.
  • Flickr – A list of images and their corresponding data based on a Flickr UserId or search that you enter when creating the data source.
  • Bing – A list of news
  • Facebook – A Facebook feed from a public Facebook page.
  • Instagram – a Instragram feed based in a tag
  • Menu – allow to create menu action which can use other apps (for example: using an address for Here Maps, using a phone number for make a call phone, and others)
  • Collection – A list of items with columns of characteristics. The collection can be static or dynamic and if the collection is dynamic the data can be imported or exported for a CSV file.

A future feature will be the twitter feed, but at this moment this is not available in App Studio, but was mentioned in a //build/ session on this subject.

App Studio already has a comprehensive list of data sources, allowing the user to create compelling apps. However, these data sources are based on RSS feeds which have a limited number of items and some presentation limitations


In this page, we can define the background image or the background color, define the text color and the application bar color. There are three option: custom style (using a background image), dark style and a light style. The Select button allows to define the style and then we need to save the configuration.




In the Tiles tab, we can define tiles for the application and we can select one type from the three available types: Flip Template,
Cycle Template and Icon Template. In this case was selected the Cycle Template and the respective images.

In the Splash & Lock separator, we define the images for o splash screen and for lock screen, for both apps.

This page doesn’t mention the size of the images but when we try to upload it, will be shown the allowed size if our images don´t fit those values.



In this page, the language for the app is defined. For now it is only possible to select one. It is possible to define the title, the description, and we can define if the app has an About page or even ads (but it requires development in Visual Studio). Before the finalize step it is possible to associate the app with the store, which requires a reserved name in Store Dashboard.

After all configuration we are available to finalize the app by clicking in Finish button.




On this page you can view the applications for each target platform (not being able to navigate) and it is possible to generate the application to get the application packages for install on each device and then get the source code. Clicking on the “Generate” button we get a screen where we can choose which application we want to generate.



We can generate for both cases, which implies two different generations. However, for a more experienced user that uses Visual Studio to test our application, it is recommend the generation for Windows 8.1, because the generated code is an “universal app” solution that consists of the Windows Application project Phone 8.1, Windows 8.1 application for the project, shared between the previous projects and also contains a project of type “portable class library” with the whole data structure.

After this step, we can get the application packages that allow to test the application in our devices, or we ca get the source code and then test the application in simulator or in a device using Visual Studio (but for it is a requirement to have the developer account). Is possible to install the application package directly in the device using the QRCode provided and is possible to share, in social network, the url for the application.

When we generate the application for Windows 8.1 we get this screen

Where we can get the package for the Windows 8.1 application and then we can use PowerShell to install it in our PC with Windows 8.1.


And we can get the source code, which the solution is a Universal App, whit the following structure:


With the source code, each application can be extended in order to add new features such as:

  • Add more resource strings (localization)
  • Add ads configuration
  • Add Twitter feed
  • Change the user interface

amongst others …


Web App Template

Like it was mentioned, this template is only available for Windows Phone and this is a Web App. Let’s now see in practice how we can use this template.

When we select the Web App Template we will see this page


As we can see, the content of this app is only a reference for a url, which is a website that supports mobile devices.

For example, this template uses the url, but we can change it for use any another url, like:,,, amongst other references…

The definition for Theme, Tile and Publish are the same as we saw in Contoso Ltd template.

When we click in the Finish button, we will get to a page for generating the application packages and the source code. And when we click in Generator we will see this screen


The final result of the application, using the reference is


The application from App Studio should be tested in different devices to ensure that the application works propertly and is like we defined. Only after completing the tests, the application must be submited to the store. Recall that in the Publish page we had the option to connect the application to the store, and on the final page after the generation of the application is provided in the reference to submit in store. The applications generated by App Studio will be pass in certification process like an application developed by a programmer.

For more advanced users, who wish to extend the application giving new functionality, they don´t have a way to submit the changes in the App Studio. The solution is to do a “merge” between the modified source code and the new version of the application. And starting the moment the source code is changed, the user is responsible for the creation of application packages using Visual Studio

For more information about this subject, see the curation Building apps without code using AppStudio that contains articles, videos and others resources about App Studio.


In conclusion, the App Studio presents a quick solution to develop applications for both Windows Phone and 8.1 for Windows, and we can extend the functionality of the application through the generated source code. I’d like to point out that, despite all the associated automation, there are some limitations that should be worked out in the future, so that applications generated by the App Studio will have more quality.



Adding SQLite SDK Extension to the project without installation requeriment

Today, in the Xamarin.Forms.Labs we find an error in a WP Demo, the Cache sample throw an exception each time the application try to get the implementation of ISimpleCAche

_cacheService = Resolver.Resolve<ISimpleCache> ();

But the code is right because we do this:

private void SetIoc()
            var resolverContainer = new SimpleContainer();

			var app = new XFormsAppiOS();

			var documents = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
			var pathToDatabase = "xforms.db";

			resolverContainer.Register<IDevice> (t => AppleDevice.CurrentDevice)
                .Register<IDisplay> (t => t.Resolve<IDevice> ().Display)
				.Register<IJsonSerializer, Services.Serialization.ServiceStackV3.JsonSerializer> ()
				.Register<IXFormsApp> (app)
				.Register<ISimpleCache> (t => new SQLiteSimpleCache(new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS(),
					new SQLite.Net.SQLiteConnectionString(pathToDatabase,true), t.Resolve<IJsonSerializer> () ));


The problem is, we need to add reference to SQLite for Windows Phone, without it we cannot use SQLite engine.

But it is installed in a folder in PC, and if we change the PC or share with other person, is a requirement to have it installed.
For avoid this problem i opened the cproj in notepad++ and added the lines:



and then I went to the folder that contain all SDK extensions and got it, and create my own folder in project (called SDK), here is the tree:


then when I added this to the project the path is for my folder:


Note: This SDK Extension must be updated manually!!

See my old article about similar problem, here.

I was Windows Phone and Windows Store Apps Technical Guru – May 2014

This week, was published The Microsoft TechNet Guru Awards! (May 2014)!

And I am really happy, because my article

Authentication using Facebook, Google and Microsoft account in WP8.0 App (MVVM)

was selected as the Windows Phone and Windows Store Apps Technical Guru - May 2014, and as Gold!

This article was my first article in Technet Wiki, and couldn´t be more happy :D

Related articles:

My article got Longest Article Award in TechNet Wiki