Using LightSwitch

The RSSBus ADO.NET Provider for NetSuite includes out-of-the-box support for tools like the designer and data source configuration wizard in Microsoft Visual Studio LightSwitch. You can follow this procedure to create a simple LightSwitch application that displays data from NetSuite in a screen.

Generate the Metadata Cache

You can improve the performance of your LightSwitch project by Caching Metadata. To cache metadata, set the CacheLocation and CacheMetadata properties. The performance gained from caching data is especially relevant in LightSwitch projects, as creating the entity model requires data about every table and column. Cache the metadata before connecting to NetSuite so that LightSwitch can pull the table schemas from the cache instead of sending a query for every table.

Connect from Your Project and Import Tables

Follow the steps below to use the Data Source Configuration wizard to configure connection properties and import tables.

1. In a new LightSwitch Project, click 'Attach to external Data Source'.
2. In the wizard that appears, select the RSSBus NetSuite Source.
3. Enter the required connection string properties. Set CacheMetadata to true. Set CacheLocation to the location of the metadata cache. A typical connection string is below:
   

   Account Id=XABC123456;Password=password;User=user;Role Id=3;Version=2013_1;Location=C:\\myfolder\\;;Cache Metadata=true;Cache Location=C:\test.db;

4. Finish the Data Source Configuration wizard by selecting the tables you would like to add to the project.

Add a Screen

Follow the steps below to add a screen and associate it with a NetSuite table.

1. In the Solution Explorer, right-click the Screens folder and click Add Screen.
2. Select the screen type.
3. In the Screen Data menu of the wizard that is displayed, select the table or view to associate with the screen.
4. To display the screen, run the LightSwitch application. The screen will automatically execute and populate with data.