Visual Studio LightSwitch
As you might know, in LightSwitch 2012 you can now add text labels that are not data-bound, which is something you could not do in the previous version except if using some tricks.
So you basically select the Add Text command in a screen:
Then you specify the text to be displayed:
Such a label is shown as Normal text but in the properties you can change this behavior by selecting a different formatting such as Warning, Note, etc.
Behind the scenes it is a TextBlock control from Silverlight, so you can definitely create nice animations so that your text message is more appealing,...
I have been recently busy in migrating a quite complex LightSwitch application from v1 (2011) to v2 (2012) and so I'd like to share some considerations that can be useful before you start the migration process.
Actually, the process is very simple but requires you to pay attention against the following situations.
Extensions and 3rd party components
If your application uses extensions or controls by 3rd party producers, it is particularly important to ensure that a version supported by Visual Studio 2012 exists. In most cases, extensions for v1 are also correctly recognized and used in v2, but this is not a rule. So,...
As you might know, one of the most important new features in the next version of Visual Studio LightSwitch, currently in beta, is the support for OData.
You can read some post from Beth Massi about this topic, today I'm just showing a different usage.
OData is an open protocol based on WCF Data Services and allows managing data sets through services. If you visit the Ecosystem page of the OData portal, you can find a list of public services from 3rd party producers, including the well-known StackOverflow web site, which offers a very popular forum platform.
Imagine you want to read your favorite threads from StackOverflow inside a LightSwitch...
When you build WCF RIA Services for Silverlight you can pass initialization information to the service, so that you can initialize fields or properties or any other members required by the same service.
When you have to create custom data source extensions for LightSwitch you still use WCF RIA Services but in a way that is a little bit difference according to some LightSwitch specific requirements. This also means that it is different the way you pass startup information to the service.
Actually you can use the connection string, which is not limited to that piece of information that you would normally use to connect to...
If you deploy a LightSwitch application as a Desktop client with local services (2-tier) and you decide to generate a SQL script for creating a database later, it might happen that you encounter the following error when running the script from SQL Server Management Studio:
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or  are not allowed. Add a name or single space as the alias name.
Don't be afraid if this happens. Go to the Query menu, then click SQLCMD Mode. Thi...
There are scenarios in which you need to send a large number of records to a database in LightSwitch or retrieve a large number of records. If the operation becomes too long, this might result in a fault due to a timeout exception. This typically happens if your data source is on a server or on a machine different than yours.
Solving timeout problems in LightSwitch can be done in several ways, some on the server side (as you would do in WCF RIA Services), but also on the client side. This requires making an edit to the Application.vb/cs file,...
One of the most frequently asked questions in the LightSwitch developer community is: how can I use LightSwitch with MySQL databases?
So I decided to try myself (since I only work with SQL Server) and this video explains what tools you need to reach the goal and how you can connect to MySQL databases and work with data in LightSwitch. There's just a couple of code snippets (yeah, VB!) that you need to write. You can easily enable the full screen view or show the offline player:
Today I have recorded a new video in which I show how to use the SQL Server Migration Assistant for Access in order to start migrating a Microsoft Access database to SQL Server that you can later use in Microsoft Visual Studio LightSwitch 2011 as an external data source.
Please note that the video explains a migration of tables and queries, but no VBA code is migrated to Visual Basic or C#. The reason is simply that it is not possible covering any possible code snippet but I think it is useful to have a starting point to begin migrating a...
I'm migrating a big Silverlight 4 project to LightSwitch and I'm at a point in which I need to implement search screens and editable grids. My requirement was using the RadGridView control from Telerik, replacing the built-in DataGrid of LightSwitch.
This implies creating a custom control. If you want to see an example, you can see my previous post about using the Telerik RadGridView in LightSwitch. The problem is that when you implement a custom control you also lose the built-in search box and data paging control, which are offered by search screens.
So my goal was implementing search in a...
On October 4th I will deliver an online session entitled Building Business Applications with Visual Studio LightSwitch 2011.
This is an entry-level Webinar hosted and promoted by DevExpress, one of the most important Microsoft partners from the developer point of view, and manufacturer of the XtraReports for LightSwitch extension.
It will be an opportunity to show LightSwitch to who has never seen it in action, but also an opportunity to receive your questions about the product.
It is scheduled for Oct. 4Th, at 10 a.m. PST. Registration is required at this address, whereas the complete list of webinars that DevExpress is offering is available at this...
Full Visual Studio LightSwitch Archive