Infosys Microsoft Alliance and Solutions blog

« April 2011 | Main | June 2011 »

May 30, 2011

ASP.NET to Silverlight Migration

This paper on guidance on ASP.NET to Silverlight migration, that I was working on along with a colleague has finally gone live on Technology Showcase at Resource center. We have had multiple queries on guidance on how to migrate an ASP.NET application to Silverlight? So we captured all of the relevant points in this paper.

The paper can act as a checklist of sorts for various ASP.NET features and how to migrate them to Silverlight. You can download a copy of it from here. Do read it and share any comments you may have on it, here.

Finally, I am also on Kinect

It took me a while, but finally I am on Kinect. Microsoft India store seems to be out of stock on Kinect, so eventually ordered from As my colleague Naveen, had shared earlier, getting connected and starting to play was very easy. As Naveen had mentioned, Kinect XBOX console comes with a 15 amp Power plug, which makes it a bit of a challenge. This is surprising since the rating on the power adapter reads just 2 amp so a regular 3 pin 5 amp adapter should have worked. So I had to buy a 5 amp to 15 amp converter (which one can buy from your local electrical store).

Everything works like a charm. The only minor issue is the readability of text on my 32" 16:9 LCD TV. I will need to recheck the configuration and am also waiting for the HDMI cable. Hopefully it will make it a much better experience. It will be good to see support for directly plugging in my mobile broadband dongle into XBOX and connect to network, as that is what is gaining popularity these days.

May 27, 2011

State Machines are back in business!!!

State Machine workflows were part of .NET Framework 3.5. However, last year with the release .NET Framework 4 Microsoft discontinued "State Machine" workflow type. If you had to model "State Machine" functionality with .NET 4, you can still model it using Flowchart workflow authoring style. However, implementing the event driven state machine examples were that much harder.

Now exactly after a year since .NET Framework 4 release, as part of the .NET Framework 4 update 1 that got released last month, Microsoft has brought back the support for "State Machine" workflow types.
This will bring huge relief to customers who wanted to migrate.NET 3.5 state machine workflows to .NET 4

Some of the related important additions are,
• Support for SQL Azure as Workflow Instance store
• Provides max connection retries property to re-attempt a connect to database
• New activities to model compensation behavior for easy to use by new custom workflow host

For developing applications from Visual Studio 2010 SP1, you can download the install here
Note, you must be running on SP1 of VS2010 for this to work.
If you have server applications running with the .NET Framework 4 and want to update then, you need to install it from here. Steve Danileson has provided good pointers to State Machine Workflow Labs and other important changes here.

May 26, 2011

Rainbow in Cloud!!

As Cloud Computing starts becoming pervasive, more and more application patterns are considered or evaluated as fitment for running on Cloud.

Feasibility, and readiness for doing Business Intelligence (BI) on Cloud becomes one of the key asks.This is not simple and needs to be evaluated from multiple perspectives such as business, technology to the least. Business perspective would include aspects such as functionality required, cost-benefit, and elasticity of the environment, to name a few. Technology aspects would include readiness of stack to support functionality on Cloud.

BI brings out insightful information in the form of nice colorful dashboards, reports (read rainbow) that can be sliced/diced/drilled, suggest patterns for user to make informed business decisions. As such BI is a very broad topic and hence it is important to take a scenario specific approach to explore applicability in Cloud and recommend solutions.

As a potential customer willing to explore analytics/BI on Cloud, I could possibly seek solutions around some of the following scenarios, recommended solutions here are based on MS stack (on premise as SQL Server stack + off premise as Windows Azure stack)

1) Leverage Cloud for augmenting to my existing off premise BI capabilities to reduce ETL and cube processing window (Cloud bursts)

In this solution, existing BI investments running on premise is augmented with cloud computing capability by provisioning additional nodes on Windows Azure Cloud.
The pre requisite for this is on premise servers must be running on Windows Server 2008 R2 with HPC pack.

This is a typical Cloud burst type of scenario and can be most useful to reduce latency window for jobs such as ETL running using SQL Server Integration Services. Cube processing/mining in SQL Server Analysis Services is another thing for which computing nodes can be borrowed from cloud and released once done.

This approach can help in reducing the existing ETL or cube processing windows in turn making the vision of real time BI "real". It is also useful to cater to any elastic demands during peak load times such as Christmas sales.

• Is non-invasive solution and leverages existing investments
• Good for customers who are not willing to move to off premise solutions because of concerns around data security, compliance, vendor lock-in, etc.

• Tied to investment in on premise and cannot truly exploit other benefits of cloud such as cost advantages, software as a service, etc.

Moving on to next scenario,

2) My business is gathering data for each user as one large file...this could be user specific browsing/navigation history and I want to do analytics on cloud using MS Cloud stack

Such scenarios can be dealt by dumping user specific files in to Windows Azure Table/Blob storage, once done then Worker role can be used to perform certain analytics/intelligence/mining using predefined algorithms on Table Storage, with the intent of extracting and dumping results in to again Table Storage or SQL Azure in the form of areas that we want do reporting on such as max. sites visited/user,  number of hits to a specific site, max. time spent on specific site, number. of web sensed site visited, etc. as KPIs and then reporting them using SQL Azure reporting.

• Complete solution on Cloud leverages inherent Cloud advantages such as no upfront capex., elasticity, scalability, accessibility of application across devices and application boundaries

• BI features limited by what is available with Microsoft Windows Azure stack which currently is not as rich as on-premise SQL Server stack for BI.

Moving on to next scenario,

3) I have a small to medium size off premise LoB application which I would like to move to Cloud and also have basic reporting/business intelligence capability built around it

Table Storage, SQL Azure, Web role, Worker Role, and SQL Azure Reporting stack can be used to do very basic reporting and Dash boarding using Silverlight/PowerPivot.

In absence of analytical structures like Cubes, the aggregated/predefined summary tables will have to be created in SQL Azure based on identified query patterns and then SQL Azure Reporting needs to be published on top of it. Any trend analysis, pattern matching kind of work can be done using Worker role processing. As of date, there are no OoB data mining /trending algorithms in Windows Azure Cloud offering but 3rd party algorithms can be evaluated to see the integration or possibly this work can be offloaded to on premise engine and results reported back to the Cloud.

Pros and Cons of this approach would be same as mentioned in 3)

4) For large Enterprise wide implementation, moving complete BI on Windows Azure

As of date it is nearly impossible to do a pure play Microsoft Cloud solution for enterprise wide BI implementation using existing Microsoft BI Cloud stack as currently it lacks components such as integration Services, analysis services, data mining, SQL Services rich reporting, etc. In such scenario, it is best to leverage mix of on premise and off premise solutions and provide a Hybrid solution.

In a Hybrid solution, Data integration and analytics can be kept off premise and implemented using existing SQL Server Integration Services, SQL Server Analysis Services. Reporting can be done on cloud by connecting to on-premise SQL Server based Data warehouse/Data mart.

The reporting on Cloud will be as good as SQL Azure reporting, ASP.NET, Silverlight, Power Pivot richness. Performance Point Server is part of SharePoint stack, needs to be evaluated if it can be used to deploy on Web role (IIS). In a nutshell, data integration and processing off-premise and presentation on Cloud is the solution.

As such I don't see a strong fitment for complete advanced Enterprise BI on Cloud with existing MS Cloud stack due to lack of technology readiness at this point of time. However basic reporting/dash boarding/analytics can be done on Cloud.

• Hybrid pattern provides the option of marrying best of both the worlds (SQL Server and Windows Azure) by providing rich BI capabilities at the same time reaping the benefits of scale, elasticity of cloud.

• May need to manage both on premise applications and infrastructure and off premise applications

There can possibly be more variations, or permutation combination, however with the currently readiness of Microsoft Windows Azure stack, these patterns seems to be a place to start. Your thoughts/views are welcome!!

May 20, 2011

ASP.NET 4 Social Networking

Our book ASP.NET 4 Social Networking, that I wrote along with my colleague Sudhanshu Hate went live on PACKT Publishing site few weeks back. It was an interesting year long experience writing my first book. Am very grateful to Sudhanshu to have agreed to co-author this book with me.

This book is currently available for online purchase from PACKT website or from Do share your comments on the book here or on Amazon.

May 19, 2011

.NET 5

Is there next version of .NET Framework? This is a question that I have been asking myself, but no specific answers are forthcoming. Post .NET 4 and Visual Studio 2010 release, there isn't much from Microsoft on .NET 5 and Visual Studio 2012 (?)

I came across this article that talks about Visual Studio vNext and its focus on Agile development. Does this mean a shift from framework and language enhancements to a bit more on development process itself? Does this mean we are at the end of evolution of .NET and no significant new features are to be added to the framework?

What do you think? What's the future of .NET Framework?

May 12, 2011

DAL using Entity Framework VS Custom entities

Often I have seen questions over the need of Entity Framework based Data Access Layer (DAL) against Custom entities based DAL.
Here are my thoughts,
Entity Framework has significant edge over custom DAL (with custom entity) on following dimensions,

1) Entity Framework Provides O-R capability
2) Supports OoB relationship navigations. You can navigate from Customer to Orders and back without any programming overhead.
3) Supports OoB eager/late loading of objects. Can be done for any number of Navigational objects thus providing benefits of fetching data in batch as against multiple database round trips.
4) Supports multiple databases/stores through respective providers
5) Supports object modeling capability through UI designer
6) Supports OoB change tracking for Objects
7) Provides custom patterns for Thick/Smart, thin, Service oriented apps. Patterns are Entity object based, POCO and Self Tracking Entities based.
8) Provides flexibility to replace any other OR modeler with Entity Framework if used with POCO pattern.
9) Has emerged as a uniform framework from Microsoft for designing DAL and interacting with Database.
10) Best suited for Enterprise wide DAL implementation for apps connecting to multiple disparate data stores.

However the custom entities approach would only have strengths in #8, with slightly lighter object model that comes at the cost of manually supporting other aspects.

Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter