Category Archives: Bing

Using SalesForce and Dynamics CRM with Visual Studio LightSwitch

“Integrate the local/on-premise/cloud islands of data into low-cost, agile modern data mashup applications and can they be ready tomorrow, please!”

We received a request to see if salesforce CRM data could be made available for application integration soon followed by a similar request for Microsoft Dynamics CRM Online data.

LightSwitch Mashup Application

LightSwitch Mashup Application with added Bing, custom visualisations, OpenXML document generation, PivotViewer etc.

Microsoft Visual Studio LightSwitch was released in 2011 and provides a code-free application building experience designed to appeal to business power users. Since then we have been using it mostly as a RAD prototyping tool.

A characteristic of LightSwitch is its focus on business utility. It presents business-savvy native data types like e-mail and money, including automated validation, input masks and formatting. Although it is a really good platform, it needs extending to reach beyond being a niche product for small developments. Fortunately, it is customizable and extensible and the real power is unleashed when put in the hands of skilled .NET developers.

SalesForce Data Source in LightSwitch Dynamics CRM Data Source in LightSwitch
SalesForce and Dynamics CRM Data Sources in LightSwitch provided by Xpert360 custom adapters

Most samples and articles concentrate on extending LightSwitch using custom controls, few cover custom data extensions. We will be doing the same in some upcoming posts about data visualisation, Bing maps amd PivotViewer in LightSwitch. Going beyond this and enabling the myriad sources of business data to be consumed by LightSwitch brings new possibilities.

Rather than ‘reinventing the wheel’ we attempted to use other third-party tools but they proved to be inadequate, slow and not designed to fully unlock the potential of LightSwitch. Any commercial custom data adapter needs to be designed to support LightSwitch and other .NET technologies such as MVC3. A LightSwitch data extension that does not natively support data contract metadata, relationships and foreign keys is not really much of a LightSwitch data extension.

CRM Entities in LightSwitch designer with defaults, validation and relationships 'out-of-the-box'

CRM Entities in LightSwitch designer with defaults, validation and relationships 'out-of-the-box'

XML underpins the integration of all these application layers and services from XAML screen definitions, LightSwitch metadata, configuration settings, SOAP WDSL’s through to data serialisation and storage.

Full support for SalesForce extended metadata in LightSwitch

Full support for SalesForce extended metadata in LightSwitch

So, we designed and built our own and having to use our own software is a good driver for quality. We are currently running a private beta program for the Xpert360 Lightning Series data adapters for salesforce and Microsoft Dynamics CRM Online and are in the final stages of preparing them for general release.

The adapters support most CRUD operations subject to the security context of the connected user. They include efficient caching to speed your applications along and reduce the Web API calls.

Field-level validation inherited automatically from CRM

Field-level validation inherited automatically from CRM

Using the Web API’s requires a salesforce Enterprise Edition subscription or a developerforce account. To access the Dynamics CRM Online services requires Windows Identity Foundation for the security.

Windows Azure Demonstration accessing SalesForce data

Windows Azure Demonstration accessing SalesForce data

We also have versions of the adapters in testing for Windows Azure, other Dynamics CRM versions (security models and on-premise) and proof of concept projects for HTML5, Windows 8 WinRT and Windows Phone. The availability of support for these variations will be subject to customer demand and platform releases, not least our own application development and custom development service projects.

SalesForce Opportunity in LightSwitch Screen Designer

SalesForce Opportunity in LightSwitch Screen Designer is just a few clicks away

We have already trialled an offline support model that can provide a partial or total mirror of the CRM data. Our initial thoughts are that this will be provided as a part of an ‘Enterprise’ version and custom solutions. This feature has turned out to be an essential aid to internal product testing against a developerforce account. We will be seeking early adopters in this area later in 2012.

SalesForce data replication for offline support in MSMS

We have custom tools to enable rapid building of custom data adapters. This is useful for customers that have installed third-party extensions or modified the CRM schema. You may wish to have a custom adapter that only implements access to a small subset of CRM entities. We may offer lightweight adapters if that is an option that looks viable based upon feedback.

Data update collision detection and resolution features are scheduled for a subsequent release. There are also more features surrounding caching, paging, metadata and custom queries to come as well as non-English versions.

Any feedback or enquiries welcome at

Other useful links:


Visualization of the Windows Phone 7 Marketplace with PivotViewer

We had to take a break from blogging to allow us to catch up on work commitments. Meanwhile we have some PivotViewer linked collections deployed at the WP7 App Hub website. These collections are only a place holder for now whilst the behind the scenes infrastructure is finalised for automated build of the dynamic JIT collections for the Windows Phone 7 Marketplace applications.

We are aiming to bring some different and alternative marketplace views and give more prime time for neglected and suppressed application areas such as non-English applications, on-going new releases and indie games.

The marketplace is fragmented and difficult to navigate but not for much longer…

WP7 Raw Deal for Non-US applications

WP7 Marketplace ratings – Raw deal for non-US applications

Are non-US applications getting a raw deal in the Windows Phone 7 Marketplace?

Update 14-Dec-2010: Bing support staff sent an email saying they have a fix to ‘keyword’ search which should be rolled out later this week… It now looks like for the UK (en-GB) it is working with 3000 top apps. The keyword search appears fixed so all apps should now be searchable. So we are left with fr-FR, de-DE etc. ratings not showing. Some progress!

Absolutely! After using Europe as the ‘Guinea pigs’ in the Windows Phone 7 rollout saga Microsoft has left European WP7 developers out in the cold.

Mostly to blame is ‘Bing Visual Search’ (deservedly). Why call it ‘Search’ when it is impossible to ever find 1000 of the apps that are in the marketplace. As for ‘premier search engine’, this part certainly is woefully short of that. This is no search at all, any new apps have a brief day in the limelight, if lucky, before they sink to the depths of the marketplace. #bad => restriction to top 3000 apps in the USA ratings…

You may think, so what! My German, French, etc… users love my app and my ratings prove it. You could have lots of downloads and 5-star ratings and Bing would not care to rank you in the top 3000 apps, yeah right, that sucks! But do you believe me, well here is an affected application which is actually quite good, as in the non-USA en-US ratings say so, but Bing gives it 1-star (by 2 users) – this is an absolute joke, I feel for the publisher.

Here is Bing: Rating 1-star (by 2 users)
Bing Visual Search?

Bing Visual Search ratings poor

Bing Visual Search no use to non-USA residents.

Zune en-GB – the Brits like it a bit better!

Zune WP7 Marketplace for Tube Companion

Zune WP7 Marketplace for Tube Companion

But here is the true picture:

True WP7 Marketplace Ratings

True WP7 Marketplace Ratings

You can see the two en-US feedbacks as opposed to the 29 x en-GB and one de-DE feedbacks.

Conclusion: Microsoft, Bing, Windows Phone 7 Marketplace, you seriously need to get your act together. View it, read it and weep.

There was a partly working version of Bing Visual Search for the en-GB and de-DE regions but it was withdrawn by Microsoft on 9th December 2010 without notice.
Thanks to Tom Verhoeff for ratings page.