A lot of discussion around whether there’s OData support in Visual Studio LightSwitch? The answer is both “Yes and No.” No, there’s no Native support for OData in version 1 of Visual Studio LightSwitch, but “yes” there’s a workaround.
“LightSwitch v1 has native support for SQL Server and SharePoint data sources. But you can write some custom code to provide access to another data source. This post show you how to access an OData source in LightSwitch by wrapping access to in a WCF RIA DomainService,” explained Microsoft.
These instructions assume you already have an OData service available. The basic steps of creating the RIA service wrapper are as follows:
- Create a class library project.
- Add a WCF Service Reference to project to provide access to external OData source.
- Add WCF RIA DomainService to expose OData DataServiceContext.
Once your DomainService has been defined, you can add it to your LightSwitch project using via “Add New Data Source” wizard.
More Info: How to