Posts Tagged ‘.NET’

Microsoft SQL CE 4.0 CTP 2 for Windows Desktop December 17th, 2010

Vinod Kumar

SQL Server Compact 4.0 CTP2 is the second CTP of the next generation of embedded databases from the Microsoft SQL Server family. Besides enhancing the existing desktop scenarios, SQL Server Compact 4.0 enables a new scenario whereby it can be used as a database for starter ASP.NET websites. SQL Server Compact supports simple deployment and can be xcopy deployed in the website’s bin folder.

SQL Server Compact 4.0 CTP2 significantly enhances the following features that were released earlier with the SQL Server Compact 4.0 CTP1 :

  • Installs as part of the Microsoft WebMatrix Beta. Microsoft WebMatrix which is an integrated suite of tools designed to make it easy for developers to build dynamic and secure ASP.Net Web applications. The websites can then be deployed in one-click to a third party website hosting service provider and SQL Server Compact is privately deployed along with the Website in the Bin folder.
  • Operates within the ASP.NET environment to provide the database functionality needed by the starter websites and it can also run in the medium trust environments on the web server.
  • Ability to write paging queries using the OFFSET and FETCH T-SQL Syntaxes
  • Better Support for private deployment by having a single private folder (“%ProgramFiles(x86)%\Microsoft SQL Server Compact Edition\v4.0\Private”) containing both the AMD64 and X86 binaries
  • Support for SqlCeConnection.GetSchema method to provide the metadata information of the database and its child objects.
  • Better encryption facility with the use of the latest Encryption Algorithms (AES-256 and SHA2)
  • Tested and certified to ensure that SQL Server Compact can handle the starter website load effectively and efficiently without any hangs, crashes, exceptions etc.

Post feedback and questions to SQL Server Compact MSDN Forum.
For tips and tricks visit SQL Server Compact blog.

Continue reading...


Patterns & practices- Windows Phone 7 Developer Guide December 15th, 2010

Vinod Kumar

Windows® Phone 7 provides an exciting new opportunity for companies and developers to build applications that travel with users, are interactive and attractive, and are available whenever and wherever users want to work with them. By combining Windows Phone 7 applications with on-premises services and applications, or remote services and applications that run in the cloud (such as those using the Windows Azure™ technology platform), developers can create highly scalable, reliable, and powerful applications that extend the functionality beyond the traditional desktop or laptop; and into a truly portable and much more accessible environment.

This guide describes a scenario around a fictitious company named Tailspin that has decided to include Windows Phone 7 as a client device for their existing cloud-based application. Their Windows Azure-based application, Surveys, is described in detail in a previous book in this series, Developing Applications for the Cloud on the Microsoft Windows Azure Platform. For more information about that book, see the MSDN® page at (

In addition to describing the client application, its integration with the remote services, and the decisions made during its design and implementation, this book discusses related factors, such as the design patterns used, the capabilities and use of Windows Phone 7, and the ways that the application could be extended or modified for other scenarios.

After reading this book, you will be familiar with how to design and implement applications for Windows Phone 7 that take advantage of remote services to obtain and upload data while providing a great user experience. The guide includes :-


"Introducing Windows Phone 7" provides an overview of the platform to help you understand the requirements and advantages of creating applications for Windows Phone 7. It provides a high-level description of the possibilities, features, and requirements for building applications for Windows Phone, and it includes references to useful information about designing and developing these types of applications. It also includes a glossary of terms commonly used in mobile application development. It’s probably a good idea to read this chapter before moving on to the scenarios.

"Designing Windows Phone 7 Applications" discusses planning and designing applications for Windows Phone 7. It covers the run-time environment and life cycle events for your application, how to maximize performance on the phone, and considerations for the user interface, resource management, storage, connectivity, and more.

"The Tailspin Scenario" introduces you to the Tailspin company and the Surveys application. It describes the decisions that the developers at Tailspin made when designing their application, and it discusses how the Windows Phone 7 client interacts with their existing Windows Azure-based services.

"Building the Mobile Client" describes the steps that Tailspin took when building the mobile client application for Windows Phone 7 that enables users to register for and download surveys, complete the surveys, and upload the results to the cloud-based service. It includes details of the overall structure of the application, the way that the Model-View-ViewModel (MVVM) pattern is implemented, and the way that the application displays data and manages commands and navigation between the pages. The following chapters describe the individual features of the application development in more detail.

"Using Services on the Phone" discusses the way that the Windows Phone 7 client application stores and manipulates data, manages activation and deactivation, synchronizes data with the server application, and captures picture and sound data.

"Connecting with Services" describes how the client application running on Windows Phone 7 uses the services exposed by the Windows Azure platform. This includes user authentication, how the client application accesses services and downloads data, the data formats that the application uses, filtering data on the server, and the push notification capabilities.

"Interacting with Windows Marketplace" describes how you can distribute and sell your applications through Windows Marketplace, and the restrictions and conditions Windows Marketplace places on your applications and content.

The appendices include additional useful information related to the topics described in the rest of the chapters. The appendices cover getting started with the Windows Phone developer tools; testing your applications; information about the development environments (Silverlight and XNA® development platform); a reference section for programming device capabilities, such as location services, messaging features, and the camera; information about the Prism Library for Windows Phone 7; and an overview of data and file synchronization using emerging technologies such as Microsoft Sync Framework.

Click here to download this release.


Walking on the same lines, here are some great free online Training on Making Windows Phone 7 Apps & Games. Don’t forget to check all the goodness from Channel9 Smile.

Also another must have for Windows Phone 7 development will be the Free ebook: Programming Windows Phone 7, by Charles Petzold. Feel free to download the book with the code. Will assure you it will be worth it !!!

Continue reading...


IIS Smooth Streaming Client 1.5 RTW December 13th, 2010

Vinod Kumar

IIS Smooth Streaming Client allows you to build rich Smooth Streaming experiences for both on-demand and live IIS Smooth Streaming. This release of the IIS Smooth Streaming Client allows you to build Silverlight® players for on-demand and live Smooth Streaming, with full DVR, live ad insertion, multiple camera angles, trickplay, and other rich functionalities. This kit is intended to aid your development of rich Smooth Streaming players and experiences. The IIS Smooth Streaming Client APIs provide an interface for developers and designers to easily create rich Smooth Streaming experiences using the Silverlight platform. These APIs provide support for simple operations such as Play, Pause, and Stop, and also for more complex operations such as scheduling advertisements, selecting and tracking bit rates for Smooth Streaming playback, and many more.
The IIS Smooth Streaming Client 1.5 now supports IIS Media Services manifest compression and requires IIS Media Services 4.0 or higher.The IIS Smooth Streaming Client in this release supports these high-level features:

  • Basic playback controls:
    • APIs such as Play, Pause, Stop
    • Events for playback and diagnostics
    • Properties to track position, and so on
  • Advanced playback support:
    • DVR support for Live Smooth Streaming
    • Support for tracking live events while in DVR
    • Trickplay – slow motion/fast-forward/rewind (Desktop Silverlight only, not available on Windows Phone)
    • Multiple Audio Language support
    • Text stream support for captions/subtitles (Desktop Silverlight only, not available on Windows Phone)
  • Support for offline playback scenarios
  • H.264/AAC support
  • Ad-Monetization
    • Ad playback integration – scheduling capabilities, tracking ad progress. (Desktop Silverlight only, not available on Windows Phone)
    • Live ad insertion with IIS Live Smooth Streaming. (Desktop Silverlight only, not available on Windows Phone)
    • Rich analytics with IIS Advanced Logging
    • Analytics APIs
    • Support for specifying markers/ad ingestion points outside the main manifest. (Desktop Silverlight only, not available on Windows Phone)
  • Content Protection – PlayReady integration for VC-1/H.264 content
  • Composite manifest support for scenarios such as Rough Cut Editing (RCE). (Desktop Silverlight only, not available on Windows Phone)
  • Selecting tracks for playback (for example, restrict the available bit rates, support multiple camera angles in a single stream, and so on)
  • Support for progressive download ads/content. (Desktop Silverlight only, not available on Windows Phone)

IIS Smooth Streaming Client is used in the Microsoft Silverlight Media Framework (SMF). This partnership facilitates faster player development.
For Windows Phone 7 development information please see the Windows Phone Developer portal.

Download this from:

Continue reading...


PivotViewer Extension for Reporting Services – CTP2 December 1st, 2010

Vinod Kumar

The PivotViewer Extension for Reporting Services provides an application generator that enables users to effortlessly build dynamic PivotViewer Collections on top of Business Intelligence data, inside SharePoint 2010. PivotViewer Extension for Reporting Services is a utility that enables users to effortlessly build stunning data experiences on top of their Business Intelligence data. You can:

  • Interactively explore and analyze your Business Intelligence data in a very visual and dynamic manner, using a SharePoint web part that embeds the PivotViewer Silverlight control.
  • Instantly generate a PivotViewer application for SharePoint on top of your BI data, using the tools provided.
  • Go beyond standard limitations of the PivotViewer control and define collections that span large numbers of items and use the provided WCF service for SharePoint 2010 in order to serve these collections in a scalable and high performing manner.

You can find additional information (videos, description and related links) on the home page of PivotViewer Extension for Reporting Services. Blog is here.

Download the same from MSDN here.

Continue reading...


SSIS–Excel Connection Manager Error November 29th, 2010

Vinod Kumar

Yesterday, I was playing with SSIS on my host machine and had bumped into an interesting error:

[Load Promotion Data [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC00F9304.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

[SSIS.Pipeline] Error: component "Load Promotion Data" (1) failed validation and returned error code 0xC020801C.

[Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.

Now this looked interesting because I was on a x64 bit OS, x64 bit on SQL Server but had a x86 (32 bit) Office 2010 installed when I was using my Excel Data Source. These errors were taken as-is from the “Execution Result” tab directly. The errors give away some detail that this combo is the problem. But fundamentally various search yielded me into places which stated I need to run SSIS in a x86 mode. And this is well hidden inside the Project –> Properties tab –> Configuration Properties –> Debugging menu.


Just turn the “Run64BitRuntime” option to “False”. And go ahead with your build !!! This just solved my problem.

Continue reading...