Export data to Microsoft Excel with Telerik.Windows.Documents.Spreadsheet.dll.

In WCF Data Services there is a set of not supported LINQ queries and you will get NotSupportedException if you try to group RadGridView for WPF bound directly to such IQueryable or through QueryableCollectionView/VirtualQueryableCollectionView.

Yesterday I've made small example application to demonstrate how to utilize our virtual collection with unknown data and I've decided to blog it. The idea was to have two RadListBox instances and a single RadGridView. The first RadListBox for the DbSet names from a given DbContext, the second RadListBox for the property names with ability to select only some of the properties and the actual data in RadGridView bound to virtual collection:

As you may know you cannot use ILMerge to merge assemblies with XAML (WPF application) however there is a little known trick you can use to achieve your goal in a bit different way.

With this post I will show you how to consume Visual Studio 2012 LightSwitch OData services to enable server sorting, filtering, paging, etc. for your custom LightSwitch component:

 

1) Create new LightSwitch application, add some database connection (in my case I’m using Northwind on my SQLEXPRESS instance) and screen:

 

2) Add new separate Silverlight project (class library) with a custom UserControl to the LightSwitch application, similar to my previous blog post, and select the custom control to be...

With this post I would like to show you how you can customize easily paging behavior in Microsoft Visual Studio 2012 LightSwitch using Telerik RadDataPager for Silverlight.

1) Create new LightSwitch project, connect to desired data source and add new screen:

2) Add new Silverlight Class Library to the same solution where you can implement your own custom logic:

3) Add references to Telerik and LightSwitch binaries and declare RadGridView and...

In the early days of Silverlight binding support for advanced dynamic scenarios was very limited (remember my DataTable?). Since then, however, the platform has evolved greatly – so did our tools!

 

Dynamic code 2009 style:

 

Dynamic code 2011 style:

 

Now to bind RadGridView to some dynamic data you just need ObservableCollection<dynamic>:

 

RadGridView will auto-generate columns automatically using your DynamicObject GetDynamicMemberNames() implementation and will call your TryGetMember/TrySetMember (TryGetIndex/TrySetIndex in case of indexer binding) methods when needed.

 

To illustrate this I’ve made small example project (similar to this blog post) demonstrating...

Last week (MIX 2011), Microsoft released the second Visual Studio Async CTP and I’ve decided to give it a try and implement one of my blog posts related to our Silverlight Data Virtualization with WCF RIA Services.

To do this I’ve made two extension methods for DomainContext: LoadAsync<T>() and CountAsync<T>().

The first method will return the entities from a EntityQuery<T> and the second will return asynchronously count for the specified query.

 

And here is the result:

 

As you can see the only hardcoded value here is LoadSize for the virtual collection and everything else is retrieved and applied asynchronously using...

Similar to my previous post, I've made small example to illustrate how to use Telerik Reporting in Microsoft LightSwitch Beta 2.

1) Create new LightSwitch project and add new screen:
 

 

 

 
2) Switch to File View, add references to the Silverlight assemblies in Client project, add new UserControl and declare an empty ReportViewer:

 

 

 
3) Add custom control in the screen designer and run the application to check the result:

 

* Don't forget to add references to the Telerik...

Have you seen Microsoft LightSwitch? If not you should try it! This is definitely a simpler way to create high-quality business applications for the desktop and the cloud.

While the built-in interface (standard Microsoft Silverlight components) can be used as a start when creating applications you will definitely need custom screens depending on your business scenario and I’ve decided to show you can easily integrate Telerik RadControls for Silverlight in Microsoft LightSwitch Beta 2:

1) Create new LightSwitch project and connect to some data source: 

2) Switch to File View in your Solution Explorer, add references to desired Telerik assemblies, add new UserControl and build the project:

3) Add new screen,...