Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

5. Application Integration

Chapter 5. Application Integration

For this final chapter, I will address connecting a LightSwitch application to multiple external data sources, starting with Excel files. It’s a pretty safe assumption that where you find Microsoft SharePoint, you’ll also find Microsoft Office. Exporting data to Microsoft Excel is a built-in capability of the product. Importing data from either Excel or a comma separated value (CSV) file requires an extension but brings with it some added functionality. Having the ability to both import and export data makes it possible to move data between different systems.

Using Microsoft SQL Server Express 2008 for the underlying database is fine if you have total control over the data, but it’s not an uncommon task to need to connect to other databases. I’ll show you how to directly connect to a SQLite database using a freely available download. The other big topic for this chapter is integrating with cloud services like Google. While you could write a lot of code to connect with Google Calendar, I’ll be using a third-party extension that only requires a few lines of code to implement.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint